[Firebird-odbc-devel] Re-2: ODBC Lockin in version 2.0.0.148 -please help

[GMS - U. H. <ul...@gm...>]

hi

i tested it with the new driver 150.
Now the isolation level works correct! thanks.
i also tested it again with the 138 version - this one doesn't work.
so you defenitly solved the problem

thx




Ulrich Hutter
Programmierung & Geschäftsführung
und stolzer Vater: www.hutter.at/konrad
GMS Zentrale
5582 St. Michael im Lungau, Katschberg 423
Tel: +43/4734/627 50, Fax: +43/4734/627 51
ul...@gm..., www.gms.info  
Firma: GMS Hutter GmbH & Co KG, Rechtsform: GmbH & Co KG, Firmensitz: Salzburg, Firmenbuchnummer: FN 172325 w, Firmenbuchgericht: Handelsgericht 
Salzburg, DVR: 1042688, Komplementär: Hutter GmbH, Sitz: 5582 St. Michael, Katschberg 423,  FB-Gericht Salzburg, FN 196476k

Wichtiger Hinweis: Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich 
erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns 
und vernichten Sie die empfangene E-Mail. Vielen Dank. 




        processed by David.fx 
Subject: Re: [Firebird-odbc-devel] ODBC Lockin in version 2.0.0.148 -please help (16-Okt-2010 0:30)
From:    bill lam <bbi...@gm...>
To:      ul...@gm...


Птн, 15 Окт 2010, GMS - Ulrich Hutter писал(а):
> hi everybody, 
> 
> i changed to firebird 2.5 and the odbc driver 2.0.0.148 (Version 144 does not work on firebird 2.1 above)
> Know i have a very big transaction problem.
> I start a transaction in my application - so one row in my table is locked.
> now i can not read with the ODBC driver this row - i always get a lock conflict 40001.
> I just want to read, not to write.
> of course i tried all setting in the odbc administrator. (read, nowait)
> I want to print with crystal report, so i can not directly change the connection string.
> 
> This worked very well with odbd 2.0.0.144 (i tested it know again)
> 
> Because of this behaviour, i can not change to firebird 2.5

Not sure how did you set the isolation level. IIRC that cannot be set from
odbcad32 panel, the read option only indicate one will not write data but
it does not override transaction isolation. Firebird engine itself does
not support read uncommitted. I'm not sure this changed in fb 2.5. You may
try testing with odbc 148 with your original fb engine (2.1?) to confirm
whether this is a problem of odbc driver. 

-- 
regards,
====================================================
GPG key 1024D/4434BAB3 2008-08-24
gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3

------------------------------------------------------------------------------
The Next 800 Companies to Lead America's Growth: New Video Whitepaper
David G. Thomson, author of the best-selling book "Blueprint to a 
Billion" shares his insights and actions to help propel your 
business during the next growth cycle. Listen Now!
http://p.sf.net/sfu/SAP-dev2dev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

To: fir...@li...

To: bbi...@gm...
    fir...@li...