MSSQL problems

[rrsub]

I have 2 servers. Both MS Win2000.
Server 1 has MSSQL 7
Server 2 has MSSQL 8 (2000)

Server 2 has PHP with MSSQL support and it works well.
Server 1 won't and the settings are almost the same.

The only difference is that PHP on server 1 is newer.
I'm using ntwdblib.dll and php_mssql.dll that came with the PHP version I'm using just like server 2.

What happens is that if I enable the MSSQL extention, any PHP document hangs like phpinfo();

What am I overlooking?

Yes, the MSSQL server is installed on the same server and running IIS.

 

[sleipnir214]

On server 1, how were the MSSQL libraries installed? For example, did you perform the install, or just copy ntwdblib.dll to the server?

I'm wondering if ntwdblib.dll doesn't require additional support libraries that aren't available.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[rrsub]

I installed it just like Server 2, copied the php_mssql.dll to c:\php and ntwdblib.dll to system32.

Worked fine on Server 2

At this moment, I just removed PHP from Server 1 and I'm reinstalling.

 

[rrsub]

I would like to see some other people chime in on this one. I'm curious as to what the other users are running.

The reinstall didn't do anything. I figured that it wouldn't. The reason I thought it could be a factor is because I've done 4 PHP upgrades on this server so I removed everything.

Server 2 has MSSQL 8 which has a client version of ntwdblib.dll 8.00.194. Somehow I don't remember replacing this file because it worked just by placing the php_mssql.dll in the C:\php folder.

Server 1 has MSSQL 7 with a client version of 7.00.839. PHP 4.3.4 provides the same with version 7.00.839

All I did is take the MSSQL 8 dll and replace it and it worked.