Share
ReportHello everyone,
I am trying to connect to an oracle datebase using Oracle Provider for OLE DB in SSIS.
TNS Ping connects successfully using the database alias provided by the tnsnames.ora file. However, upon testing the connection in BIDS i get:
------------------------------
Test connection failed because of an error in initializing provider. ORA-12638: Credential retrieval failed
------------------------------
I have read some blogs which suggested changing the SQLNET.AUTHENTICATION_SERVICES= (NTS) to None.
After changing it, I get another error saying:
------------------------------
Test connection failed because of an error in initializing provider. ORA-03113: end-of-file on communication channel
------------------------------
I am faily new to SSIS and Oracle struggling to get this connection going.
I will appreciate any suggestions.
Thank you :)
*This post is locked for comments
All responses (
Answers (
291,280
