Sql cluster connect to Oracel Server | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Sql cluster connect to Oracel ServerHi, 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