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 |
|
WalkerDA
Yak Posting Veteran
61 Posts |
 Posted - 2004-06-07 : 17:32:26
|
| Getting an error when trying to connect to an Oracle Data Source. Are there any goof references out there that spells out exactly what's needed or any good experience that I can draw from?Derrick Walker |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-07 : 17:44:12
|
| Do you mean that you are getting an error from a linked server? If not, where?Tara |
 |
|
|
WalkerDA
Yak Posting Veteran
61 Posts |
Posted - 2004-06-07 : 17:49:03
|
| I can't even connect. When I go to Import data Wizard and put in my from server, pick Oracle ODBC or OLE DB for Oracle it errors out. Referring to an Oracle Client and Networking services being needed. No details and I can't seem to find many references in making it work.Derrick Walker |
|
|
|
kselvia
Aged Yak Warrior
526 Posts |
Posted - 2004-06-07 : 18:12:38
|
| You will need to install the Oracle client on the server you are trying to create a linked server on.You have to get that from Oracle. |
|
|
|
WalkerDA
Yak Posting Veteran
61 Posts |
Posted - 2004-06-07 : 18:17:06
|
| Thanks...Derrick Walker |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-06-07 : 18:55:04
|
| You will also need to configure your tnsnames.ora with connection information needed for your Oracle instances.btw, you can download oracle clients from http://otn.oracle.com/index.html. you need to setup an account, but it is free.-ec |
|
|
|
|
|
|
Connecting to Oracle