How to Configure SQL Server 2000

[ryy705]

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.

[rhodesa]

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

[ryy705]

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.

 

[rhodesa]

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

[ryy705]

Please tell me how you did it.

[rhodesa]

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