Please let me know the solution for following error!! ![]() Linked Server fails from SQL Server 2008 R2 and PostgreSQL OLE DB provider "MSDASQL" for linked server "PostGreDB" returned message "MSDTC XARMCreate error".Ĭorrect the errors and retry or press ESC to cancel the change(s). Net SqlClient Data Provider.Įrror Message: The operation could not be performed because OLE DB provider "MSDASQL" for linked server "PostGreDB" was unable to begin a distributed transaction. Microsoft SQL Server Management Studio ExpressĮrror Source. Msg 7350, Level 16, State 2, Procedure containerload2, Line 3Ĭannot get the column information from OLE DB provider "MSDASQL" for linked server "PostGreDB". No query has been executed with that handle". OLE DB provider "MSDASQL" for linked server "PostGreDB" returned message "ERROR: column "PID" does not exist Worked somehow (i can see data in a MSSQL Server Management Express View).įROM OPENQUERY(PGCounter, 'SELECT PID, value Can you please help?įROM OPENQUERY(PGCounter, 'SELECT * from "PostGreDB".originalTable ') Keep in mind that the PostgreSQL 64-bit ODBC is marked as experimental, but we have had good success with it on an Intel processor basedĦ4-bit Windows 2003 running SQL Server 2005 64-bit. ' SELECT * From information_schema.tables ' ) SELECT * FROM OpenQuery (NAMEOFLINKEDSERVERHERE, To test out the linked server - you can run the sample query below in SQL Server:.You should also be able to expand the PostgreSQL linked server and see the tables and views. You can fiddle further with the settings. ![]() sp_addlinkedsrvlogin rmtsrvname =N ' NAMEOFLINKEDSERVERHERE useself =N ' True ', locallogin = NULL, rmtuser = NULL, rmtpassword = NULLĪfter that you should see the linked server in SQL Server 2005 Management ->Server Objects ->Linked Server and from there sp_addlinkedserver server = N ' NAMEOFLINKEDSERVERHERE ', srvproduct =N ' PostgreSQL AMD64A provider =N ' MSDASQL ', provstr =N ' Driver=PostgreSQL AMD64A uid=pguser Server=pghost database=pgdatabase pwd=somepassword ' /* For security reasons the linked server remote logins password is changed with # */ EXEC master.dbo. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |