Page 1 of 1
BUG: "An existing connection was forcibly closed by the remote host" and SQL 2005
Posted: Sun 25 Mar 2007 13:08
by Frenk3
If "Provider=SQLOLEDB.1;" is not specified in a connection string for SQL 2005, you get an error "An existing connection was forcibly closed by the remote host".
With SQL 2000 it works without provider specification.
Can you please fix this in a next upgrade?
Frenk
Posted: Mon 26 Mar 2007 11:28
by Jackson
We couldn't reproduce the problem.
Please send us (evgeniym*crlab*com) a complete small test project to reproduce the problem; don't use third party components.
Also supply us following information
- Exact version of Delphi or C++ Builder
- Exact version of SDAC. You can see it in About sheet of TMSConnection Editor
- Exact version of Microsoft SQL Server and OLE DB provider that you use. You can see it in Info sheet of TMSConnection Editor.
Posted: Fri 30 Mar 2007 13:50
by Jackson
Typicaly this error occurs when the client is connecting with an unsupported version of the SQL Native Client.
Update the client computer to the server version of the SQL Native Client and try again.
Posted: Fri 30 Mar 2007 20:44
by Frenk3
or add "Provider=SQLOLEDB.1;" to a connection string