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.
the server registry shows this:
Comments
Post a Comment