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