Re: linking from SQL Server - Mailing list pgsql-sql

From SHELTON,MICHAEL (Non-HP-Boise,ex1)
Subject Re: linking from SQL Server
Date
Msg-id FB60DFB2C0E24449AC0C21F743B935410150F9EE@xboi02.boi.hp.com
Whole thread Raw
In response to linking from SQL Server  (Oleg Lebedev <olebedev@waterford.org>)
Responses Re: linking from SQL Server
List pgsql-sql
I have access to a SQL 2000 server if you can give me some detailed
instructions I'd be happy to test it out for you.  I'm also interested in
seeing if this will work.

Thanks,
Mike

-----Original Message-----
From: Josh Berkus [mailto:josh@agliodbs.com]
Sent: Thursday, January 24, 2002 6:19 PM
To: Oleg Lebedev; Postgres SQL Mailing List
Subject: Re: [SQL] linking from SQL Server


Oleg,

> I am wondering if anybody tried to link PostgreSQL tables/databases
>  from
> SQL Server.
> As I understand SQL Server uses OLE DB for this kind of connections.
>  I
> wonder if this is possible at all with postgres.

In theory, yes.  In practice, no.

According to the documentation, SQL-Server supports any Win32 ODBC
 driver ... which would include PostgresODBC.  However, in practice,
 only Microsoft-supplied drivers actually work; ODBC drivers for
 Postgres and MySQL mysteriously do not function with SQL-Server (even
 though they do work with MS Access).

I think this is incompetence on Microsoft's part rather than malice;
 all of this works through DTS, a utility which is responsible for over
 300 Knowledge Base issues.

Note:  I have not tried any of this with SQL Server 2000, just 7.0 sp3.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco    and non-profitorganizations.      San Francisco

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


pgsql-sql by date:

Previous
From: Bhuvan A
Date:
Subject: Good tutorial on plperl.
Next
From: Achilleus Mantzios
Date:
Subject: Arrays Question