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
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
Sometimes you need to pull data from an Oracle database into your SQL Server database. No magic is required, you just need to use a Linked Server. This article will show you how easy it is.
Continue reading Linked Server that connects to Oracle