Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    49

    Unanswered: Postgresql/SQL Server linked server issues

    All,

    I am trying to access a postgresql procedure from a sql server 2000 server via a MSSQL linked server connection and I am getting the following error:

    " OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a].
    Msg 7391, Level 16, State 1, Line 2
    The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction."

    I installed the latest Postgresql ODBC drivers on the server and also verified that I can access the Postgresql system from ODBC.

    Is there a way to resolve this issue or is there a better way to connect to Postgresql from SQL Server.

    Thanks in advance for the help.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Could you show us the SQL statement you are using which results in the error?

    (You are using 4 part naming?)

    i.e.
    Code:
    select * from LinkServerName.pgDatabaseName.pgSchemaName.pgTableName
    ALso, you may need to use SQL Server's openquery function
    Last edited by loquin; 03-18-08 at 13:35.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •