MS SQL 2000 + PHP

yoganandk

Hi,
I am new to PHP. I have to connect to MS SQL 2000 Server from PHP. I want to know whether I have to have new Database Driver for PHP

iwaters

You don't need a new driver you just need to use the inbuilt PHP function mssql_connect("host", "username", "password").
Read the PHP manual for more details.
One thing to note though, I have been using PHP for a while mainly with MySQL, I got the trial of MS SQL 2000 but when I tried to connect to it failed. This is because I had a PHP distrubution that did not have MS SQL support configured. So if you try and connect to MS SQL and receive a fatal error: call to undefined function mssql_connect(), then check your PHP settings first before ripping your hair out.

Anon

Yep had same trouble 'Fatal error: Call to undefined function: mssql_connect' been using mysql for ages fine then it came to me and the extension in the ini.. doh!

iwaters

Richard,

I'm havin gproblems myself. I have found the php_mssql.dll extension. I have created an extensions file in my PHP folder and put the extension in there. In the php.ini file I have changed the extension dir to /extensions (is this correct?) and I have removed the semi-colon before the extension for ms sql, but I am still reciving a call to undefined function error.
What have I done wrong?

Regards

Ian