Linked Server + Oracle 10XE

[karephul]

Hi,
I am trying to configure Linked Server with Oracle 10gXE. I can not find any tutorials or help when I googled it. I was sucessfull in finding Linked Server to connect to Access data base and Excel files but not Oracle 10g XE.

Any pointer ???

 

[ecobb]

I remember I had a hard time finding info when I linked a SQL Server 2000 to an Oracle 8i server. If you run a Search on "Linked Servers" in Books Online, it should give you a lot of detailed information and examples on how to do it.

Also, here are some articles that I had to use to figure out how to get it working with Oracle. If I remember correctly, you have to install the Oracle Client Tools on the SQL Server to have all of the drivers to make the connection. Read through these articles, they should contain all the information you need to do this. When I set up our Linked Servers I'd never used Oracle before, these articles and Tek-Tips got me throught it!

http://www.databasejournal.com/features/mssql/article.php/10894_1756161_3

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=22264

http://support.microsoft.com/default.aspx?scid=kb;en-us;280106&Product=sql2k

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher