Encrypt=Yes;TrustServerCertificate=Yes

1

Hello.
I use C6.2 with MSSQL 2019.
Is anybody using this settings to connect with MSSQL ?
My table in dct has ownername like this:
ownername =‘server,database,login,password;Encrypt=Yes;TrustServerCertificate=Yes;APP=My clarion app’
The code:
open(table) hangs all app …
Any ideas?

2

are you using ODBC driver or MSSQL driver?

3

I am using MSSQL driver

4

Try adding Persist Security Info=True; if it still hangs, but I don’t think that’s the best solution