mATOK Posted September 27, 2006 Share Posted September 27, 2006 Hi there,I am trying to connect to a Microsoft SQL server 2005 (IIS 6.0) using mssql_connect and I am returned:[b]Fatal error: Call to undefined function: mssql_connect() [/b]I am running PHP V 4.3.4I tried adding the extension in the php.ini file but when I do Apache/1.3.29 does not load....please help ??? Quote Link to comment https://forums.phpfreaks.com/topic/22259-mssql_connect/ Share on other sites More sharing options...
ober Posted September 27, 2006 Share Posted September 27, 2006 Make sure you read through the manual to verify that you've taken all the necessary steps to enable the mssql functions. There are some dlls and other items that need to be setup properly. Quote Link to comment https://forums.phpfreaks.com/topic/22259-mssql_connect/#findComment-99687 Share on other sites More sharing options...
wildteen88 Posted September 27, 2006 Share Posted September 27, 2006 Have a read of this [url=http://www.phpfreaks.com/forums/index.php/topic,95378.0.html]FAQ[/url].NOTE: That FAQ is for the mysql extension. However you can still follow it to enable the mssql extension. The mssql extension is called php_mssql.dll. Also you need to copy a file called ntwdblib.dll from MS SQL to the php installation folder, or the Windows follder (WINNT or WINNT/SYSTEM32). Have a read of [url=http://uk.php.net/manual/en/ref.mssql.php]this page[/url] for more info. Quote Link to comment https://forums.phpfreaks.com/topic/22259-mssql_connect/#findComment-99711 Share on other sites More sharing options...
mATOK Posted September 27, 2006 Author Share Posted September 27, 2006 Thanx Gents, I will try... Quote Link to comment https://forums.phpfreaks.com/topic/22259-mssql_connect/#findComment-99733 Share on other sites More sharing options...
mATOK Posted September 27, 2006 Author Share Posted September 27, 2006 the file ntwdblib.dll is not found on my SQL2005 server... is it needed? Can I grab it from somewhere else? Quote Link to comment https://forums.phpfreaks.com/topic/22259-mssql_connect/#findComment-99782 Share on other sites More sharing options...
wildteen88 Posted September 27, 2006 Share Posted September 27, 2006 According to the manual you can get this file from the MS SQL Server CD. Quote Link to comment https://forums.phpfreaks.com/topic/22259-mssql_connect/#findComment-99828 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.