ODBC driver and linked server in MSSQL 2k

From: "Kirk Friggstad" <friggstadk(at)ironsolutions(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: ODBC driver and linked server in MSSQL 2k
Date: 2005-08-08 16:02:39
Message-ID: 20050808160121.EC7ACF0AC7@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi all:

I've been trying to get our MS SQL Server 2000 to interoperate with our
PostgreSQL server (7.4.3 on RedHat 9, backend for Lyris LM 8.0) as a linked
server via the ODBC driver. When viewing it through Enterprise Manager, it
is able to display all the tables and views, but any attempt to access the
tables via SQL (on the MSSQL 2k server) gives an error message:

"Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A
four-part name was supplied, but the provider does not expose the necessary
interfaces to use a catalog and/or schema."

I've done a bunch of googling the past couple days, and digging through the
mailing list archives, and while I've found others who have encountered the
same problem that I have, I haven't found anyone posting that they've found
a solution. Has anyone on this list made a working linked server connection
from MSSQL 2k to PostgreSQL using the official ODBC driver?

Thanks

Kirk

Browse pgsql-odbc by date

  From Date Subject
Next Message Mario A. Soto Cordones 2005-08-09 00:43:03 postgresqlodbc ssl connections
Previous Message Josef Springer 2005-08-08 15:35:29 Re: issue using dts and odbc driver with unicode