Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlslick
Yak Posting Veteran
83 Posts |
 Posted - 2011-06-02 : 12:04:45
|
| Hello everyone,I'm trying to setup a Linked Server to an Oracle database. I have done some research but still need some clarification from someone who has experience in this department.First and foremost, I know I need to make sure that the Oracle client software (10.2.0.4.0) is on the server that is running Microsoft SQL Server.Second, I need to create an alias name on the server that is running SQL Server that points to an Oracle database instance. I'm not really sure how to do this.Then, I have to run the Stored Procedure sp_addlinkedserver. Assuming that the alias of the Oracle database is 'ORALIAS', which of the following 2 scripts is the more correct one?EXEC sp_addlinkedserver @server = 'ORADB', @srvproduct = 'Oracle', @provider = 'MSDAORA', @datasrc = 'ORALIAS'orEXEC sp_addlinkedserver @server = 'ORADB', @srvproduct = 'Oracle', @provider = 'OraOLEDB.Oracle', @datasrc = 'ORALIAS'Once the Linked Server is established the SQL statement below should work, correct?SELECT * FROM ORADB..ANYUSER.ANYTABLEThe ultimate goal is to create a VIEW on the SQL Server database based on the Oracle tables. Am I on the right track?Your assistance will be greatly appreciated!!Thank you!John |
|
|
|
|
|
Setting up Linked Server to Oracle 10g