Thread: dblink to non postgresql dbms
Hello all,
I’m looking for a solution to query a SQL Server 2000 instance from PostgreSQL 8.3.3.
I’ve been trawling the internet for some type of solution with out any luck, I only found old references to someone talking about implementation of create database link to postgresql
Does anyone know of anything?
I’m trying to avoid having to write a C table returning function.
Any help would be much appreciated
David
David Rowley wrote: > > Hello all, > > I’m looking for a solution to query a SQL Server 2000 instance from > PostgreSQL 8.3.3. > > I’ve been trawling the internet for some type of solution with out any > luck, I only found old references to someone talking about > implementation of create database link to postgresql > > Does anyone know of anything? > > I’m trying to avoid having to write a C table returning function. > > Any help would be much appreciated > Maybe these things from pgfoundary might help http://pgfoundry.org/projects/dbi-link/ http://pgfoundry.org/projects/odbclink/ http://pgfoundry.org/projects/dblink-tds/ -- Klint Gore Database Manager Sheep CRC A.G.B.U. University of New England Armidale NSW 2350 Ph: 02 6773 3789 Fax: 02 6773 3266 EMail: kgore4@une.edu.au
Klint Gore wrote: > Maybe these things from pgfoundary might help > > http://pgfoundry.org/projects/dbi-link/ > > http://pgfoundry.org/projects/odbclink/ > > http://pgfoundry.org/projects/dblink-tds/ Thank you for the links. I'm just getting into looking at them now. I had forgotten to say before that my instance of postgresql is running on windows. I can't seem to find any evidence of freetds running on windows, I guess there is not a great deal of need since MS's native client is there. So I'm thinking of re-writing the dblink-tds to use Mircosoft's native client rather than tds. The odbclink does not have any files yet, but looks like exactly what I'd need. David. -----Original Message----- From: Klint Gore [mailto:kgore4@une.edu.au] Sent: 27 June 2008 00:45 To: David Rowley Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] dblink to non postgresql dbms David Rowley wrote: > > Hello all, > > I'm looking for a solution to query a SQL Server 2000 instance from > PostgreSQL 8.3.3. > > I've been trawling the internet for some type of solution with out any > luck, I only found old references to someone talking about > implementation of create database link to postgresql > > Does anyone know of anything? > > I'm trying to avoid having to write a C table returning function. > > Any help would be much appreciated > Maybe these things from pgfoundary might help http://pgfoundry.org/projects/dbi-link/ http://pgfoundry.org/projects/odbclink/ http://pgfoundry.org/projects/dblink-tds/ -- Klint Gore Database Manager Sheep CRC A.G.B.U. University of New England Armidale NSW 2350 Ph: 02 6773 3789 Fax: 02 6773 3266 EMail: kgore4@une.edu.au
2008/6/29 David Rowley <dgrowley@gmail.com>: > > I had forgotten to say before that my instance of postgresql is running on > windows. > > I can't seem to find any evidence of freetds running on windows, I guess > there is not a great deal of need since MS's native client is there. So I'm > thinking of re-writing the dblink-tds to use Mircosoft's native client > rather than tds. The odbclink does not have any files yet, but looks like > exactly what I'd need. You could also try dbi-link, it's in Perl so should be portable and quite easy to rewrite. Think of DBD::ODBC or DBD::ADO (the latter works for me with ActivePerl) -- Filip Rembiałkowski