Re: stable driver for multithreaded environment (IIS 5.X)

From: "Markus Donath" <md-postgres-donath(at)netapps(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: stable driver for multithreaded environment (IIS 5.X)
Date: 2003-12-15 09:58:52
Message-ID: brk0kv$561$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello,

thank you for the new version (07.03.0205).
i've tested the version for a few days now with the following results:

1. The "corrupted data under stress" problem (up to 07.03.0204) is fixed
2. Threads are no longer blocked by the "pure virtual function call" error
message box

But the 07.03.0205-Version introduces new bugs:

1. When using updateable recordsets in a database call (no matter if allowed
in the dsn-settings or not), the odbc-driver becomes unusable after a few
statements, and
error-statements ("unknown error") are returned by the database driver.
2. We use components to cache some data. When i call these components in the
following manner:
comp1.init(connectionstring)
comp2.init(connectionstring)
the second call fails with the new driver. When i vary the connection-string
a bit for the second
call (e.g. by adding something like ";foo=222") , everything works fine.
This lets me think that there might be a problem with connection pooling.
Even when connection pooling and updateable cursors are disabled (by
DSN-Settings), these errors occur.

Note: these components do not share any database related resources.
For every call made in the entire application a seperate connection is
opened, a call is beeing made and the connection is closed as soon as
possible (this is how to make connection pooling work with windows).

All in all, this Version is even less stable then 07.03.0204 although some
problems were fixed.

@Hiroshi Inoue: Are you interested in the odbc-driver-logs ?

bye,
Markus.

""Hiroshi Inoue"" <inoue(at)tpf(dot)co(dot)jp> schrieb im Newsbeitrag
news:000001c3be62$5ea57500$3d283ddb(at)PbgX(dot)(dot)(dot)
> > -----Original Message-----
> > From: Markus Donath
> >
> > As no developer has answered yet, could anyone related to odbc driver
> > development answer the following questions:
> >
> > 1. Is there any development going on for the Windows version
> > of the ODBC
> > driver ?
> > 2. Are there known problems in a multithreaded environment
> > (Webserver on
> > Windows 2000) and are they adressed ?
>
> Could you try the dll at http://www.geocities.jp/inocchichichi/ ?
> It would fix a multithread related bug though I'm not sure if it would
> solve your problem.
>
> regards,
> Hiroshi Inoue
>
> > 3. Is there a stable (maybe older, maybe commercial) version
> > available for
> > multithreaded environments ?
> > 4. Is anyone interessted in bug reports or am i completely
> > wasting my time
> > when posting to this newsgroup ?
> >
> > this would be very important for me.
> > PLEASE if anyone is working on the driver CONTACT ME.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2003-12-15 10:22:50 Re: stable driver for multithreaded environment (IIS 5.X)
Previous Message Tom Lane 2003-12-14 22:31:40 Re: Port blocked by iptables firewall