I have a need to encrypt connections from Excel to an Oracle database. I have the DB server setup using Oracle Wallet, a self signed cert for testing. I have the cert in my local wallet, (under my client install 12c). SQLPlus works, Toad works, JDBC connections work, (once I imported the cert into the java truststore). But When I try and connect with the ODBC connection, I get an error Unable to connect SQLState=S1000 [Oracle][ODBC][Ora]ORA-29106: Cannot import PKCS #12 wallet
ODBC is installed with Instant client 11.2
The SQLNET.ORA file in the Instant Client directory:
# sqlnet.ora Network Configuration File: %ORAINSTANT_CLIENT_HOME%\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (TCP,TCPS,NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
SSL_CLIENT_AUTHENTICATION = FALSE
wallet_location =
(SOURCE=
(METHOD=File)
(METHOD_DATA=
(DIRECTORY=%ORACLE_HOME%\NETWORK\ADMIN\SWELP1103_wallet)))
SQLNET.EXPIRE_TIME=0
I set a wallet up in the Instant Client home, And created a self signed cert... but I don't think that's really what I need... Does anyone have any information on setting up tcps with ODBC?