sql server - test connection failed because of an error in initializing provider - SSIS -


below machine information:

windows server 2003, service pack 2, 32 bit. ssis package developed on sql server 2005. connection string : data source=source;user id=xxx;provider=msdaora.1;persist security info=true

when i'm trying connect oracle db showing error (test connection failed because of error in initializing provider).how can know, oracle client need install this. checked here (https://social.msdn.microsoft.com/forums/sqlserver/en-us/0819acf0-f53e-402a-8113-e8d87f8def5b/test-connection-failed-because-of-an-error-in-initializing-provider-oracle-client-and-networking?forum=sqlintegrationservices). answer seems different versions. how know, install , install ? please suggest proper link. hope have explained correctly.

screenshot attached enter image description here

the server registry shows this:

enter image description here


Comments

Popular posts from this blog

html - Firefox flex bug applied to buttons? -

html - Missing border-right in select on Firefox -

python - build a suggestions list using fuzzywuzzy -