Page 1 of 1

An existing connection was forcibly closed by the remote host

Posted: Fri 08 Jan 2016 09:35
by alemio
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

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

Posted: Tue 12 Jan 2016 11:57
by AlexP
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 .