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