Skip site navigation (1) Skip section navigation (2)

Re: ODBC Driver stability

From: Gary Doades <gpd(at)gpdnet(dot)co(dot)uk>
To: Markus Donath <donath(at)netapps(dot)de>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC Driver stability
Date: 2004-11-10 19:15:42
Message-ID: 419268DE.6070709@gpdnet.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc
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.

In response to

Responses

pgsql-odbc by date

Next:From: Jeff EckermannDate: 2004-11-10 19:15:58
Subject: Re: Can't use current_timestamp or currval functions
Previous:From: Peter EisentrautDate: 2004-11-10 18:17:59
Subject: Re: @@IDENTITY

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group