shocker-z Posted January 31, 2008 Share Posted January 31, 2008 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 Link to comment https://forums.phpfreaks.com/topic/88739-solved-mssql-undefined-function/ Share on other sites More sharing options...
trq Posted January 31, 2008 Share Posted January 31, 2008 Usually the cli version and mod_php version use two different php.ini's. Link to comment https://forums.phpfreaks.com/topic/88739-solved-mssql-undefined-function/#findComment-454523 Share on other sites More sharing options...
shocker-z Posted February 1, 2008 Author Share Posted February 1, 2008 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 Link to comment https://forums.phpfreaks.com/topic/88739-solved-mssql-undefined-function/#findComment-455115 Share on other sites More sharing options...
PFMaBiSmAd Posted February 1, 2008 Share Posted February 1, 2008 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.) Link to comment https://forums.phpfreaks.com/topic/88739-solved-mssql-undefined-function/#findComment-455116 Share on other sites More sharing options...
shocker-z Posted February 1, 2008 Author Share Posted February 1, 2008 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 Link to comment https://forums.phpfreaks.com/topic/88739-solved-mssql-undefined-function/#findComment-455213 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.