BUG: "An existing connection was forcibly closed by the remote host" and SQL 2005

Frenk3 · Post by **Frenk3** » Sun 25 Mar 2007 13:08

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

Jackson · Post by **Jackson** » Mon 26 Mar 2007 11:28

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.

Jackson · Post by **Jackson** » Fri 30 Mar 2007 13:50

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.

Frenk3 · Post by **Frenk3** » Fri 30 Mar 2007 20:44

or add "Provider=SQLOLEDB.1;" to a connection string