comp.lang.idl-pvwave archive: archive » Dataminer: LOCK TABLES does not work (myodbc)

Home » Public Forums » archive » Dataminer: LOCK TABLES does not work (myodbc)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Dataminer: LOCK TABLES does not work (myodbc) [message #36356]

Fri, 05 September 2003 04:07

Olaf Stetzer
Messages: 39
Registered: September 2001

Member

Hello,

I am currently writing function/procedure
which writes data to a mysql-table
(using myodbc on Win2000). I want
to do it as correct as possible and tried
LOCK TABLES (with: dbobj->ExecuteSQL) for
the first time.

Unfortunately I got an error message that
I cannot write to the table afterwards because
it is locked! I used the same database object
for locking and writing of course. I am not
sure if myodbc or dataminer is to blame but
it seems, that for both SQL-statements individual
database-threads are started. LOCKING is only
working inside the same thread, though!

Anyone having experience in these issues? I have
once again the feeling that the dataminer is only
providing a very minimum of database functionality
for a very high price! :-(

Olaf (a little bit disappointed)

Report message to a moderator

[Message index]

Dataminer: LOCK TABLES does not work (myodbc)

By: Olaf Stetzer on Fri, 05 September 2003 04:07

Previous Topic:	matchup of Map_set & contour
Next Topic:	Installing IDL 6.0 on Mac OS X

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Oct 10 10:27:00 PDT 2025

Total time taken to generate the page: 0.24071 seconds