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 |
|
sqlmember2000
Starting Member
9 Posts |
 Posted - 2011-06-13 : 20:32:28
|
| Hello All -I currently have Oracle Client 9.2 installed. One of our Oracle database has been upgraded to Oracle 11g. This impacted my SQL Server DTS package in that I get an "ORA-12560: TNS:protocol adapter error" while trying to execute my package which connects to the Oracle 11g database.QUESTION1) Does anyone know whether SQL Server 2000 is compatible with Oracle 11g client? 2) If I installed oracle client 11g, will the issue resolve itself or bring out more issues?3) What can be done to resolve for my DTS - Oracle connection problem?Thanks in advance. |
|
|
|
|
|
SQL Server 2000 and Oracle 11g