tripleM Posted August 18, 2009 Share Posted August 18, 2009 Hi all, I'm running Windows XP, MS Sql 2005, and APACHE2.0.x. I am trying to connect php to my sql database, and I keep getting the following error from the script below: just when i tried to connect to the server, which is in other system, i am getting following error. Fatal error: Call to undefined function mssql_connect() in Fatal error: Call to undefined function mssql_connect() MSSQL functions not available. What should i do , to available and execute it succesfully? In simple words, i need connection from PHP to MS SQL Server2005. Thanks, TripleM Quote Link to comment https://forums.phpfreaks.com/topic/170785-need-to-establish-a-connection-between-php-and-sql-server2005/ Share on other sites More sharing options...
trq Posted August 18, 2009 Share Posted August 18, 2009 Uncomment the relevant extension line in your php.ini and restart your server. It'll be something like... extension=mssql.dll. Quote Link to comment https://forums.phpfreaks.com/topic/170785-need-to-establish-a-connection-between-php-and-sql-server2005/#findComment-900831 Share on other sites More sharing options...
tripleM Posted August 18, 2009 Author Share Posted August 18, 2009 Uncomment the relevant extension line in your php.ini and restart your server. It'll be something like... extension=mssql.dll. Its already done. but no use Quote Link to comment https://forums.phpfreaks.com/topic/170785-need-to-establish-a-connection-between-php-and-sql-server2005/#findComment-900835 Share on other sites More sharing options...
trq Posted August 18, 2009 Share Posted August 18, 2009 Did you restart your server after making any changes? What does the output of phpinfo say in regards to the mssql extension? Quote Link to comment https://forums.phpfreaks.com/topic/170785-need-to-establish-a-connection-between-php-and-sql-server2005/#findComment-900837 Share on other sites More sharing options...
tripleM Posted August 18, 2009 Author Share Posted August 18, 2009 Did you restart your server after making any changes? What does the output of phpinfo say in regards to the mssql extension? Please find the following lines for MSQL details. msql--> MSQL Support --enabled Allow Persistent Links -- yes Persistent Links -- 0/unlimited Total Links -- 0/unlimited Thanks, tripleM Quote Link to comment https://forums.phpfreaks.com/topic/170785-need-to-establish-a-connection-between-php-and-sql-server2005/#findComment-900897 Share on other sites More sharing options...
djclaux Posted August 18, 2009 Share Posted August 18, 2009 check if you have the latest version of the ntwdblib.dll library (2000.80.194.0) i have some ms sql connections problems that i solved with this! download the library here (http://www.dlldll.com/ntwdblib.dll_download.html) Quote Link to comment https://forums.phpfreaks.com/topic/170785-need-to-establish-a-connection-between-php-and-sql-server2005/#findComment-901001 Share on other sites More sharing options...
tripleM Posted August 19, 2009 Author Share Posted August 19, 2009 check if you have the latest version of the ntwdblib.dll library (2000.80.194.0) i have some ms sql connections problems that i solved with this! download the library here (http://www.dlldll.com/ntwdblib.dll_download.html) Thanks djclaux. My problem solved Quote Link to comment https://forums.phpfreaks.com/topic/170785-need-to-establish-a-connection-between-php-and-sql-server2005/#findComment-901655 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.