ODBC Driver stability

Поиск
Список
Период
Сортировка
Искать
От
Gary Doades
Тема
ODBC Driver stability
Дата
Msg-id
418FF35D.4080705@gpdnet.co.uk
Ответ на
08.00.0002 useless :-) (Johann Zuschlag)
Список
Дерево обсуждения
Re: Snapshot release 08.00.0002 uploaded "Dave Page" <dpage@vale-housing.co.uk>
08.00.0002 useless :-) Johann Zuschlag <zuschlag2@online.de>
ODBC Driver stability Gary Doades <gpd@gpdnet.co.uk>
Re: ODBC Driver stability "Markus Donath" <donath@netapps.de>
Re: ODBC Driver stability Shachar Shemesh <psql@shemesh.biz>
Re: ODBC Driver stability <md-postgres-donath@netapps.de>
Re: ODBC Driver stability Shachar Shemesh <psql@shemesh.biz>
Unfortunately I have to come to the conclusion that the latest ODBC 
driver (8.0.0.2) is not as stable as first thought. When I initially 
tested it I was using a single application with a few connections and it 
seemed OK (better than 8.0.0.1 anyway)

Recently I have been doing heavier load testing within my ASP.NET 
application. Being a Web app on Windows it is inheriently multi-threaded 
and uses the MS .NET connect-execute-fetch-disconnect cycle heavily.

After obtaining just 10 connections and executing SQL the app starts to 
report random database failure messages "No error" and null reference 
exceptions withing Syetem.Data are common.

Various restarts, checking there are no other psqlodbc dlls and various 
test loads end up with the same situation fairly quickly.

Switching back to the 7.3.2.0 ODBC driver and the app will run stable 
for hours (or for as long as the test runs) with no driver errors.

I can now reproduce this problem in a single Windows GUI app by getting 
lots of connections and radpidly executing SQL immediately after opening 
each of the connections.
Sadly being in the .NET environment I can't see how to debug the driver 
in these situations or how to get more information about the faults. It 
still looks like buffer overruns causing the main problems.

I'm a bit concerned that Postgres is going to end up with a fantastic 
server (even on Windows!), but badly let down by the ODBC driver, which 
I suspect that a lot of the Windows newcomers will want to use. I know 
that 7.3.2.0 is stable at the moment, but what is the way forward?

Regards,
Gary.
В списке pgsql-odbc по дате отправления
От: Johann Zuschlag
Дата:
Сообщение: 08.00.0002 useless :-)
От: Lothar Behrens
Дата:
FAQ