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

Re: dblink to non postgresql dbms

From: "David Rowley" <dgrowley(at)gmail(dot)com>
To: "'Klint Gore'" <kgore4(at)une(dot)edu(dot)au>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: dblink to non postgresql dbms
Date: 2008-06-28 23:22:44
Message-ID: 001301c8d975$e0d0f210$0301a8c0@amd64 (view raw or flat)
Thread:
Lists: pgsql-general
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


In response to

Responses

pgsql-general by date

Next:From: Filip RembiałkowskiDate: 2008-06-29 09:42:54
Subject: Re: dblink to non postgresql dbms
Previous:From: Steve AtkinsDate: 2008-06-28 16:39:14
Subject: Re: query planner weirdness?

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