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: ,,,,