odbc driver problem? or threading? or crecordset?

From: "Vincent Ladlad" <vincentl(at)ntsp(dot)nec(dot)co(dot)jp>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: odbc driver problem? or threading? or crecordset?
Date: 2004-03-16 01:23:35
Message-ID: 014701c40af5$4d6c6070$643b1cac@Titanium
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

hi there! im new to psqlodbc, and i hope you pros could help me out :)

i have been browsing the internet for more than
a week now, searching for clues regarding an
"access violation" error. i hope maybe you can
help me get over this problem, as it has been
eating my dev schedule.

here's the problem:
i have two threads triggered by onTimer which
is set to 1 second. when the timer expires,
the threads are notified, and a (select) query is started.
both threads use the same recordset class, but
different instance. thread1 accesses server1 using datasource1. thread2
accesses server2 using datasource2. both tables are the same on both
servers, but have different values. that is why they use the same
recordset.
after a few timerEvents, the program stops, and the
error message "access violation" is shown.
during debug, i traced that the error occurs when
both thread attempts to call the crecordset::open function.
at the same time. even though they access different
datasources, the problem keeps coming back. i only
issue a simple select statement with the following options --
(crecordset::snapshot, crecordset::readonly).

the recordset is open()ed and close()d after every query.
the cdatabase instance is not. it remains open.

is there something i missed?

thanks,
vincentl

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.605 / Virus Database: 385 - Release Date: 3/1/2004

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Markus Donath 2004-03-16 09:55:59 Re: odbc driver problem? or threading? or crecordset?
Previous Message Steve Jorgensen 2004-03-16 01:18:42 Some problems with Access and ODBC to PostgreSQL