Posted by Manuel Lemos on 09/14/05 01:13

Hello,

on 09/13/2005 04:46 PM David said the following:
> Having issues with a Pear DSN for odbc Microsoft access. The Manual
> is not too helpful and the best one I can find is
>
> odbc///map
>
> where map is the ODBC DSN name.
>
> Or does one need to create a DSN string like
>
> dbc(access)://tcp()driver=Microsoft Access Driver
> (*.mdb);dbq=C:\\htdocs\\map.mdb"
>
> 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

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:

http://www.phpclasses.org/metabase


--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html

[Back to original message]