An existing connection was forcibly closed by the remote host

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
alemio
Posts: 12
Joined: Wed 20 May 2015 14:31

An existing connection was forcibly closed by the remote host

Post by alemio » Fri 08 Jan 2016 09:35

Hi,
this post is just to signal this strange error when I'm using Unidac with builder c++ 6.0.

Normally it works fine, but I had suddendly this error:

Project ... raised exception class SocketException with message 'Error on data writing to the connection:
An existing connection was forcibly closed by the remote host.
Socket Error Code: 10054($2746)'. Process stopped. Use Step or Run to continue.

The SQL Server database is inside my computer.
The connection string is
Provider Name=SQL Server;Login Prompt=False;Data Source=.\\sqlexpress;Persist Security Info=True;Port=0
The options are
SQL Server.Provider=prNativeClient
SQL Server.PersistSecurityInfo=True

This is an abstract of dbmonitor

07/01/2016 15:14:32 0,000 SQL Execute: INSERT INTO ...
:PersonalBestTime(Time)=08:32:36 Complete
07/01/2016 15:14:32 0,000 Commit: Complete
07/01/2016 15:14:32 0,000 SQL Execute: SELECT ...
Complete
07/01/2016 15:14:32 n/a SQL Prepare: INSERT INTO ...
:PersonalBestTime(Time)=04:45:16 Pending
07/01/2016 15:15:12 n/a UniDAC monitoring is started Complete
07/01/2016 15:15:12 0,000 Start: Complete

What could have happened?

Regards
Alessandro

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: An existing connection was forcibly closed by the remote host

Post by AlexP » Tue 12 Jan 2016 11:57

Hello,

We cannot reproduce the problem. Please clarify the versions of the SQL Server and UniDAC, and send the table creating script and the full sample reproducing the problem to support*devart*com .

Post Reply