Did you check that you have enabled MSSQL extension? That is, On XP system, you should have this line 'extension=php_msql.dll' in php.ini file and the leading ';' be removed. On Ubuntu, you should also install mssql extension, which is a little more complex. There should be no problem once you have managed mssql. It talks to sql server 2005/2000 quite well. Regards, Shelley -----Original Message----- From: Alexis [mailto:phpinfo@xxxxxxxxxxxxxxx] Sent: Wednesday, January 09, 2008 6:07 AM To: php-general@xxxxxxxxxxxxx Subject: MSSQL Hi, I am pulling my hair out trying to set up PHP to connect to SQL Server. The office server, running Server 2003, has SQL Server on it. One of my computers is running XP with Apache 2.2 and PHP 5.2.3. Another one has Ubuntu Gusty Gibbon, Apache 2.2 and PHP 5.2.3 Ideally I would like to get the Linux box to connect to the main server, but I can't even get it to recognise the server, let alone create a MSSQL link, so I'll start off with the windows box. I have read all the various comments in http://ca3.php.net/mssql and have tried all the relevant ones but still no joy. It just will not connect. I have tried the ADO approach but get the following error: Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.' in D:\Apache2.2\htdocs\includes\mssqlinfo.inc:9 Stack trace: #0 D:\Apache2.2\htdocs\includes\mssqlinfo.inc(9): com->Open('Provider=SQLOLE...') #1 D:\Apache2.2\htdocs\mssql.php(3): include('D:\Apache2.2\ht...') #2 {main} thrown in D:\Apache2.2\htdocs\includes\mssqlinfo.inc on line 9 Does anyone have a definite and easy to understand set of instructions as to how to get PHP to talk to SQL Server please? Cheers Alexis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
