[SOLVED] DSNless connection for Microsoft Access?

[paulusNewbius]

Hi, I have had a look around trying to learn how to connect up to a MS Access 2000 database but I’m a little confused, please help me clear something up.

Basically, I have some web space that just supports PHP and MySQL. I have a requirement to use Access instead of MySQL, and I have read the tutorial on this site about this. The tutorial says that in order to connect to the database we need a DSN (Data Source Name). I sent an email to my web host providers and asked if it is possible to set up a DSN. I told them I want to connect to an MS Access 2000 database so we need an Microsoft Access Driver.

This was their reply:

[quote]Thank you for your email. We do not supply DSNs. You would normally use a
DSNless connection to the database server where the information is specified
in the scripts you use to access the database.[/quote]

???

So I guess my question is, what do they mean? How do I setup this DSNless connection?

Many thanks for your time

[trq]

There is a user example in the [url=http://www.php.net/manual/en/function.odbc-connect.php]manual[/url].....

[code=php:0]$db_connection = odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$dbq", "ADODB.Connection", "password", "SQL_CUR_USE_ODBC");[/code]

[paulusNewbius]

Many thanks, I did not see those examples in the manual :)