Connecting to SQL server

tegwin15

I have another question. I am trying to connect to a M$ SQL server with PHP. I have used the mssql_connect that I read about in the PHP manual. When I try the line below. I get the error message

$conn= mssql_connect ('loca1', 'sa', 'password') or die ("connection error");

Fatal error: Call to undefined function: mssql_connect() in D:\defaultWeb1\sql.php on line 2

I assume this is the same as MySQL where you can just use the same line above but just with mysql_connect instead ?

Can someone help here ?

Thanks

mknudsen

Have you installed the mssql extension?
You can read about in the php manuel here .

tegwin15

yes I have. I have made sure the ntwdblib.dll is in my Windows\system32 and that the extension=php_mssql.dll is enabled in PHP.iNI.. However I am now getting the following error message when trying to do a mssql_connect..

Unknown(): Unable to load dynamic library './php_mssql.dll' - The specified module cannot be found..

Is this DLL supposed to be installed too, if so where do I get it, the manual does not say!!

mknudsen

If you followed the manul and it dosent work, then i am afraid that i can't help you, as i have no personal experience with mssql.

ezekiel

tegwin15,

I'm having the exact same problem. Did you resolve this? Please give me a headsup if you did. Thanks!

UPDATE:
Fixed. Need to edit this line:

; Directory in which the loadable extensions (modules) reside.
extension_dir = ./

change it to your extension dir; for example:
extension_dir = c:\php\extensions\