Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group