Encryption not supported on the client / SSL Security error

strovatore · Post by **strovatore** » Fri 30 Nov 2007 20:21

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

Antaeus · Post by **Antaeus** » Mon 03 Dec 2007 16:15

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.

strovatore · Post by **strovatore** » Mon 03 Dec 2007 18:34

My provider is set to prAuto (the default)
I am connecting to SQL Server 2005 Express Edition

strovatore · Post by **strovatore** » Mon 03 Dec 2007 18:37

Exact version of component is 4.30.0.12 but i have tried .13 at home

IDE is Delphi 7.1

strovatore · Post by **strovatore** » Mon 03 Dec 2007 23:00

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.