Post reply

Creating a Linked Postgres server in MS SQL 2000

  • April 20, 2006 at 9:26 am

    #96939

    Has anyone successfully linked a Postgres 7.4.X server to a SQL 2k server and been able to reference the linked server in a distributed transaction. The error I keep getting is the following...................

     

    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.

    Seems like this is some sort of ODBC error, but I can not find anything on it and have tried any number of different vendor ODBC drivers with the same result. Any help would be greatly appreciated !!!!

     

  • April 21, 2006 at 8:08 pm

    #633635

    I ran into that error with a db2 linked server; instead of server.database.schema.table, what worked was server..schema.table, leaving out the database.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply