Can't connect to SQL Server via ODBC

[~john]

I just installed PHP 5.1.4 with SQL Server 2005 on my laptop. PHP is
running fine and so is SQL Server 2005. When I try to connect to SQL
Server from my my PHP code I get this error.

Warning: odbc_connect() [function.odbc-connect]: SQL error:
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified, SQL state IM002 in SQLConnect in
C:\Inetpub\wwwroot\index.php on line 5

Here's my connection string that is causing the error

$connect_id = odbc_connect("Driver={SQL
Server};Server=mydbname;Database=myDB","myUser", "myPass");
Any idea what's wrong? This is driving me nutts.. I installed PHP on my
computer at home and had no problem connecting to SQL Server. It's like
this laptop is cursed.

[Jerry Stuckle]

~john wrote:

I just installed PHP 5.1.4 with SQL Server 2005 on my laptop. PHP is
running fine and so is SQL Server 2005. When I try to connect to SQL
Server from my my PHP code I get this error.

Warning: odbc_connect() [function.odbc-connect]: SQL error:
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified, SQL state IM002 in SQLConnect in
C:\Inetpub\wwwroot\index.php on line 5

Here's my connection string that is causing the error

$connect_id = odbc_connect("Driver={SQL
Server};Server=mydbname;Database=myDB","myUser", "myPass");
Any idea what's wrong? This is driving me nutts.. I installed PHP on my
computer at home and had no problem connecting to SQL Server. It's like
this laptop is cursed.

Do you have the ODBC database registered with the correct driver?

I don't use odbc much - but most of the time I've found when it works on
one machine but not another there's a problem with how the database
and/or driver is registered (if it is at all).

It could also be a difference driver in levels; never worked with the
SQL Server driver.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================