ODBC link to other databases

Started by Edward Di Geronimo Jr.about 20 years ago2 messages
#1Edward Di Geronimo Jr.
edigeronimo@xtracards.com

Hello all,

To help with my work, I've created a basic plugin that allows Postgres
to retreive data from tables on other databases via ODBC. So far I've
only tested it against MS SQL Server 2000. It's rather crude at the
moment, as the only operation supported is a SELECT * query, and it
currently requires the username/password to be hard coded into the
source code.

I was wondering if other people are interested in this enough for me to
bother with the trouble of polishing this off.

I also have no idea what would be a sane security model for this.

I'd appreciate people letting me know if there is interest in this...

Ed

#2Josh Berkus
josh@agliodbs.com
In reply to: Edward Di Geronimo Jr. (#1)
Re: ODBC link to other databases

Edward,

To help with my work, I've created a basic plugin that allows Postgres
to retreive data from tables on other databases via ODBC. So far I've
only tested it against MS SQL Server 2000. It's rather crude at the
moment, as the only operation supported is a SELECT * query, and it
currently requires the username/password to be hard coded into the
source code.

http://pgfoundry.org/projects/dbi-link/
http://pgfoundry.org/projects/dblink-tds/

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco