ODBC problem

[rengy]

currently i am doing a program to create database in different of the sql server. i use ADODB to create the database. and when 1 try the code to create the database in mysql, it works fine. when it comes to msaccess, the error occur as :

Warning: 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 group\apache\htdocs\drivers\adodb-odbc.inc.php on line 60

i have no idea on what exactly is it about the problem. can anyone help me up with this?
thx alot

[cheese]

Hi Rengy,

Have you read the odbc_connect section in the manual.

Also looking on Google there are several answers. This one at zend.com looked like a possible answer.

Cheers,

Neil.