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\wwwr oot\index.php on line 5

Here's my connection string that is causing the error

$connect_id = odbc_connect("D river={SQL
Server};Server= mydbname;Databa se=myDB","myUse r", "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]

Re: Can't connect to SQL Server via ODBC

~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\wwwr oot\index.php on line 5
>
Here's my connection string that is causing the error
>
$connect_id = odbc_connect("D river={SQL
Server};Server= mydbname;Databa se=myDB","myUse r", "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.
jstucklex@attgl obal.net
=============== ===