PHP and ODBC connection -help needed

[Anon]

Hi All
I'm running win NT 4 service pack 6 with Apache 1.3.x and PHP4. I'm trying to use the ODBC functions to connect to MS Access database through PHP. This is the first time I've tried to set it up.

I've setup a system DSN through the ODBC control panel. I've gone through a number of tutorials on how to set them up from the web 🙁 but I still get this message when I try to access the data source "Warning: 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\php\createtable.php on line 9
Couldn't connect to server."

PHP code goes something like
odbc_connect("DSN=MYaccessDB", "username", "password")

I own/run the machine so checking things out isn't a problem.

Is their antything obvious that I've missed?
Any ideas would be most appreciated...
thanks
Darrel

[Anon]

Instead of:
odbc_connect("DSN=MYaccessDB", "username", "password")

...try:
odbc_connect('MYaccessDB', 'username', 'password')

KM

[Anon]

Keegan,
Just did a quick test and it appears to be working when you use
odbc_connect('db_name','user','pass')instead of
odbc_connect("DSN=db_name","user","password")

You don't know how helpful those two sentences are. I'd been looking everywhere for the answer.

Thanks heaps ....🙂))))))))) I can get back to learming PHP - kewl!