Re: dblink to non postgresql dbms

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(at)une(dot)edu(dot)au]
Sent: 27 June 2008 00:45
To: David Rowley
Cc: pgsql-general(at)postgresql(dot)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(at)une(dot)edu(dot)au