An odbc_connect problem with an access database

[pjfuller]

Hello,

 

i have been trying for a few hours to get the following example to work.

 

$conn  =  odbc_connect('northwind','',''  );

 

if  ($conn  <=  0)  {

     echo  "<P>Error  in  connection";

     exit($conn);

} else  {

     echo  "<P>Connection  successful\n";

};

 

The error message that comes up is

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:\Program Files\Apache Software Foundation\Apache2.2\htdocs\odbc2.php on line 12

 

Then Error in connection

I have registered an ODBC database under both (at different times) USER and SYSTEM DSN's. I have tried writing different code for different database examples I've been trying to get working. The ODBC connection are working, i have download a small program utility to test them out (Microsoft ODBC Test), so no problem there.

 

I have 2 network cards(? is this a problem?), running under Apache 2.2.9 and PHP 5.2.6 fresh installs.

 

I spent a more then a few hours looking at this problem ???, i have no other ideas. So any ideas and a hopefully a working solution would be greatly appreciated.

 

Thanks Paul