note 74783 deleted from function.mssql-connect by danbrown

Note Submitter: daslsack at hotmail dot com ---- I connected a WinXp prof ver 2002 sp2 box to a MsSQL server 2005. Here is how (Assuming the MsSQL server is already running). I installed the IIS via WinXP cd. I downloaded and ran the file: php-5.2.1-win32-installer.msi (I chose IIS + ISAPI in the installation process) I downloaded the files: ntwdblib.dll (as mentioned in various posts above) and php_mssql.dll (found it in other PHP distributions) I copied those files into the root PHP directory and modified the PHP.ini adding: extension=php_mssql.php. (note: The downloaded file php_mssql.dll may have to be put in the php\ext folder instead of the root php folder depending on your extension path) Reboot the IIS. The php code for the connection is: $this->sql_link = '0'; function connection() { $this->sql_link = mssql_connect($this->"MyHost-NotIP", this->"MySelf", $this->"SomePass"); mssql_select_db($this->"Databasename", $this->sql_link); }