Sql cluster connect to Oracel Server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sql cluster connect to Oracel Server

Hi, i have Sql cluster with 2 nodes X1 and X2, i have one dts which is bring data from Oracel Server, my probelm is : in X1 the DTS is working fine when i fail over to X2 the DTS is not running and in desing package in test connection i face this error message :
"test connection failed because of an error in initializing provider oracel client and networking comonents were not found these compnents are supplied by prace corporation and are part of the oracel version 7.3.3 or later client softaware "
any one has an idea how can i slove this issue , i will be thankful

Hi, it seems to be a connection issue to oracle.
check this: http://support.microsoft.com/kb/280106
http://www.sqlmag.com/Article/ArticleID/49687/sql_server_49687.html
Thank you,
Sandy.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |