Re: ODBC Driver stability

The same application runs stable with oracle and mssql.
I used iis crash dumps to find out that it was the odbc driver causing the
problems and sent some of the odbc-logs to hiroshi (end of 2003).
Maybe i'm using different features of the driver that cause problems.
could you send me your odbc driver settings / connection string ?

I did not test or install the 8.x.x.x drivers.

bye,
Markus.

> -----Ursprüngliche Nachricht-----
> Von: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org]Im Auftrag von Gary Doades
> Gesendet: Mittwoch, 10. November 2004 20:16
> An: Markus Donath
> Cc: pgsql-odbc(at)postgresql(dot)org
> Betreff: Re: [ODBC] ODBC Driver stability
>
>
> Markus Donath wrote:
> > Hello,
> >
> > i have also tested several PGSQL ODBC driver versions with
> Windows 2000, IIS
> > (the Windows webserver) and ASP.
> > Version 7.3.2.0 runs best in a multithreaded environment, but
> it is still
> > not 100% stable.
> > The webserver sometimes hangs (depends on the load) so that the process
> > needs to be killed.
> > All in all, the Postgres ODBC driver does not fit our needs for
> stability,
> > and as the posts in this newsgroup show, there is no
> development going on.
> > To me, it looks like no one here uses the ODBC-driver for server
> > applications with windows.
> > Our conclusion is that Postgres is not usable with ODBC on
> windows, and no
> > stable driver will be available soon. We are going to switch a different
> > database. To bad, as the database itself runs fast and stable.
> >
> > bye bye postgres !
> >
>
> I have to admit that I have not had any problems with 7.3.2.0 and I have
> hit it pretty hard. In real-load tests with around 100 concurrent
> connections from an ASP.NET server ticking over at around 12 connections
> per second on average, ODBC pooling on, with a good mix of
> selects/update/inserts it has not hung at all.
>
> How do you know that it is the ODBC driver itself that is hanging the
> web app?
>
> Cheers,
> Gary.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com)
> Version: 6.0.794 / Virus Database: 538 - Release Date: 10.11.2004
>