GMS - Ulrich Hutter
2010-11-16 23:46:38 UTC
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
***@gms.info, 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)
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
Firebird-odbc-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
To: firebird-odbc-***@lists.sourceforge.net
To: ***@gmail.com
firebird-odbc-***@lists.sourceforge.net
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
***@gms.info, 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)
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 fromi 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
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
Firebird-odbc-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
To: firebird-odbc-***@lists.sourceforge.net
To: ***@gmail.com
firebird-odbc-***@lists.sourceforge.net