Pear and ODCB Access DSNs?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Having issues with  a Pear  DSN for odbc Microsoft access.  The Manual
is not too helpful and the best one I can find is  


where map is the ODBC DSN name.

Or does one need to create a DSN string like

dbc(access)://tcp()driver=Microsoft Access Driver

Both do not work and result in a "not found" error.

Also, this works with the PHP ODBC commands, so I know that the DSN is
correctly set up


Re: Pear and ODCB Access DSNs?


on 09/13/2005 04:46 PM David said the following:
Quoted text here. Click to load it

I don't know about PEAR DB because I do not use it, but you can use  
Metabase PHP database abstraction package that has an MS Access driver  
via ODBC that lets you connect to Access databases by specify the ODBC  
DNS as the User argument of Metabase connection setup:


Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP

PHP Reviews - Reviews of PHP books and other products

Metastorage - Data object relational mapping layer generator

Site Timeline