Revolving around the core of technology
Trying to connect to an Oracle 12c DB. Kept getting an error that indicated I needed an updated driver. I installed the Oracle 12 client (full package). I can connect to the DB using the Oracle client however still not able to connect to the 12C DB using WinSql.
The DBA was able to enter a name in the sqlnet.ora file to allow connections from earlier drivers. While this dis make a connection, it would not accept the Username/PW combination (I know it is correct as I connected with the Oracle Client).
1. Any ideas how to connect without adding the entry to sqlnet.ora ?
2. Any idea on why it would not accept username/PW whe nadding the entry to sqlnet.ora
Oracle changed the communication protocol in v12C.
The next minor build of WinSQL 14 will contain a newer version of Oracle Driver, which should work with 12C. Another alternative is to use the driver from Oracle.