Exception in a query

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
sandeepl
Posts: 4
Joined: Thu 30 Aug 2007 08:18

Exception in a query

Post by sandeepl » Fri 16 Nov 2007 09:40

Hi,
I am using corelab postgresql driver and encounter stray incidents of db exception where the query fails and the exact exception that I get is "Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host.".
If re-execute the same statement in MSVS2005 by using "Set next statement", it works without a problem.
Is this a known problem and if so is there a fix for this? We are using a professional licensed copy of the driver version 3.20.
This is a serious problem for us because it happens quite frequently.

Thanks
Sandeep

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 16 Nov 2007 12:40

First of all try to use the latest verion of PostgreSQLDirect .NET (3.25).
If the problem persists, send me a test project to reproduce the problem.
Include the definition of your own database objects.
Use e-mail address provided in the Readme.html file.
Do not use third party components.
If it is impossible for you to create the test project, send a piece of
your code where the error occurs.

Post Reply