Getting ODBC to work with PHP5

[Kujp_Sucisv]

I'm trying to connect to an Access database via a system DNS called PromoDB which has a username of root but no password, and I am currently getting the following error:

Warning: odbc_connect(): SQL error: [MySQL][ODBC 3.51 Driver]Unknown database 'promodb',SQL state S1T00 in SQLConnect in fileMaintMaster.php

The line of code that generates this error is:
$access = odbc_connect('PromoDB','root','');

If anyone can point me in the right direction on this I would greatly be appreciated. Thank you.

[tsinka]

Hi,

the error message contains [MySQL][ODBC 3.51 Driver] so it looks like you need to change the driver in the system DSN to an access driver.

Thomas