Re: dblink to non postgresql dbms

From: Klint Gore <kgore4(at)une(dot)edu(dot)au>
To: David Rowley <dgrowley(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dblink to non postgresql dbms
Date: 2008-06-26 23:44:38
Message-ID: 486429E6.6040802@une.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-06-27 02:23:07 Re: ERROR: could not open relation with OID 2836
Previous Message Tom Lane 2008-06-26 23:43:34 Re: compiling, performance of PostGreSQL 8.3 on 64-bit processors