RE: [GENERAL] Accessing two differents database in a SELECT

2001-06-07 Thread Nicolas Huillard
If you use Perl, I think there is a DBI proxy driver. It works as a DBI driver for the script that uses the DB, but in fact redirects queries as a proxy, to whatever you want. Maybe it can redirect queries to many DB's ? You will just have problem with joins... NH -Message d'origine-

Re: [GENERAL] Accessing two differents database in a SELECT

2001-06-07 Thread Andrew Gould
I use MS Access as a front-end to PostgreSQL. Not only can I link tables from different PostgreSQL databases, but I can link tables from different ODBC compliant database products such as MySQL, MS Access, PostgreSQL, and Sybase. I hope this helps, Andrew Gould --- Hervé Piedvache [EMAIL