Sybase ASE 16.03 ODBC crypto provider issue

[skimmer333]

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

[former_member30]

Hi and welcome to the SAP Community!

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Cheers,

Julia
SAP Community Moderator

[skimmer333]

Thanks for your reply Robert. Apologies for the delay in replying.

Unfortunately I don't have access to the that article as I am only a P-user.

Will see if members in my company that have access can get the information for me.

Appreciated.

Russell

[former_member358098]

skimmer333

In case you'll be unable to get to the note, here it is

Symptom

• Using "Test Connection" button fails when using ssl with:
  [SAP][ASEODBC Driver]The crypto provider encountered an error while setting the certificate authority list.
• Succeeds to connect using a DSN in an application

Environment

• SAP Sybase Software Developer Kit (SDK) 15.7
• SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
• Adaptive Server Enterprise ODBC Driver by Sybase
• ODBC

Reproducing the Issue

1. Create DSN
2. Add ssl and trustedfile properties
3. Click Test Connection button

Cause

The issue has been identified and logged under SAP CR 819871. Its description reads, "ODBC test connection button fails with ssl".

Resolution

• There is currently no target SAP SDK Service Pack scheduled for this issue (SAP CR 819871). It is being assigned to our Product Group. Please mark this KBA as a Favorite to be automatically notified when the CR status has changed.
• Workaround:

1. Do not use Test Connection. Test with your application.
2. Hard code the password into the registry
   Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\sampledsn\
   create new string value
   pwd = <your password>

[shery_vijayan]

Issue persists in client versions ,

- ASE 16 SP03 PL10

-ASE 16 SP04 GA

Still not fixed ..

Thanks,

[skimmer333]

Many thanks Robert

[Former Member]

I’m glad it helped you!