Re: ODBC Driver stability
От | |
---|---|
Тема | Re: ODBC Driver stability |
Дата | |
Msg-id | DMEMIOKBKOJMHMOCJMPCAEEJEHAA.md-postgres-donath@netapps.de обсуждение исходный текст |
Ответ на | Re: ODBC Driver stability (Gary Doades <gpd@gpdnet.co.uk>) |
Ответы |
Re: ODBC Driver stability
(Gary Doades <gpd@gpdnet.co.uk>)
|
Список | pgsql-odbc |
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@postgresql.org > [mailto:pgsql-odbc-owner@postgresql.org]Im Auftrag von Gary Doades > Gesendet: Mittwoch, 10. November 2004 20:16 > An: Markus Donath > Cc: pgsql-odbc@postgresql.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 >
В списке pgsql-odbc по дате отправления: