Re: Problems with ODBC and ASP .NET 2.0

I have heavy use of odbc because I am still asp 70% or so.
I use npgsql for my .net stuff too.
Pervasive is supposed to be updating the odbc driver in thee near future (I
hope it works as my app is crashing often and my clients are going to drop
us if I can not get this resolved).

I am using the 7.4 drivers also because my data has Unicode (French) chars
and is stored in a SQLASCII data base. I have the conversion program written
and tested to get on a Unicode database and then I can try the 8.0 odbc
drivers.

Not sure where you turned on pooling and set the time out, I would be
interested in that. I just got a Driver's SQLAllocHandle on SQL_HANDLE_DBC
failed error this morning.

Joel Fradkin

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305

jfradkin(at)wazagua(dot)com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Greg Campbell
Sent: Friday, July 08, 2005 8:31 PM
To: C Funky
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Problems with ODBC and ASP .NET 2.0

Not too sure I can help you.
After looking into what was available I decided to use the Npgsql
instead of ODBC. It is very much more ADO.NET centric.
I have a app running for a couple of months continuous with moderate
load with nary a glitch.

I trust pooling to work, so all my "connect - do something - drop
connection" are very short, and used a lot, natch.

C Funky wrote:
> Hi guys
>
> I've got a ASP .NET application running on Windows Server 2003
> accessing Postgresql (version 8.0) through ODBC on the 7.4 drivers and
> I've run into a bit of a problem. Under very light loads (a couple
> connections per hour) the application works fine. However, as the load
> increases, I start getting ODBC exceptions occasionally when the
> application tries to open a new connection. The exception contains no
> information other than something about being unable to determine the
> driver version. When this error first started popping up I'd have to
> restart the postmaster service for anything to work. Then, after
> turning on ODBC connection pooling and setting a timeout of 10 s, I
> could just wait a couple seconds, retry creating the connection and
> everything would work fine. Does anyone out there have any idea why
> this might be happening? I'm pretty new to Postgresql, so please
> forgive me if this is something super obvious that I've just missed.
>
> Thanks,
> Chris
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings