on 04-20-2021 7:46 AM
We have been using ASE 16.0 SP3, and had been using the 15.7 client to connect via excel vba.
Due to security requirements, we have removed the 15.7 client and installed the 16.3.006 SDK, and encryption enabled.
We are now unable to connect to servers using the excel files. We are also unable to create a DSN entry.
I've created a new DSN entry, enabled the 'Use SSL Encryption' option, and entered the location and file name into the 'Trusted File' setup.
Now, we are receiving the following when testing the connection:
[SAP][ASE ODBC Driver]The crypto provider encountered an error while setting the certificate authority list.
Is anyone able to advise how to correct this, and also, any example vba code for getting excel to connect?
Regards,
Russell
Issue persists in client versions ,
- ASE 16 SP03 PL10
-ASE 16 SP04 GA
Still not fixed ..
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Many thanks Robert
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.