Page 1 of 1

Encryption not supported on the client / SSL Security error

Posted: Fri 30 Nov 2007 20:21
by strovatore
Started getting this error on Vista Ultimate and 2000 boxes after making the switch from SDAC 3.80 standard to 4.30 pro

Exes compiled with the 3.8 version work fine on all, but with 4.30 i get:

w/windows 2000:

[DBNETLIB][ConnectionOpen(SECDoClientHandshake()).]SSL Security error

w/windows Vista Ultimate:

"Encryption not supported on the client."


Thanks in advance

Steve Trovatore
Xanatek Inc.
steve*xanatek*com

Posted: Mon 03 Dec 2007 16:15
by Antaeus
It looks like a problem of the SQL Server client. Please check, for what values of TMSConnection.Options.Provider does the problem persists (prAuto, prSQL, prNativeClient).
Also supply me the following information:
- exact version of SQL server. You can see it in the Info sheet of TMSConnection Editor;
- exact version of your SQL clients for prSQL and prNativeClient. You can see it in the Info sheet of TMSConnection Editor;
- exact version of your IDE.

Probably you need to upgrade your client regarding this article from the Microsoft site.

Posted: Mon 03 Dec 2007 18:34
by strovatore
My provider is set to prAuto (the default)
I am connecting to SQL Server 2005 Express Edition

Posted: Mon 03 Dec 2007 18:37
by strovatore
Exact version of component is 4.30.0.12 but i have tried .13 at home

IDE is Delphi 7.1

Posted: Mon 03 Dec 2007 23:00
by strovatore
Just a note to anyone with this issue.

All I had to do was change Options.Provider to prSQL

Thanks for the response, it at least got me thinking.