Welcome to MSDN Blogs Sign in | Join | Help

SQL Server Driver for PHP Requires the SQL Server 2005 ODBC Driver

I was banging my head against a wall for a while today trying to track down a issue that wasn't letting my PHP 5.2.8 app do a basic connection to SQL Server 2008.  I kept getting the following error.

SQLSTATE: IM002
message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I have SQL Server 2008 Express installed on my Windows Server 2008 workstation so I didn't think I would have any issues like this.  To fix it all I had to do was install the SQL Server 2005 ODBC Driver from here which is part of the Microsoft SQL Server Native Client.

Talking to the PM for our driver it sounds like the next version will have a more explicit error making this much easier to diagnose.

Technorati Tags: ,,,,

Published Monday, February 09, 2009 3:15 PM by ZachSkylesOwens
Filed under: , , , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# infoblog » SQL Server Driver for PHP Requires the SQL Server 2005 ODBC Driver

PingBack from http://blog.a-foton.ru/index.php/2009/02/10/sql-server-driver-for-php-requires-the-sql-server-2005-odbc-driver-2/

Monday, February 09, 2009 9:26 PM by infoblog » SQL Server Driver for PHP Requires the SQL Server 2005 ODBC Driver

# re: SQL Server Driver for PHP Requires the SQL Server 2005 ODBC Driver

Just to clarify...  The file you need to download is "sqlncli.msi" or "sqlncli_x64.msi" depending on your OS.

Thursday, February 12, 2009 12:46 PM by ZachSkylesOwens

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker