ryy705 Posted September 4, 2009 Share Posted September 4, 2009 hello, I have PHP5.3 running on IIS6(finally). But how can I connect to SQL Server? I do not see a reference to php_mssql.dll in php.ini. I don't even see the php_mssql.dll file in the PHP installation folder!! How can I configure PHP to work with SQL server? I am willing to to downgrade to PHP5.2 if neccessary. Please Help. Quote Link to comment https://forums.phpfreaks.com/topic/173119-how-to-configure-sql-server-2000/ Share on other sites More sharing options...
rhodesa Posted September 4, 2009 Share Posted September 4, 2009 Step 1: http://us.php.net/manual/en/mssql.requirements.php Step 2: In your php install dir, in the ext folder, make sure there is php_mssql.dll Step 3: Enabled it in your php.ini file Step 4: Restart webserver and confirm it's working with a phpinfo() page Edit: Looks like there is more info here: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ccdf728b-1ea0-48a8-a84a-5052214caad9 Quote Link to comment https://forums.phpfreaks.com/topic/173119-how-to-configure-sql-server-2000/#findComment-912472 Share on other sites More sharing options...
ryy705 Posted September 4, 2009 Author Share Posted September 4, 2009 php_mssql.dll is not in the ext folder. And there is no reference to it in the php.ini file. I made xamp work with SQL SERVER before. Their php.ini did have a reference to it. But that is not the case with the PHP Installation I downloaded from php.net. I will look into the microsoft link you just sent me right now. Thank you for your prompt response. Quote Link to comment https://forums.phpfreaks.com/topic/173119-how-to-configure-sql-server-2000/#findComment-912481 Share on other sites More sharing options...
rhodesa Posted September 4, 2009 Share Posted September 4, 2009 yeah...i did some google searching and it looks like it might not be completely supported in 5.3 i am running PHP 5.2 and have it working with MSSQL Quote Link to comment https://forums.phpfreaks.com/topic/173119-how-to-configure-sql-server-2000/#findComment-912485 Share on other sites More sharing options...
ryy705 Posted September 4, 2009 Author Share Posted September 4, 2009 Please tell me how you did it. Quote Link to comment https://forums.phpfreaks.com/topic/173119-how-to-configure-sql-server-2000/#findComment-912499 Share on other sites More sharing options...
rhodesa Posted September 4, 2009 Share Posted September 4, 2009 If I remember right...it was just: Step 1: http://us.php.net/manual/en/mssql.requirements.php Step 2: In your php install dir, in the ext folder, make sure there is php_mssql.dll Step 3: Enabled it in your php.ini file Step 4: Restart webserver and confirm it's working with a phpinfo() page but I did it with 5.2, not 5.3 Quote Link to comment https://forums.phpfreaks.com/topic/173119-how-to-configure-sql-server-2000/#findComment-912543 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.