Use Encryption for Data

[BuddyRobbins_Linquest]

Folks,
I'm trying to set the "Use Encryption for Data" on the SQL Server OLEDB Link Data screen in version 14. 
I'm getting handshake issues-- [DBNETLIB][ConnectionOpen(SECDoClientHandshake()).]SSL_Security error.

Doing this outside of the Sparx Environment, I'm used to setting the flag for trusting the server certificate to overcome this error.

How do I do this in the Connection string?

Thanks in advance

[Typia]

same problem here, did you manage to resolve it ?

[wivel]

Hi guys

Not sure if this is what you ask, but you can enter your own connection string in EA:

• Select 'Open Custom' from the Start Page. Here you can type in a connection string.
• If you have already added the repository, select 'Manage Projects' from the Start Page. Right click on the repository on the list and select 'Edit Connection string'

Its on EA 15.2 BTW.

Henrik

[Typia]

Hi Wivel,
thanks for your answer.
Not exactly,
OP has the same problem I have, using the data link connection provided with EA, we have a SSL error.
OP says that with other clients he ticks "trust server certificate" and wanted to know if there was a way to have this option in the connection string.

Hi guys

Not sure if this is what you ask, but you can enter your own connection string in EA:

• Select 'Open Custom' from the Start Page. Here you can type in a connection string.
• If you have already added the repository, select 'Manage Projects' from the Start Page. Right click on the repository on the list and select 'Edit Connection string'

Its on EA 15.2 BTW.

Henrik