Unanswered: Postgresql/SQL Server linked server issues
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.
Could you show us the SQL statement you are using which results in the error?
(You are using 4 part naming?)
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 12:35.
"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