[SOLVED] mssql undefined function

[shocker-z]

Hi im getting the general error

Fatal error: Call to undefined function mssql_connect() in E:\Liam\bksbvalidation\test.php on line 2

 

this is via a webpage (IIS windows 2003 server) yet when i run the same file from command line it attempts to connect. Any idea why this is different for IIS and php command line as using same extensions and php.ini file?

 

phpinfo() doesn't state that mssql extension is loaded either. I'm confused as to why it will load for command line but not IIS.

 

Regards

Liam

[trq]

Usually the cli version and mod_php version use two different php.ini's.

[shocker-z]

for reference the issue was that ntwdblib.dll needs to be copied from your php folder to C:\windows\system32 as soon as i did this... wallah! it's working

 

This this is more of a note for next time i have issues

 

Hope it helps atleast 1 person

 

Liam

[PFMaBiSmAd]

The proper method is to add the path to your php installation to the Windows PATH statement (reboot to get any changes made to the Windows PATH statement to take effect.) This eliminates the need to copy any files around to get any element of the php language to work under Windows (works for IIS and Apache web servers.)

[shocker-z]

Just an extra note also

 

ntwdblib.sll needs to be

 

ntwdblib.dll version 80.194.0

 

to be able to access MSSQL instances e.g. testserver\SQLEXPRESS as the server name

 

 

regards

Liam