For custom fetchsize reasons, I'd like to get the .Net Provider\ODBC Data Provider working for an Oracle connection that uses an Oracle Wallet. This would be a connection from Visual Studio, but anything using ADO.NET would apply, such as the Import/Export wizard.
I'm able to connect fine to that Wallet-using database via SQL Plus, standard ODBC, SQL Developer (Native driver), and from Visual Studio using the ODP.Net managed and unmanaged drivers, but I can't connect using specifically the ODBC Data Provider where wallets are involved. (Sidenote: ODBC Data provider works fine for other on-prem Oracle databases where not wallet is involved.)
As far as why, it's because I have a remote database I must connect to for large scale downloads. Setting the FETCHSIZE to a very high value works wonders for that remote database, but the only way to set Fetchsize for the ODP.Net managed/unmanaged driver is server-wide. There's some risk to that change, and I doubt I'll persuade people to make that change to our busy and heavily used (for lots of other db connections too) server.
ODBC drivers, however, provides a connection by connection way to set Fetchsize. If I could get it working, I could have the best of both worlds.
My problem is, It doesn't work. Although I do get an ORA-29024, turning trace on shows things like below, which I believe are happening before (aka these are the root cause of the ORA-29024.)
(21732) [16-OCT-2024 18:54:50:532] SSL_Alert: write - fatal - unknown certificate authority
(21732) [16-OCT-2024 18:54:50:532] SSL_Alert: write - fatal - unknown certificate authority
(21732) [16-OCT-2024 18:54:50:532] SSL_Info: error in SSL3 certificate verify A
(21732) [16-OCT-2024 18:54:50:532] nzos_Handshake: Handshake returned failure code -1
(21732) [16-OCT-2024 18:54:50:532] nzos_Handshake: Handshake error(cb=0,rc=0,rer=1,ser=336134278) - error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
(21732) [16-OCT-2024 18:54:50:532] nzos_ContextDetails: Dumping the NZ context details
I do have environment variables for ORACLE_HOME and TNS_Admin, and during my troubleshooting, I feel safe in saying it isn't permission to those folders. (I've gone to some extremes making sure of that.) Any thoughts or suggestions?