Board index » delphi » [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error

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


2006-09-02 07:59:48 PM
delphi191
Delphi 6 Pro (sp2)
SQL Server 2000 (Sp4)
Windows Server 2003 (Latest SPís)
MDAC 2.8
kbmMW 2.6
Hello
One of our users is intermittently having this SSL Security error; a
kbmMW Server application is used through which the users call services
to retrieve/update data. Therefore the Clients do not have a direct
connection to SQL Server and the error is being generated server side.
The Server Application and SQL Server are on the same physical server.
According to the IT Manager they are not using any sort of Encryption
and do not have a SSL certificate installed. The IT Manager has spend
sometime on the phone with Microsoft and they have ensured that the
correct MDAC, SQL Server and Registry settings are being used, but the
error still occurs. The system can go several weeks without a problem
and then it can happen several times a day. The only solutions is to
re-start the server.
Servers ADO connection string:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=StockHolderSQL;Data Source=WIN2003SERVER;Use
Procedure for Prepare=1;Auto Translate=True;Packet
Size=4096;Workstation ID=AMD64;Use Encryption for Data=False;Tag with
column collation when possible=False
Any ideas of what is likely to be causing this error?
Thanks
Stuart
 
 

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

Hello
Google has the number of entries:
www.google.ru/search
May be some of them will be your case ?
Regards,
Dmitry
--
Dmitry Arefiev - www.da-soft.com
AnyDAC - Oracle, MySQL, MS SQL, MSAccess, IBM DB2, Sybase
ASA, DbExpress, ODBC freeware data access framework
gs-soft AG - www.gs-soft.com
SAPx - Delphi to SAP R/3 direct access
Saphir - SAP R/3 metadata at your fingertips
MetaBase - ERWIN model in Delphi applications