Pear and ODCB Access DSNs?

[David]

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

Thanks

[Manuel Lemos]

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