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 |
|
nemohm
Yak Posting Veteran
69 Posts |
 Posted - 2003-06-11 : 14:49:28
|
| Hi,I’m trying to create a linked server to Oracle. The only result is Error 7339.What could be the proper config settings for the General tab in EM/…/linked servers/ new linked server:Provider name: Oracle provider for OLE DBProduct name: ?Data source: ?Provider string: ?TNSnames.ora file looks like:PHD.PCC.LOCAL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = green)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = phd.db.space.com) ))(pcc.local is the W2k domain)Oracle DB name is phd, global DB name is phd.db.space.comThank you very much!Dobby |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-06-11 : 16:00:34
|
| can you tnsping this oracle instance from your SQL Server? If you can't, then you have a problem with your oracle client installation and/or tnsnames.ora file. In the linked server setup, all that is really important is the data source information. For your example, it should be PHD.PCC.LOCAL.-ec |
 |
|
|
nemohm
Yak Posting Veteran
69 Posts |
Posted - 2003-06-11 : 18:11:48
|
| I can tnsping the Oracle instance from command prompt.How can I ping from SQL Server?Thx,Dobby |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-06-11 : 18:21:06
|
quote:
I can tnsping the Oracle instance from command prompt.How can I ping from SQL Server?
I meant from the command prompt on the server running SQL Server. What about sqlplus, can you use sqlplus from your command line and connect to the Oracle database?If you can do both of those things, all you need to do is add PHD.PCC.LOCAL to Data Source in the linked server setup. Make sure you complete the information on the security tab though (put in the user and pass that you want to connect as).-ec |
|
|
|
|
|
|
Linked server to Oracle