Board index » delphi » [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error
Stuart Barrett
 Delphi Developer |
[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error2006-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 |