Menu
▾
▴
firebird-odbc-devel — All about development of Firebird ODBC driver donated by IBPhoenix
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(23) |
Sep
(6) |
Oct
(2) |
Nov
(2) |
Dec
(5) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
|
Feb
(14) |
Mar
(16) |
Apr
(14) |
May
(25) |
Jun
(38) |
Jul
(22) |
Aug
(39) |
Sep
(3) |
Oct
(13) |
Nov
(47) |
Dec
(3) |
| 2003 |
Jan
(38) |
Feb
(39) |
Mar
(24) |
Apr
(57) |
May
(30) |
Jun
|
Jul
(39) |
Aug
(90) |
Sep
(41) |
Oct
(141) |
Nov
(158) |
Dec
(137) |
| 2004 |
Jan
(86) |
Feb
(169) |
Mar
(100) |
Apr
(83) |
May
(94) |
Jun
(77) |
Jul
(85) |
Aug
(54) |
Sep
(45) |
Oct
(36) |
Nov
(42) |
Dec
(70) |
| 2005 |
Jan
(46) |
Feb
(44) |
Mar
(50) |
Apr
(73) |
May
(90) |
Jun
(87) |
Jul
(41) |
Aug
(47) |
Sep
(28) |
Oct
(23) |
Nov
(44) |
Dec
(81) |
| 2006 |
Jan
(21) |
Feb
(9) |
Mar
(82) |
Apr
(14) |
May
(109) |
Jun
(175) |
Jul
(188) |
Aug
(44) |
Sep
(5) |
Oct
(47) |
Nov
(15) |
Dec
(34) |
| 2007 |
Jan
(75) |
Feb
(24) |
Mar
(30) |
Apr
(4) |
May
(28) |
Jun
(9) |
Jul
(13) |
Aug
(13) |
Sep
(29) |
Oct
(15) |
Nov
(19) |
Dec
(12) |
| 2008 |
Jan
(7) |
Feb
(19) |
Mar
(1) |
Apr
(7) |
May
(13) |
Jun
(19) |
Jul
(17) |
Aug
(29) |
Sep
(15) |
Oct
(37) |
Nov
(18) |
Dec
(29) |
| 2009 |
Jan
(23) |
Feb
(12) |
Mar
(8) |
Apr
(16) |
May
(11) |
Jun
(1) |
Jul
(2) |
Aug
(1) |
Sep
|
Oct
(9) |
Nov
(17) |
Dec
(31) |
| 2010 |
Jan
(15) |
Feb
(5) |
Mar
(4) |
Apr
(8) |
May
(1) |
Jun
(5) |
Jul
(17) |
Aug
(2) |
Sep
(12) |
Oct
(33) |
Nov
(14) |
Dec
(24) |
| 2011 |
Jan
(11) |
Feb
(2) |
Mar
(34) |
Apr
(11) |
May
(12) |
Jun
(3) |
Jul
(6) |
Aug
(11) |
Sep
(10) |
Oct
(1) |
Nov
(8) |
Dec
|
| 2012 |
Jan
(16) |
Feb
(2) |
Mar
|
Apr
(2) |
May
(6) |
Jun
(2) |
Jul
(7) |
Aug
|
Sep
|
Oct
(7) |
Nov
(22) |
Dec
(2) |
| 2013 |
Jan
(1) |
Feb
(24) |
Mar
(15) |
Apr
(2) |
May
(3) |
Jun
|
Jul
(2) |
Aug
|
Sep
(2) |
Oct
(6) |
Nov
(10) |
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(4) |
Nov
|
Dec
(5) |
| 2015 |
Jan
(1) |
Feb
(4) |
Mar
(3) |
Apr
(3) |
May
|
Jun
(3) |
Jul
(1) |
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(1) |
Feb
(9) |
Mar
(4) |
Apr
|
May
(6) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(7) |
Nov
(13) |
Dec
|
| 2017 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
(12) |
Oct
(4) |
Nov
|
Dec
|
| 2018 |
Jan
(6) |
Feb
|
Mar
|
Apr
|
May
(6) |
Jun
|
Jul
(9) |
Aug
(4) |
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
(1) |
Feb
|
Mar
(4) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2020 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
(3) |
Aug
|
Sep
|
Oct
(3) |
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(4) |
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2023 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2025 |
Jan
|
Feb
(2) |
Mar
|
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Alexander P. <ale...@gm...> - 2010-11-19 10:45:32
|
On 19.11.2010 3:18, Chris Scott wrote: > > We have a server running SAP Crystal Server XI. We use the program > called infoview (web portal) to run crystal reports. This connects to > the firebird 1.5 database using an ODBC connection. My understanding > is that the firebird ODBC driver uses connection pooling. Is it > possible to configure the min and max connections in this connection pool? > > I have looked at the source code. Firebird ODBC driver doesn't use connection pooling apparently. -- Regards, Alexander Potapchenko |
|
From: Chris S. <CS...@sg...> - 2010-11-19 00:18:12
|
We have a server running SAP Crystal Server XI. We use the program called infoview (web portal) to run crystal reports. This connects to the firebird 1.5 database using an ODBC connection. My understanding is that the firebird ODBC driver uses connection pooling. Is it possible to configure the min and max connections in this connection pool? |
|
From: <hor...@t-...> - 2010-11-17 16:12:34
|
|
From: GMS - U. H. <ul...@gm...> - 2010-11-16 23:46:46
|
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... |
|
From: Paul R. <pr...@ib...> - 2010-10-28 08:31:36
|
On Thursday 28 October 2010, bill lam wrote: > The developers of svn or git can give some reasons. I'm not going to > argue unless the maintainers are also interested in migrating to > another scm. I just want to create a branch for hacking and still be > able to rebase from the main trunk in the future. I'd say that the scm tool was the least of your worries. There is nothing to stop you using git locally and merging upstream changes into your code as and when they are made. When it comes to pushing your changes, well, you'll need to prepare patches for review. Commit rights would only come later. If you get to the point where you are committed enough to the further development of the driver there would be no problem adding you as a developer. Then you could push the migration to svn or git yourself. Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support |
|
From: bill l. <cbi...@gm...> - 2010-10-28 07:17:20
|
Чтв, 28 Окт 2010, Paul Reeves писал(а): > On Thursday 28 October 2010, bill lam wrote: > > The odbcfb source repository uses cvs, is it available in git? svn > > should also be ok. > > No and no. > > But why? ... The developers of svn or git can give some reasons. I'm not going to argue unless the maintainers are also interested in migrating to another scm. I just want to create a branch for hacking and still be able to rebase from the main trunk in the future. -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 |
|
From: Paul R. <pr...@ib...> - 2010-10-28 06:45:43
|
On Thursday 28 October 2010, bill lam wrote: > The odbcfb source repository uses cvs, is it available in git? svn > should also be ok. No and no. But why? CVS works and the odbc code base is small. It is not as if dozens or hundreds of developers are needing to co-ordinate their work on the code. Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support |
|
From: bill l. <cbi...@gm...> - 2010-10-28 01:56:47
|
The odbcfb source repository uses cvs, is it available in git? svn should also be ok. -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 |
|
From: Paul R. <pr...@ib...> - 2010-10-22 09:38:04
|
On Friday 22 October 2010, Caillet Cedric wrote: > Hello, > > I would like to communicate with ODBC Drier between a RedHat Linux > 5.4 x86_64 server and a W2K3 server on which I have installed an > InterBase 6. > > My W2K3 platform work perfectly, but I can't intall succesfully the > Firebird ODBC Driver on the RedHat server. > > I'm forced to use an 32 bit version of my driver. > Have you got the correct client library installed on the RedHat box? The driver will have been built against firebird and you'll probably have to install Firebird do get the client library. Whether it will work with a remote interbase server is unknown, at least to me. And likewise, I don't know whether it will work if it tries to load an InterBase version of gds32. Failing that, the latest code base for v2 of the driver has better compilation support for InterBase. You may be able to get better results by installing a Linux version of IB6 and then building the driver against that. (Or even build Fb 1.0 - that is more or less 100% compatible with IB6). Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support |
|
From: Caillet C. <cca...@so...> - 2010-10-22 08:35:12
|
Hello,
I would like to communicate with ODBC Drier between a RedHat Linux 5.4 x86_64 server and a W2K3 server on which I have installed an InterBase 6.
My W2K3 platform work perfectly, but I can't intall succesfully the Firebird ODBC Driver on the RedHat server.
I'm forced to use an 32 bit version of my driver.
I have installed unixODBC and OdbcFb-LIB-RC1-2.0.0148.i686.tar.gz and do the following test :
ldd /logiciels/pcent186/PowerCenter8.6.1/unixodbc/lib/libOdbcFb.so
linux-gate.so.1 => (0xffffe000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0xf7e59000)
libdl.so.2 => /lib/libdl.so.2 (0xf7e55000)
libodbcinst.so.1 => /usr/lib/libodbcinst.so.1 (0xf7e45000)
libstdc .so.6 => /usr/lib/libstdc .so.6 (0xf7d5b000)
libm.so.6 => /lib/libm.so.6 (0xf7d34000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xf7d28000)
libc.so.6 => /lib/libc.so.6 (0xf7be2000)
/lib/ld-linux.so.2 (0x009c7000)
libpthread.so.0 => /lib/libpthread.so.0 (0xf7bcb000)
isql -v SPA_BU45_DEV login password
Memory fault
This is my odbc.ini :
[ODBC Data Sources]
SPA_BU45_DEV = Dump of SPA BU45
[SPA_BU45_DEV]
Driver = /logiciels/pcent186/PowerCenter8.6.1/unixodbc/lib/libOdbcFb.so
Client = /logiciels/pcent186/PowerCenter8.6.1/unixodbc/lib/libOdbcFb.so
Dbname = 163.80.36.135:D:\aero\GDB\SPA_BU45.GDB
# Dbname = 163.80.36.135:D:\appli\ServiceEngine-Dev\Secondary\file\interbase\gdb\SPA_BU45.GDB
Role =
Set =
ReadOnly = No
NoWait = No
I have the same problem when I have used an odbcinst.ini for declaring my driver.
Thanks for your help.
Cédric Caillet
|
|
From: Helen B. <he...@ii...> - 2010-10-18 22:51:21
|
At 10:11 AM 19/10/2010, stevyn dembo wrote: >Hi: > >Don't know what the bag tracker is. Firebird Project's bug tracker. Everything you need to know is here: http://www.firebirdsql.org/index.php?op=devel&sub=odbc Helen |
|
From: Ann W. H. <aha...@ib...> - 2010-10-18 21:21:23
|
On 10/18/2010 5:01 PM, GMS - Ulrich Hutter wrote: > how can i write to "bag tracker"? Alex meant to write "bug tracker" which is available here: http://tracker.firebirdsql.org/secure/CreateIssue!default.jspa?pid=10004 Good luck, Ann |
|
From: stevyn d. <sr...@ya...> - 2010-10-18 21:11:10
|
Hi:
Don't know what the bag tracker is.
This has been an outstanding problem for over a year now:
I am continuing to get these errors using OdbcFb.dll version 2.0.0.148. These are entries in the Windows 2003 R2 event log:
Faulting application dllhost.exe, version 5.2.3790.3959, faulting module OdbcFb.dll, version 2.0.0.148, fault address 0x00022cc4.
The system has called a custom component and that component has failed and generated an exception. This indicates a problem with the custom component. Notify the developer of this component that a failure has occurred and provide them with the information below.
Component Prog ID:
Server Application ID: {6EA2FA28-A7F8-4BA7-97FD-FEC4901A2248}
Server Application Instance ID:
{CDF2EC1D-2890-4019-853E-DF47053C76E9}
Server Application Name: LSMSWAPP
The serious nature of this error has caused the process to terminate.
Exception: C0000005
Address: 0x10022CC4
Call Stack:
OdbcFb!SQLSetStmtAttrW + 0x204
I reported this problem a while back but have not seen anything since to resolve this issue.
This problem is negatively impacting a production system. Should I be posting this problem elsewhere?
Firebird Server Version is WI-V2.1.2.18118 Firebird 2.1
Any help in addressing this issue would be appreciated.
regards,
stevyn r dembo
This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended you are hereby notified
that any dissemination, distribution or copying of this
communication is strictly prohibited. If you are not the intended reader, then you must destroy this communication immediately.
--- On Mon, 10/18/10, Alexander Potapchenko <ale...@gm...> wrote:
From: Alexander Potapchenko <ale...@gm...>
Subject: [Firebird-odbc-devel] ODBC Driver Project Lives Again
To: fir...@li...
Received: Monday, October 18, 2010, 10:05 AM
Hi to all,
I resume development of the ODBC driver. The primary goal to finish ODBC
driver 2.0 (with full x64 support and fixed "blocker" level problems) now.
If you are having any problems with the current driver but have not
reported them because the sub-project wasn't active, then to add them to
the Bag tracker now.
Regards,
Alexander
--
Alexander Potapchenko
Senior developer
------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
|
|
From: GMS - U. H. <ul...@gm...> - 2010-10-18 21:01:37
|
dear alex, do you know, when "now" is? how can i write to "bag tracker"? thx a lot Herzliche Grüße vom Katschberg PS: Kommen Sie zum nächsten E-Commerce Workshop am 19.10.2010 ab 13.00 Uhr im Hotel Schönruh in Seefeld. Besuchen Sie uns bei der "Alles für den Gast" von 06. bis 10.11.2010 - Halle 4 Stand 403. Wir freuen uns auf Ihren Besuch - hier geht es zur Hallenübersicht. 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: [Firebird-odbc-devel] ODBC Driver Project Lives Again (18-Okt-2010 19:05) From: Alexander Potapchenko <ale...@gm...> To: ul...@gm... Hi to all, I resume development of the ODBC driver. The primary goal to finish ODBC driver 2.0 (with full x64 support and fixed "blocker" level problems) now. If you are having any problems with the current driver but have not reported them because the sub-project wasn't active, then to add them to the Bag tracker now. Regards, Alexander -- Alexander Potapchenko Senior developer ------------------------------------------------------------------------------ Download new Adobe(R) Flash(R) Builder(TM) 4 The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly Flex(R) Builder(TM)) enable the development of rich applications that run across multiple browsers and platforms. Download your free trials today! http://p.sf.net/sfu/adobe-dev2dev _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel To: fir...@li... To: ale...@gm... fir...@li... |
|
From: Jorge A. B. <li...@da...> - 2010-10-18 17:56:24
|
Great news!! Where is the "bag tracker"? //Some kind of ecology system? ;)/ /Really, it´s a very good announcement. Thanks!/ / Regards! El 18/10/2010 02:05 p.m., Alexander Potapchenko escribió: > Hi to all, > > I resume development of the ODBC driver. The primary goal to finish ODBC > driver 2.0 (with full x64 support and fixed "blocker" level problems) now. > If you are having any problems with the current driver but have not > reported them because the sub-project wasn't active, then to add them to > the Bag tracker now. > > Regards, > Alexander > |
|
From: Roberto C. | U. <rob...@un...> - 2010-10-18 17:50:26
|
Good! I am very concerned about the fact that the latest stable version of the ODBC driver for firebird on September 5, 2004. How many systems can communicate with the Firebird ODBC Driver through we were running the risk that the development of this driver does not follow the development of versions of firebird. Hopefully the shekel of developing new versions of this driver will not take so long. -------------------------------------------------- From: "Alexander Potapchenko" <ale...@gm...> Sent: Monday, October 18, 2010 3:05 PM To: <fir...@li...> Subject: [Firebird-odbc-devel] ODBC Driver Project Lives Again > Hi to all, > > I resume development of the ODBC driver. The primary goal to finish ODBC > driver 2.0 (with full x64 support and fixed "blocker" level problems) now. > If you are having any problems with the current driver but have not > reported them because the sub-project wasn't active, then to add them to > the Bag tracker now. > > Regards, > Alexander > > -- > Alexander Potapchenko > Senior developer > > ------------------------------------------------------------------------------ > Download new Adobe(R) Flash(R) Builder(TM) 4 > The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly > Flex(R) Builder(TM)) enable the development of rich applications that run > across multiple browsers and platforms. Download your free trials today! > http://p.sf.net/sfu/adobe-dev2dev > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > |
|
From: Alexander P. <ale...@gm...> - 2010-10-18 17:05:15
|
Hi to all, I resume development of the ODBC driver. The primary goal to finish ODBC driver 2.0 (with full x64 support and fixed "blocker" level problems) now. If you are having any problems with the current driver but have not reported them because the sub-project wasn't active, then to add them to the Bag tracker now. Regards, Alexander -- Alexander Potapchenko Senior developer |
|
From: bill l. <cbi...@gm...> - 2010-10-18 05:09:25
|
AFAIK those setting in odbad32 panel have nothing to do with transaction isolation. Not sure why you didn't get the record lock problem in earlier versions if those read/nowait options in odbc admin are all that you had tweaked. I guess you can ask in firebird support forum for how to set the isolation level that you wanted but not so sure if crystal report will provide a chance for you to execute that required sql statements. -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 |
|
From: bill l. <bbi...@gm...> - 2010-10-15 23:31:07
|
Птн, 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 |
|
From: GMS - U. H. <ul...@gm...> - 2010-10-15 22:09:04
|
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 --- please can anyone help me? thanks a lot greetings from austria Ulrich Hutter 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. |
|
From: bill l. <cbi...@gm...> - 2010-10-05 23:21:13
|
Втр, 05 Окт 2010, Steve писал(а):
> Hi Bill,
>
> >You did not show how you call sqlbindcol, without detail it is hard to
> >guess what was wrong.
>
> I don't know what sqlbindcol is, all I do is:
>
> my $dbh = DBI->connect("DBI:ODBC:END_DB");
>
> Which calls the unixODBC driver manager.
Without knowing how DBI call sqlbindcol, and how it decodes the buffer
after fetching a row, or what is the output of sqldescribecol,
it will be also possible that the culprit being DBI itself. However my
knowledge of perl is very limited.
--
regards,
====================================================
GPG key 1024D/4434BAB3 2008-08-24
gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3
|
|
From: Steve <it...@sc...> - 2010-10-05 21:44:26
|
Hi Bill,
>You did not show how you call sqlbindcol, without detail it is hard to
>guess what was wrong.
I don't know what sqlbindcol is, all I do is:
my $dbh = DBI->connect("DBI:ODBC:END_DB");
Which calls the unixODBC driver manager.
Which is directed to the database and diver as follows:
odbcinst.ini>>
[Firebird]
Description = Firebird/InterBase(r) driver
Driver = /usr/lib/libOdbcFb.so
Setup = /usr/lib/libOdbcFb.so
UsageCount = 2
odbc.ini>>
[END_DB]
Description = Firebird
Driver = Firebird
Dbname = localhost:/home/steve/Documents/Endoscopia/DB/ENDOSCOPIA.FDB
Client =
User = SYSDBA
Password = masterkey
Role =
CharacterSet = NONE
ReadOnly = No
NoWait = No
Dialect = 3
QuotedIdentifier = Yes
SensitiveIdentifier = No
AutoQuotedIdentifier = No
But I'm not sure this answers your question.
Regards
Steve
|
|
From: Steve <it...@sc...> - 2010-10-05 15:05:40
|
Here is a resend of the original message (including .ini files) from March this year. Is that what you meant? I can send you the Perl code snippet if you like, but maybe that's too much detail. Regards Steve > Sent: 24 March 2010 21:50 > > Hi People, > > I am using Perl on Linux (Kubuntu 9.10) with Firebird 2.1. I > wanted to use > ODBC, but in the end I gave up using it because I couldn't > get the DATE or > number formats to work. Instead I used the DBI::Interbase > driver, while it > works, it is subject to occasional crashes, so I'd like to go > back to trying > ODBC. > > My current problem is that if I use isql on employee.fbd, (eg > select first 1 > change_date from salary_history), I get: > > 1992-12-15 00:00:00. (Data type timestamp) > > if I use it on my own database, (eg select first 1 > att_patient_examination_ddt from tbl_patient_exam), I get: > > 22256-10-18. (Data type date) > > Any ideas what I could do? > > Well, actually, writing that last bit has helped. If I > change from a DATE > data type to a TIMESTAMP, it seems to work, but now I need to > check time > fields and number fields. Surely the DATE format should > work? What do I > need to do to fix this (NB Flamerobin has no such problems on the same > field)? I am also encoutering other sporadic problems such > as a read being > successful one moment and unsuccessful the next? Is this a > known problem? > > Regards > > Steve > > The odbcinst.ini file entry is: > > [Firebird] > Description = Firebird/InterBase(r) driver > Driver = /usr/lib/libOdbcFb.so > Setup = /usr/lib/libOdbcFb.so > UsageCount = 2 > > The odbc.ini file entries are: > > [END_DB] > Description = Firebird > Driver = Firebird > Dbname = localhost:/home/steve/Documents/Endoscopia/DB/ENDOSCOPIA.FDB > Client = > User = SYSDBA > Password = masterkey > Role = > CharacterSet = NONE > ReadOnly = No > NoWait = No > Dialect = 3 > QuotedIdentifier = Yes > SensitiveIdentifier = No > AutoQuotedIdentifier = No > > [Employee] > Description = Firebird > Driver = Firebird > Dbname = localhost:/home/steve/Documents/employee.fdb > Client = > User = SYSDBA > Password = masterkey > Role = > CharacterSet = NONE > ReadOnly = No > NoWait = No > Dialect = 3 > QuotedIdentifier = Yes > SensitiveIdentifier = No > AutoQuotedIdentifier = No > |
|
From: bill l. <cbi...@gm...> - 2010-10-05 15:04:27
|
Steve, You did not show how you call sqlbindcol, without detail it is hard to guess what was wrong. Втр, 05 Окт 2010, Steve писал(а): > Here is a resend of the original message (including .ini files) from March > this year. > > Is that what you meant? I can send you the Perl code snippet if you like, > but maybe that's too much detail. > > Regards > > Steve > > > Sent: 24 March 2010 21:50 > > > > Hi People, > > > > I am using Perl on Linux (Kubuntu 9.10) with Firebird 2.1. I > > wanted to use > > ODBC, but in the end I gave up using it because I couldn't > > get the DATE or > > number formats to work. Instead I used the DBI::Interbase > > driver, while it > > works, it is subject to occasional crashes, so I'd like to go > > back to trying > > ODBC. > > > > My current problem is that if I use isql on employee.fbd, (eg > > select first 1 > > change_date from salary_history), I get: > > > > 1992-12-15 00:00:00. (Data type timestamp) > > > > if I use it on my own database, (eg select first 1 > > att_patient_examination_ddt from tbl_patient_exam), I get: > > > > 22256-10-18. (Data type date) > > > > Any ideas what I could do? > > > > Well, actually, writing that last bit has helped. If I > > change from a DATE > > data type to a TIMESTAMP, it seems to work, but now I need to > > check time > > fields and number fields. Surely the DATE format should > > work? What do I > > need to do to fix this (NB Flamerobin has no such problems on the same > > field)? I am also encoutering other sporadic problems such > > as a read being > > successful one moment and unsuccessful the next? Is this a > > known problem? > > > > Regards > > > > Steve > > > > The odbcinst.ini file entry is: > > > > [Firebird] > > Description = Firebird/InterBase(r) driver > > Driver = /usr/lib/libOdbcFb.so > > Setup = /usr/lib/libOdbcFb.so > > UsageCount = 2 > > > > The odbc.ini file entries are: > > > > [END_DB] > > Description = Firebird > > Driver = Firebird > > Dbname = localhost:/home/steve/Documents/Endoscopia/DB/ENDOSCOPIA.FDB > > Client = > > User = SYSDBA > > Password = masterkey > > Role = > > CharacterSet = NONE > > ReadOnly = No > > NoWait = No > > Dialect = 3 > > QuotedIdentifier = Yes > > SensitiveIdentifier = No > > AutoQuotedIdentifier = No > > > > [Employee] > > Description = Firebird > > Driver = Firebird > > Dbname = localhost:/home/steve/Documents/employee.fdb > > Client = > > User = SYSDBA > > Password = masterkey > > Role = > > CharacterSet = NONE > > ReadOnly = No > > NoWait = No > > Dialect = 3 > > QuotedIdentifier = Yes > > SensitiveIdentifier = No > > AutoQuotedIdentifier = No > > > -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 |
|
From: bill l. <cbi...@gm...> - 2010-10-05 14:33:54
|
Втр, 05 Окт 2010, Steve Cookson писал(а): > I guess this the source of the problem I had earlier this year. > > > I am using Perl on Linux (Kubuntu 9.10) with Firebird 2.1. I > > wanted to use > > ODBC, but in the end I gave up using it because I couldn't > > get the DATE or > > number formats to work. Instead I used the DBI::Interbase > > driver, while it > > works, it is subject to occasional crashes, so I'd like to go > > back to trying > > ODBC. > > I'd still like to use ODBC, but for the moment, I'm putting up with DBI. Do > we have any idea when the next release will be available? If I can help > with testing, I'd be happy to. > The 32-bit driver works ok for all common data types that I used. Except sql_numeric which I don't need so not tested. But the 64-bit drivers need some fixes. Perhaps you could give some context of your problem, did you call odbc api directly or via some wrapping library? -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 |
71 messages has been excluded from this view by a project administrator.
