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: Paul R. <pr...@ib...> - 2009-12-08 07:13:55
|
On Monday 07 December 2009, tom interface wrote: > > Le pilote spécifié n'a pas été chargé en raison de l'erreur système 193 > (Firebird/InterBase(r) driver). > This indicates you may have a mismatch between a 32-bit app and a 64-bit driver, or vice-versa. Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support |
|
From: tom i. <to...@in...> - 2009-12-07 21:39:58
|
Thanks Roman, When i replace the files i have this error (i restart the server) : Microsoft OLE DB Provider for ODBC Drivers erreur '80004005' Le pilote spécifié n'a pas été chargé en raison de l'erreur système 193 (Firebird/InterBase(r) driver). my connection string : DRIVER=Firebird/InterBase(r) driver;DBNAME=127.0.0.1:d:\xxxx\xxx.fdb;UID=aaa;PWD=xxxx Thanks Tom ----- Original Message ----- From: "Roman Simakov" <rom...@gm...> To: <fir...@li...> Sent: Monday, December 07, 2009 8:36 PM Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 server > Tom, > > for 148 build there is no debug information. It means I can't see > function and parameters for your dump. I suggest you to try more fresh > build 149. You can find it here > http://www.firebirdsql.org/downloads/snapshot_builds/odbc/. > > You can just replace driver files from OdbcFb_DLL_2-0-0149_Win32.zip. > After try to create dump again. I'll also install this version on my > machine and try to open a new dump. > > -- > Roman Simakov > > tom interface wrote: >> Thanks Roman for your answer >> >> I put a dump generated when the first database connection is opened on my >> application on : www.interface.nc/dump.zip >> >> When i activate debug in ODBC manager the log is always empty ? >> >> Tom >> >> ----- Original Message ----- >> From: "Roman Simakov" <rom...@gm...> >> To: <fir...@li...> >> Sent: Friday, December 04, 2009 8:42 PM >> Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 >> server >> >> >>> Hi tom! >>> >>> It would be good to look at call stack. Can you get it on your machine? >>> Maybe userdump can help. Also odbc debug can be useful. It can trace >>> call of every function in ODBC driver with parameters. >>> >>> Without that it's difficult to understand what's happen. >>> >>> >>> -- >>> Roman Simakov >>> >>> tom interface wrote: >>>> Hi, >>>> >>>> i'm french so excuse me for my english. >>>> >>>> I have a classic ASP application with Firebird server (1.5.5.4926) with >>>> ODBC 2.0.0.148 >>>> >>>> There's only one server for IIS and Firebird and i've 60 users, and each >>>> have his connection string (so i can't use pooling) >>>> >>>> My connection string is : >>>> >>>> "Driver=Firebird/InterBase(r) >>>> driver;Uid=mylogin;Pwd=mypass;DbName=127.0.0.1:d:\database\xxxxxx.fdb" >>>> >>>> Sometimes, when the connection is opened i have intermittent 800a01fb >>>> error and by day it represents hundreds of error 500. I look in the IIS >>>> log and when i try the page that cause error, no problem for me. Users >>>> told me that when they refresh sometimes it works sometimes not. >>>> >>>> I'm using lots of response.redirect but always close and set nothing for >>>> connection and recordset before. >>>> >>>> I use debugdiag and have always this message (sometimes very quickly >>>> when i open connection to firebird): >>>> >>>> In w3wp__PID__2620__Date__12_02_2009__Time_01_19_58PM__499__First Chance >>>> Access Violation.dmp the assembly instruction at >>>> *OdbcFb!SQLSetDescFieldW+5478* in *C:\WINDOWS\system32\OdbcFb.dll* from >>>> *IBPhoenix Inc* has caused an *access violation exception (0xC0000005)* >>>> when trying to *read from* memory location *0x0c641000* on thread *67* >>>> <mhtml:file://C:\Program >>>> Files\DebugDiag\Reports\CrashHang_Report__PID_2620__PID_5852(1_dumps)__120220091506084.mht#2620:25382Thread4468> >>>> >>>> I look for a solution for a long time but can't find a solution to solve >>>> this >>>> >>>> Can anyone help me ?? security rights problem ? Too many connections ? >>>> >>>> I hope someone can help >>>> >>>> Thanks >>>> >>>> Tom >>>> > > > ------------------------------------------------------------------------------ > Join us December 9, 2009 for the Red Hat Virtual Experience, > a free event focused on virtualization and cloud computing. > Attend in-depth sessions from your desk. Your couch. Anywhere. > http://p.sf.net/sfu/redhat-sfdev2dev > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > __________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > __________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
From: Roman S. <rom...@gm...> - 2009-12-07 09:36:39
|
Tom, for 148 build there is no debug information. It means I can't see function and parameters for your dump. I suggest you to try more fresh build 149. You can find it here http://www.firebirdsql.org/downloads/snapshot_builds/odbc/. You can just replace driver files from OdbcFb_DLL_2-0-0149_Win32.zip. After try to create dump again. I'll also install this version on my machine and try to open a new dump. -- Roman Simakov tom interface wrote: > Thanks Roman for your answer > > I put a dump generated when the first database connection is opened on my > application on : www.interface.nc/dump.zip > > When i activate debug in ODBC manager the log is always empty ? > > Tom > > ----- Original Message ----- > From: "Roman Simakov" <rom...@gm...> > To: <fir...@li...> > Sent: Friday, December 04, 2009 8:42 PM > Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 > server > > >> Hi tom! >> >> It would be good to look at call stack. Can you get it on your machine? >> Maybe userdump can help. Also odbc debug can be useful. It can trace >> call of every function in ODBC driver with parameters. >> >> Without that it's difficult to understand what's happen. >> >> >> -- >> Roman Simakov >> >> tom interface wrote: >>> Hi, >>> >>> i'm french so excuse me for my english. >>> >>> I have a classic ASP application with Firebird server (1.5.5.4926) with >>> ODBC 2.0.0.148 >>> >>> There's only one server for IIS and Firebird and i've 60 users, and each >>> have his connection string (so i can't use pooling) >>> >>> My connection string is : >>> >>> "Driver=Firebird/InterBase(r) >>> driver;Uid=mylogin;Pwd=mypass;DbName=127.0.0.1:d:\database\xxxxxx.fdb" >>> >>> Sometimes, when the connection is opened i have intermittent 800a01fb >>> error and by day it represents hundreds of error 500. I look in the IIS >>> log and when i try the page that cause error, no problem for me. Users >>> told me that when they refresh sometimes it works sometimes not. >>> >>> I'm using lots of response.redirect but always close and set nothing for >>> connection and recordset before. >>> >>> I use debugdiag and have always this message (sometimes very quickly >>> when i open connection to firebird): >>> >>> In w3wp__PID__2620__Date__12_02_2009__Time_01_19_58PM__499__First Chance >>> Access Violation.dmp the assembly instruction at >>> *OdbcFb!SQLSetDescFieldW+5478* in *C:\WINDOWS\system32\OdbcFb.dll* from >>> *IBPhoenix Inc* has caused an *access violation exception (0xC0000005)* >>> when trying to *read from* memory location *0x0c641000* on thread *67* >>> <mhtml:file://C:\Program >>> Files\DebugDiag\Reports\CrashHang_Report__PID_2620__PID_5852(1_dumps)__120220091506084.mht#2620:25382Thread4468> >>> >>> I look for a solution for a long time but can't find a solution to solve >>> this >>> >>> Can anyone help me ?? security rights problem ? Too many connections ? >>> >>> I hope someone can help >>> >>> Thanks >>> >>> Tom >>> |
|
From: Roman S. <rom...@gm...> - 2009-12-04 12:04:23
|
tom interface wrote: > Thanks Roman for your answer > > I put a dump generated when the first database connection is opened on my > application on : www.interface.nc/dump.zip > > When i activate debug in ODBC manager the log is always empty ? Not sure. It must trace every function call. I'm in linux now. When I will in Windows I'll try to open your dump and will take a look into ODBC debug again. > > Tom > > ----- Original Message ----- > From: "Roman Simakov" <rom...@gm...> > To: <fir...@li...> > Sent: Friday, December 04, 2009 8:42 PM > Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 > server > > >> Hi tom! >> >> It would be good to look at call stack. Can you get it on your machine? >> Maybe userdump can help. Also odbc debug can be useful. It can trace >> call of every function in ODBC driver with parameters. >> >> Without that it's difficult to understand what's happen. >> >> >> -- >> Roman Simakov >> >> tom interface wrote: >>> Hi, >>> >>> i'm french so excuse me for my english. >>> >>> I have a classic ASP application with Firebird server (1.5.5.4926) with >>> ODBC 2.0.0.148 >>> >>> There's only one server for IIS and Firebird and i've 60 users, and each >>> have his connection string (so i can't use pooling) >>> >>> My connection string is : >>> >>> "Driver=Firebird/InterBase(r) >>> driver;Uid=mylogin;Pwd=mypass;DbName=127.0.0.1:d:\database\xxxxxx.fdb" >>> >>> Sometimes, when the connection is opened i have intermittent 800a01fb >>> error and by day it represents hundreds of error 500. I look in the IIS >>> log and when i try the page that cause error, no problem for me. Users >>> told me that when they refresh sometimes it works sometimes not. >>> >>> I'm using lots of response.redirect but always close and set nothing for >>> connection and recordset before. >>> >>> I use debugdiag and have always this message (sometimes very quickly >>> when i open connection to firebird): >>> >>> In w3wp__PID__2620__Date__12_02_2009__Time_01_19_58PM__499__First Chance >>> Access Violation.dmp the assembly instruction at >>> *OdbcFb!SQLSetDescFieldW+5478* in *C:\WINDOWS\system32\OdbcFb.dll* from >>> *IBPhoenix Inc* has caused an *access violation exception (0xC0000005)* >>> when trying to *read from* memory location *0x0c641000* on thread *67* >>> <mhtml:file://C:\Program >>> Files\DebugDiag\Reports\CrashHang_Report__PID_2620__PID_5852(1_dumps)__120220091506084.mht#2620:25382Thread4468> >>> >>> I look for a solution for a long time but can't find a solution to solve >>> this >>> >>> Can anyone help me ?? security rights problem ? Too many connections ? >>> >>> I hope someone can help >>> >>> Thanks >>> >>> Tom >>> >> |
|
From: tom i. <to...@in...> - 2009-12-04 11:45:34
|
Thanks Roman for your answer I put a dump generated when the first database connection is opened on my application on : www.interface.nc/dump.zip When i activate debug in ODBC manager the log is always empty ? Tom ----- Original Message ----- From: "Roman Simakov" <rom...@gm...> To: <fir...@li...> Sent: Friday, December 04, 2009 8:42 PM Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 server > Hi tom! > > It would be good to look at call stack. Can you get it on your machine? > Maybe userdump can help. Also odbc debug can be useful. It can trace > call of every function in ODBC driver with parameters. > > Without that it's difficult to understand what's happen. > > > -- > Roman Simakov > > tom interface wrote: >> Hi, >> >> i'm french so excuse me for my english. >> >> I have a classic ASP application with Firebird server (1.5.5.4926) with >> ODBC 2.0.0.148 >> >> There's only one server for IIS and Firebird and i've 60 users, and each >> have his connection string (so i can't use pooling) >> >> My connection string is : >> >> "Driver=Firebird/InterBase(r) >> driver;Uid=mylogin;Pwd=mypass;DbName=127.0.0.1:d:\database\xxxxxx.fdb" >> >> Sometimes, when the connection is opened i have intermittent 800a01fb >> error and by day it represents hundreds of error 500. I look in the IIS >> log and when i try the page that cause error, no problem for me. Users >> told me that when they refresh sometimes it works sometimes not. >> >> I'm using lots of response.redirect but always close and set nothing for >> connection and recordset before. >> >> I use debugdiag and have always this message (sometimes very quickly >> when i open connection to firebird): >> >> In w3wp__PID__2620__Date__12_02_2009__Time_01_19_58PM__499__First Chance >> Access Violation.dmp the assembly instruction at >> *OdbcFb!SQLSetDescFieldW+5478* in *C:\WINDOWS\system32\OdbcFb.dll* from >> *IBPhoenix Inc* has caused an *access violation exception (0xC0000005)* >> when trying to *read from* memory location *0x0c641000* on thread *67* >> <mhtml:file://C:\Program >> Files\DebugDiag\Reports\CrashHang_Report__PID_2620__PID_5852(1_dumps)__120220091506084.mht#2620:25382Thread4468> >> >> I look for a solution for a long time but can't find a solution to solve >> this >> >> Can anyone help me ?? security rights problem ? Too many connections ? >> >> I hope someone can help >> >> Thanks >> >> Tom >> > > > ------------------------------------------------------------------------------ > Join us December 9, 2009 for the Red Hat Virtual Experience, > a free event focused on virtualization and cloud computing. > Attend in-depth sessions from your desk. Your couch. Anywhere. > http://p.sf.net/sfu/redhat-sfdev2dev > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > __________ Information from ESET Smart Security, version of virus > signature database 4659 (20091203) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > __________ Information from ESET Smart Security, version of virus signature database 4660 (20091204) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
From: Roman S. <rom...@gm...> - 2009-12-04 09:42:17
|
Hi tom! It would be good to look at call stack. Can you get it on your machine? Maybe userdump can help. Also odbc debug can be useful. It can trace call of every function in ODBC driver with parameters. Without that it's difficult to understand what's happen. -- Roman Simakov tom interface wrote: > Hi, > > i'm french so excuse me for my english. > > I have a classic ASP application with Firebird server (1.5.5.4926) with > ODBC 2.0.0.148 > > There's only one server for IIS and Firebird and i've 60 users, and each > have his connection string (so i can't use pooling) > > My connection string is : > > "Driver=Firebird/InterBase(r) > driver;Uid=mylogin;Pwd=mypass;DbName=127.0.0.1:d:\database\xxxxxx.fdb" > > Sometimes, when the connection is opened i have intermittent 800a01fb > error and by day it represents hundreds of error 500. I look in the IIS > log and when i try the page that cause error, no problem for me. Users > told me that when they refresh sometimes it works sometimes not. > > I'm using lots of response.redirect but always close and set nothing for > connection and recordset before. > > I use debugdiag and have always this message (sometimes very quickly > when i open connection to firebird): > > In w3wp__PID__2620__Date__12_02_2009__Time_01_19_58PM__499__First Chance > Access Violation.dmp the assembly instruction at > *OdbcFb!SQLSetDescFieldW+5478* in *C:\WINDOWS\system32\OdbcFb.dll* from > *IBPhoenix Inc* has caused an *access violation exception (0xC0000005)* > when trying to *read from* memory location *0x0c641000* on thread *67* > <mhtml:file://C:\Program > Files\DebugDiag\Reports\CrashHang_Report__PID_2620__PID_5852(1_dumps)__120220091506084.mht#2620:25382Thread4468> > > I look for a solution for a long time but can't find a solution to solve > this > > Can anyone help me ?? security rights problem ? Too many connections ? > > I hope someone can help > > Thanks > > Tom > |
|
From: tom i. <to...@in...> - 2009-12-03 07:56:45
|
Hi, i'm french so excuse me for my english. I have a classic ASP application with Firebird server (1.5.5.4926) with ODBC 2.0.0.148 There's only one server for IIS and Firebird and i've 60 users, and each have his connection string (so i can't use pooling) My connection string is : "Driver=Firebird/InterBase(r) driver;Uid=mylogin;Pwd=mypass;DbName=127.0.0.1:d:\database\xxxxxx.fdb" Sometimes, when the connection is opened i have intermittent 800a01fb error and by day it represents hundreds of error 500. I look in the IIS log and when i try the page that cause error, no problem for me. Users told me that when they refresh sometimes it works sometimes not. I'm using lots of response.redirect but always close and set nothing for connection and recordset before. I use debugdiag and have always this message (sometimes very quickly when i open connection to firebird): In w3wp__PID__2620__Date__12_02_2009__Time_01_19_58PM__499__First Chance Access Violation.dmp the assembly instruction at OdbcFb!SQLSetDescFieldW+5478 in C:\WINDOWS\system32\OdbcFb.dll from IBPhoenix Inc has caused an access violation exception (0xC0000005) when trying to read from memory location 0x0c641000 on thread 67 I look for a solution for a long time but can't find a solution to solve this Can anyone help me ?? security rights problem ? Too many connections ? I hope someone can help Thanks Tom __________ Information from ESET Smart Security, version of virus signature database 4656 (20091202) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
From: Jerry S. <je...@ap...> - 2009-11-24 19:49:32
|
Hi, I am failing to achieve an odbc connection using the 64-bit firebird driver on windows server 2008. Can anyone understand why? Settings>Control Panel>ODBC>System DNS Tab>Add DataSourceName=SMSReminders Driver=IscDbc Description=SMSReminders Database=D:\Program Files (x86)\SpectraSoft\Appointments\UEALive\APPOINTMENTSPRO.GDB Database Account=SYSDBA Password=masterkey [No other fields changed from defaults] On clicking 'Test Connection' error message is produced: "Open database 'D:\program files (x86)\SpectraSoft\Appointments\UEALive\APPOINTMENTSPRO.GDB' failed" This happens irrespective of the location of the gdb file. Firebird is running correctly and the gdb file can be accessed correctly by e.g. IBConsole Additional Info: 1) when turning on the ODBC trace tool and testing the connection, the log file does not contain any data. 2) When running procmon and testing the connection, no activity is visible Thanks, Jerry Jerry Dr Jerry Sanders Endeavour House 11 Genotin Terrace Enfield Middlesex EN1 2AF UK 0845 165 9155 *********************************************************************** This e-mail (and any attachment) is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44)(0)845 165 9155. Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. *********************************************************************** |
|
From: Łukasz T. <lt...@gm...> - 2009-11-20 10:37:15
|
Hello, I'm trying to run OdbcFb-Source-RC1-2.0.0148 under Solaris 10 (i386). I found in sources ...Builds/CC.solaris/makefile.solaris file that I used to build the driver. However I am wondering if it will be working? I tried to compile and use my driver with unixODBC and iODBC but unsuccessfully. Maybe someone compiled and used this sources on Solaris 10 (i386) and could help with this problem. I will be grateful for any help, Regards, Lukasz Tutaj |
|
From: Paul R. <pr...@ib...> - 2009-11-17 11:18:03
|
On Monday 16 November 2009, Steve Cookson wrote:
>
> Any suggestions welcome.
>
Can you reproduce the problem with 'select * from employee' from the
employee database? I just tried and the date is returned without problem.
Admittedly the employee database only uses the TIMESTAMP data type.
You could (and probably should) build the driver from source.
o Check out the code from cvs.
(Be sure to use the B2_0_0 tag)
o cd to /path/to/checkedoutcode/Builds/Gcc.lin
o type at command prompt:
make -f makefile.linux all install
That will give you build 149 which has all the bug fixes committed since
RC1. It will also guarantee that the build is fully compatible with the
host environment.
Let us know on this list how you get on.
Paul
--
Paul Reeves
http://www.ibphoenix.com
Specialists in Firebird support
|
|
From: stevyn d. <sr...@ya...> - 2009-11-16 22:34:46
|
Hello:
On a Windows 2003R2 system, I am having an intermittent problem with the ODBC driver. It is causing application transactions to fail. this info is from the Event Log:
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:
{8D038EAF-F627-4FF5-AF22-2FCC3AF79415}
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
Faulting application dllhost.exe, version 5.2.3790.3959, faulting module OdbcFb.dll, version 2.0.0.148, fault address 0x00022cc4.
Seems that the ODBC driver is having an access violation internally in the SetStmtAttrW routine.
We are running with 2.1.2.18118 version of Firebird.
Has anyone else has seen this problem?
regards
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.
__________________________________________________________________
The new Internet Explorer® 8 - Faster, safer, easier. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/ |
|
From: Steve C. <ste...@sc...> - 2009-11-16 15:55:11
|
Hi Nikolay, >1) Log the issue in the tracker with the reproducible test case Done: ODBC-76 >2) Please investigate the problem and submit a patch. Such portability >issues are almost always easy to spot and fix. I will review/apply the >patch. I'm developing in Perl, so I can't really do what you suggest, I suspect the code just needs recompiling for a 64-bit architecture, but I'm afraid I wouldn't know where to start. If there are some instructions somewhere, I'd be happy to have a go, but I'm afraid I'm not qualified to identify any issues. Any suggestions welcome. Regards Steve |
|
From: Nikolay S. <nik...@re...> - 2009-11-16 15:15:23
|
Hello, Steve! Steve Cookson wrote: >> I'm struggling to get the Firebird ODBC driver to work on a 64-bit >> Ubuntu system. I'm having problems inserting dates and integers from a >> simple C program. >> > > That's exactly it. > > I have a 64bit AMD machine. > > What do you think I need to do? Can you think of a work-around? > There are a few straightforward steps that will give you the result: 1) Log the issue in the tracker with the reproducible test case 2) Please investigate the problem and submit a patch. Such portability issues are almost always easy to spot and fix. I will review/apply the patch. -- Nikolay Samofatov, MBA Red Soft Corporation +7 495 668 3735 |
|
From: Steve C. <ste...@sc...> - 2009-11-16 15:00:21
|
>I'm struggling to get the Firebird ODBC driver to work on a 64-bit >Ubuntu system. I'm having problems inserting dates and integers from a >simple C program. That's exactly it. I have a 64bit AMD machine. What do you think I need to do? Can you think of a work-around? Thanks very much. Have a good day. Regards Steve |
|
From: David V. <da...@da...> - 2009-11-16 11:34:34
|
Are you using a 32-bit or 64-bit distribution? I'm struggling to get the Firebird ODBC driver to work on a 64-bit Ubuntu system. I'm having problems inserting dates and integers from a simple C program. David On 11/15/2009 07:35 AM, Steve Cookson wrote: > Hi People, > > I have a Firebird 2.1 database that works perfectly under Windows, but has > been problematic under a migration to Kubuntu 9.10 with ODBC driver > libOdbcFb.so. > > After initial problems installing and then using DBI:InterBase, I finally > got ODBC working. But I have repeated problems with the date format (and > quite possibly the integer format too). The database was created in a UK > locale and Kubuntu is set to a UK locale. > > I have a row which I read once and I get 30/07/2009. I read it again later > and get, say, 32231-08-2\x00. Sometimes the read works and sometimes not. > Sometimes I get a valid date and sometimes I get a strange string, but > always with the format nnnnn-nn-n\x00. > > If I use isql-fb, it works perfectly, but if I use just isql, it fails. So > this leads me to believe it's an ODBC issue Here is an example, if I don't > use any code but just use isql and I run the same query (select > att_examination_dte from tbl_exam) three times, I get record 1 = > 31893-11-15, twice and record 1 = 2009-07-24 (the correct value) the third > time. There are 21 records in this table, here is the whole output (see > below). > > What is causing this? I have tried uninstalling and reinstalling unixodbc, > but it doesn't seem to make any difference. > > Regards > > Steve > > steve@steve-desktop:~$ isql end_db > +---------------------------------------+ > | Connected! | > | | > | sql-statement | > | help [tablename] | > | quit | > | | > +---------------------------------------+ > SQL> select att_examination_dte from tbl_exam > +----------------------------+ > | ATT_EXAMINATION_DTE| > +----------------------------+ > | 31893-11-15 | > | 31893-11-15 | > | 31893-11-15 | > | 31893-11-22 | > | 31893-12-05 | > | 31893-11-24 | > | 31893-11-18 | > | 31893-11-16 | > | 31893-11-23 | > | 31893-11-19 | > | 31893-11-21 | > | 31893-11-17 | > | 31893-12-11 | > | 31893-11-20 | > | 31893-12-11 | > | 31893-12-11 | > | 31893-12-11 | > | 31893-12-12 | > | 31893-12-16 | > | 31893-12-17 | > | 31894-02-05 | > +----------------------------+ > SQLRowCount returns 21 > 21 rows fetched > SQL> select att_examination_dte from tbl_exam > +----------------------------+ > | ATT_EXAMINATION_DTE| > +----------------------------+ > | 31893-11-15 | > | 31893-11-15 | > | 31893-11-15 | > | 31893-11-22 | > | 31893-12-05 | > | 31893-11-24 | > | 31893-11-18 | > | 31893-11-16 | > | 31893-11-23 | > | 31893-11-19 | > | 31893-11-21 | > | 31893-11-17 | > | 31893-12-11 | > | 31893-11-20 | > | 31893-12-11 | > | 31893-12-11 | > | 31893-12-11 | > | 31893-12-12 | > | 31893-12-16 | > | 31893-12-17 | > | 31894-02-05 | > +----------------------------+ > SQLRowCount returns 21 > 21 rows fetched > SQL> select att_examination_dte from tbl_exam > +----------------------------+ > | ATT_EXAMINATION_DTE| > +----------------------------+ > | 2009-07-24 | > | 2009-07-24 | > | 2009-07-24 | > | 2009-07-31 | > | 2009-08-13 | > | 2009-08-02 | > | 2009-07-27 | > | 2009-07-25 | > | 2009-08-01 | > | 2009-07-28 | > | 2009-07-30 | > | 2009-07-26 | > | 2009-08-19 | > | 2009-07-29 | > | 2009-08-19 | > | 2009-08-19 | > | 2009-08-19 | > | 2009-08-20 | > | 2009-08-24 | > | 2009-08-25 | > | 2009-10-14 | > +----------------------------+ > SQLRowCount returns 21 > 21 rows fetched > SQL> > > Regards > > Steve > > > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > |
|
From: Steve C. <ste...@sc...> - 2009-11-15 12:36:11
|
Hi People, I have a Firebird 2.1 database that works perfectly under Windows, but has been problematic under a migration to Kubuntu 9.10 with ODBC driver libOdbcFb.so. After initial problems installing and then using DBI:InterBase, I finally got ODBC working. But I have repeated problems with the date format (and quite possibly the integer format too). The database was created in a UK locale and Kubuntu is set to a UK locale. I have a row which I read once and I get 30/07/2009. I read it again later and get, say, 32231-08-2\x00. Sometimes the read works and sometimes not. Sometimes I get a valid date and sometimes I get a strange string, but always with the format nnnnn-nn-n\x00. If I use isql-fb, it works perfectly, but if I use just isql, it fails. So this leads me to believe it's an ODBC issue Here is an example, if I don't use any code but just use isql and I run the same query (select att_examination_dte from tbl_exam) three times, I get record 1 = 31893-11-15, twice and record 1 = 2009-07-24 (the correct value) the third time. There are 21 records in this table, here is the whole output (see below). What is causing this? I have tried uninstalling and reinstalling unixodbc, but it doesn't seem to make any difference. Regards Steve steve@steve-desktop:~$ isql end_db +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> select att_examination_dte from tbl_exam +----------------------------+ | ATT_EXAMINATION_DTE| +----------------------------+ | 31893-11-15 | | 31893-11-15 | | 31893-11-15 | | 31893-11-22 | | 31893-12-05 | | 31893-11-24 | | 31893-11-18 | | 31893-11-16 | | 31893-11-23 | | 31893-11-19 | | 31893-11-21 | | 31893-11-17 | | 31893-12-11 | | 31893-11-20 | | 31893-12-11 | | 31893-12-11 | | 31893-12-11 | | 31893-12-12 | | 31893-12-16 | | 31893-12-17 | | 31894-02-05 | +----------------------------+ SQLRowCount returns 21 21 rows fetched SQL> select att_examination_dte from tbl_exam +----------------------------+ | ATT_EXAMINATION_DTE| +----------------------------+ | 31893-11-15 | | 31893-11-15 | | 31893-11-15 | | 31893-11-22 | | 31893-12-05 | | 31893-11-24 | | 31893-11-18 | | 31893-11-16 | | 31893-11-23 | | 31893-11-19 | | 31893-11-21 | | 31893-11-17 | | 31893-12-11 | | 31893-11-20 | | 31893-12-11 | | 31893-12-11 | | 31893-12-11 | | 31893-12-12 | | 31893-12-16 | | 31893-12-17 | | 31894-02-05 | +----------------------------+ SQLRowCount returns 21 21 rows fetched SQL> select att_examination_dte from tbl_exam +----------------------------+ | ATT_EXAMINATION_DTE| +----------------------------+ | 2009-07-24 | | 2009-07-24 | | 2009-07-24 | | 2009-07-31 | | 2009-08-13 | | 2009-08-02 | | 2009-07-27 | | 2009-07-25 | | 2009-08-01 | | 2009-07-28 | | 2009-07-30 | | 2009-07-26 | | 2009-08-19 | | 2009-07-29 | | 2009-08-19 | | 2009-08-19 | | 2009-08-19 | | 2009-08-20 | | 2009-08-24 | | 2009-08-25 | | 2009-10-14 | +----------------------------+ SQLRowCount returns 21 21 rows fetched SQL> Regards Steve |
|
From: David V. <da...@da...> - 2009-11-10 04:17:32
|
I'm having some problems with the Firebird ODBC driver on 64-bit Linux. I'm using the 2.0 RC1 driver, connecting to Firebird 2.1 on the same computer. This is a fragment of my code: SQLAllocHandle(SQL_HANDLE_STMT, dbc, &stmt); SQLPrepare(stmt, (SQLCHAR*) "INSERT INTO test (id,foo) VALUES (?,?)", SQL_NTS); SQLINTEGER id = 8000; SQLINTEGER foo = 4400; SQLLEN cbId, cbFoo; SQLBindParameter(stmt, 1, SQL_PARAM_INPUT, SQL_C_SLONG, SQL_INTEGER, 0, 0, &id, sizeof(id), &cbId); SQLBindParameter(stmt, 2, SQL_PARAM_INPUT, SQL_C_SLONG, SQL_INTEGER, 0, 0, &foo, sizeof(foo), &cbFoo); ret = SQLExecute(stmt); SQLExecute is generating this error: sqlstate=23000, native=-625 [ODBC Firebird Driver][Firebird]validation error for column ID, value "*** null ***" Here's the database schema: CREATE TABLE TEST ( id INTEGER, foo INTEGER DEFAULT 0 NOT NULL, CONSTRAINT TEST_PK PRIMARY KEY (ID) ); |
|
From: Thomas S. <ts...@ib...> - 2009-11-07 15:58:21
|
> Is there a hard limit for the length of a query via ODBC driver? There is one for Firebird which is ~64K. Don't know if there is an ODBC specific (e.g. a smaller one) though. -- Best Regards, Thomas Steinmaurer LogManager Series - Logging/Auditing Suites supporting InterBase, Firebird, Advantage Database, MS SQL Server and NexusDB V2 Upscene Productions http://www.upscene.com My blog: http://blog.upscene.com/thomas/ |
|
From: Jorge A. B. <li...@da...> - 2009-11-06 13:29:59
|
Is there a hard limit for the length of a query via ODBC driver? Regards! -- Jorge Andrés Brugger Informática DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia Comodoro Rivadavia, Chubut, Argentina Teléfono (0297) 446-4444 int. 103 Correo electrónico: jbr...@da... Website: www.dasu.com.ar |
|
From: Jorge A. B. <li...@da...> - 2009-11-02 16:03:59
|
Roman Simakov escribió: > I don't think so. What distributives are you using to install Firebird > ODBC and Red Soft ODBC? On sf.net I can see only 1.2 version of Firebird > ODBC. Red Soft ODBC is deployed with Red Database. Right? > On 09/03/2009 Alexander Potapchenko published 2.0.149 build of Firebird ODBC driver at http://www.firebirdsql.org/downloads/snapshot_builds/odbc/, which was the last official build. But Red-Soft has a newer build (inside the 2.1 community package), as 2.0.147 build. AFAIK the source code is sync'd but there isn't a Firebird build containing latest changes. > Or you are building them yourself? > > But It seems that Red Soft build number for ODBC driver is not correct. > Thanks. It will be fixed. > > AFAIK every patch to Firebird or Red Soft ODBC is ported to another > source tree. Hence you can either use ODBC driver from Red Database > 2.1.3 or build your snapshot from Firebird source tree (version 2.0 or > HEAD). > > -- > Roman Simakov > > Jorge Andrés Brugger wrote: > >> Roman, one more quiestion: Redsoft build 147 is more "updated" that >> Firebird ODBC build 149? (in build datetime, it is, but I don't know why >> the build is minor). >> >> Regards >> >> Roman Simakov escribió: >> >>> It must be compatible with Firebird 2.1 too. >>> Also every patch must be ported to Firebird Odbc/Jdbc sources too. >>> >>> >>> -- >>> Roman Simakov >>> >>> Jorge Andrés Brugger wrote: >>> >>> >>>> Red-Soft ODBC driver is built on sep/23, so I suppose is the latest >>>> build available (ie, has all the patches arked as solved in FB tracker). >>>> It´s compatible with Firebird 2.1, or has something special to work with >>>> RedSoft database? >>>> >>>> Thanks! >>>> >>>> >>>> >>> ------------------------------------------------------------------------------ >>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA >>> is the only developer event you need to attend this year. Jumpstart your >>> developing skills, take BlackBerry mobile applications to market and stay >>> ahead of the curve. Join us from November 9 - 12, 2009. Register now! >>> http://p.sf.net/sfu/devconference >>> _______________________________________________ >>> Firebird-odbc-devel mailing list >>> Fir...@li... >>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>> >>> >>> >>> >>> > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > > > -- Jorge Andrés Brugger Informática DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia Comodoro Rivadavia, Chubut, Argentina Teléfono (0297) 446-4444 int. 103 Correo electrónico: jbr...@da... Website: www.dasu.com.ar |
|
From: Roman S. <rom...@gm...> - 2009-11-02 14:09:52
|
I don't think so. What distributives are you using to install Firebird ODBC and Red Soft ODBC? On sf.net I can see only 1.2 version of Firebird ODBC. Red Soft ODBC is deployed with Red Database. Right? Or you are building them yourself? But It seems that Red Soft build number for ODBC driver is not correct. Thanks. It will be fixed. AFAIK every patch to Firebird or Red Soft ODBC is ported to another source tree. Hence you can either use ODBC driver from Red Database 2.1.3 or build your snapshot from Firebird source tree (version 2.0 or HEAD). -- Roman Simakov Jorge Andrés Brugger wrote: > Roman, one more quiestion: Redsoft build 147 is more "updated" that > Firebird ODBC build 149? (in build datetime, it is, but I don't know why > the build is minor). > > Regards > > Roman Simakov escribió: >> It must be compatible with Firebird 2.1 too. >> Also every patch must be ported to Firebird Odbc/Jdbc sources too. >> >> >> -- >> Roman Simakov >> >> Jorge Andrés Brugger wrote: >> >>> Red-Soft ODBC driver is built on sep/23, so I suppose is the latest >>> build available (ie, has all the patches arked as solved in FB tracker). >>> It´s compatible with Firebird 2.1, or has something special to work with >>> RedSoft database? >>> >>> Thanks! >>> >>> >> >> ------------------------------------------------------------------------------ >> Come build with us! The BlackBerry(R) Developer Conference in SF, CA >> is the only developer event you need to attend this year. Jumpstart your >> developing skills, take BlackBerry mobile applications to market and stay >> ahead of the curve. Join us from November 9 - 12, 2009. Register now! >> http://p.sf.net/sfu/devconference >> _______________________________________________ >> Firebird-odbc-devel mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >> >> >> >> > |
|
From: Jorge A. B. <li...@da...> - 2009-11-02 13:14:51
|
Roman, one more quiestion: Redsoft build 147 is more "updated" that Firebird ODBC build 149? (in build datetime, it is, but I don't know why the build is minor). Regards Roman Simakov escribió: > It must be compatible with Firebird 2.1 too. > Also every patch must be ported to Firebird Odbc/Jdbc sources too. > > > -- > Roman Simakov > > Jorge Andrés Brugger wrote: > >> Red-Soft ODBC driver is built on sep/23, so I suppose is the latest >> build available (ie, has all the patches arked as solved in FB tracker). >> It´s compatible with Firebird 2.1, or has something special to work with >> RedSoft database? >> >> Thanks! >> >> > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > > > -- Jorge Andrés Brugger Informática DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia Comodoro Rivadavia, Chubut, Argentina Teléfono (0297) 446-4444 int. 103 Correo electrónico: jbr...@da... Website: www.dasu.com.ar |
|
From: Roman S. <rom...@gm...> - 2009-11-02 13:02:14
|
It must be compatible with Firebird 2.1 too. Also every patch must be ported to Firebird Odbc/Jdbc sources too. -- Roman Simakov Jorge Andrés Brugger wrote: > Red-Soft ODBC driver is built on sep/23, so I suppose is the latest > build available (ie, has all the patches arked as solved in FB tracker). > It´s compatible with Firebird 2.1, or has something special to work with > RedSoft database? > > Thanks! > |
|
From: Jorge A. B. <li...@da...> - 2009-11-02 12:39:47
|
Red-Soft ODBC driver is built on sep/23, so I suppose is the latest build available (ie, has all the patches arked as solved in FB tracker). It´s compatible with Firebird 2.1, or has something special to work with RedSoft database? Thanks! -- Jorge Andrés Brugger Informática DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia Comodoro Rivadavia, Chubut, Argentina Teléfono (0297) 446-4444 int. 103 Correo electrónico: jbr...@da... Website: www.dasu.com.ar |
|
From: Jorge A. B. <li...@da...> - 2009-10-27 11:38:27
|
fbclient.dll is available? ODBC driver needs it .... Regards blueskyabove escribió: > I have installed the Firebird ODBC driver on an XP SP2 pc. > When I try configure the link in the ODBC Data Source Administrator and test > the connection to the database I get the following error message: > > Open database 'C:\Program Files\OpenLM Server\db\OPENLM_DB.GDB' failed > > I browsed to the database to set up the database location on my hard drive > so the database exists. > I have tried it with the database account, password and role all blank and > with values in these fields but always get the error when I try to test > connect. > > Can anyone help please? > > Thanks > > > -- Jorge Andrés Brugger Informática DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia Comodoro Rivadavia, Chubut, Argentina Teléfono (0297) 446-4444 int. 103 Correo electrónico: jbr...@da... Website: www.dasu.com.ar |
71 messages has been excluded from this view by a project administrator.
