note 29483 added to function.mssql-connect

mssql_connect () ERROR due to invalid DLLs I had a problem connecting to a MSSQL database, I want to connect to a compaq insight database. Using: A workstation with: win 2K Server SP2 PHP ver 4.3 win32 MsSql 7.0 (on a remote system) IIS 5.0 (comes with win2K) What i did: * get the php_mssql.dll * get the ntwdblib.dll * configure your php.ini GET php_mssql.dll: This dll can be found in the binary zip of php 4.3 (not the self installing package) Put it in your extensions dir (extensions dir found in php.ini) In my case (default install with PHP installer) same dir as PHP.exe NOTE: I dont know what the php_mssql70.dll library is.. never found it in a distribution of PHP or on the net. GET ntwdblib.dll This dll can also be found in the binary zip of php 4.3 in the dlls subdir. put it in the system32 dir. WATCH OUT... i used a copy found on a MSSQL server, used that.. couldn't get it to work.. My function calls seamed OK, could call the mssql routines but I got a connection error When I used the dll distributed with the binary zip of php 4.3 it worked. configure your PHP.ini uncomment the php_mssql.dll in the extensions part of php.ini also check if the extensions dir is set correctly.. it should point to the dir where your extensions are located. Hope this helpes.! -- http://www.php.net/manual/en/function.mssql-connect.php http://master.php.net/manage/user-notes.php?action=edit+29483 http://master.php.net/manage/user-notes.php?action=delete+29483 http://master.php.net/manage/user-notes.php?action=reject+29483