Tag: linked server

Unable to enlist in the transaction using a Linked Server. Msg 7391, Level 16, State 2

Here is problem you may encounter using a Linked Server connecting to an Oracle Database. I was trying to create a table in SQL Server with data from an Oracle database using a Linked Server and I received this error: Unable to enlist in the transaction Msg 7391, Level 16, State 2

Continue reading Unable to enlist in the transaction using a Linked Server. Msg 7391, Level 16, State 2

Linked Server — Data type is not supported

One day I was trying to query Oracle data through a SQL Server Linked Server and received the following error:

Msg 7354, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "CEGIS" supplied invalid metadata for column "SHAPE".
The data type is not supported.

 

Continue reading Linked Server — Data type is not supported

Speed up Linked Server Connection To Oracle using OPENQUERY

Last time I showed how to create a connection to an Oracle database by creating a Linked Server in SQL Server.  Most of the time this works fine, but when you are pulling a lot of information, it tends to run slow.  By using OPENQUERY, the query will run very, very fast.

Continue reading Speed up Linked Server Connection To Oracle using OPENQUERY