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 |
|
jbphoenix
Yak Posting Veteran
68 Posts |
 Posted - 2009-07-29 : 18:04:52
|
| I'm trying to connect to an Oracle DB as my datasource. Here's what I have - Type: OracleServer Name: BlackThen I have the username and password. I click on the test connection button and I get this -ora-12514: tns:listener could not resolve service_name given in connect descriptorOur ERP data is in an Oracle DB and I need to use it. |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-07-29 : 19:29:46
|
| on your sql server do you have a tnsnames.ora file and does it have Servername black listed?Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
Connecting to Oracle DataSource