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: Hauser, K. <Kar...@ib...> - 2009-01-14 08:06:50
|
Here's the one without join: dg4odbcFORMICA f08-d50 ENTER SQLPrepare HSTMT 01B51960 UCHAR * 0x01E9C698 [ 40] "SELECT "NR" FROM "PERSONAL" WHERE ?="NR"" SDWORD 40 dg4odbcFORMICA f08-d50 EXIT SQLPrepare with return code 0 (SQL_SUCCESS) HSTMT 01B51960 UCHAR * 0x01E9C698 [ 40] "SELECT "NR" FROM "PERSONAL" WHERE ?="NR"" SDWORD 40 dg4odbcFORMICA f08-d50 ENTER SQLNumResultCols HSTMT 01B51960 SWORD * 0x01E11638 dg4odbcFORMICA f08-d50 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS) HSTMT 01B51960 SWORD * 0x01E11638 (1) dg4odbcFORMICA f08-d50 ENTER SQLBindParameter HSTMT 01B51960 UWORD 1 SWORD 1 <SQL_PARAM_INPUT> SWORD 1 <SQL_C_CHAR> SWORD 3 <SQL_DECIMAL> SQLULEN 1 SWORD 0 PTR 0x01EAE5F4 SQLLEN 65 SQLLEN * 0x01E1D5E4 dg4odbcFORMICA f08-d50 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS) HSTMT 01B51960 UWORD 1 SWORD 1 <SQL_PARAM_INPUT> SWORD 1 <SQL_C_CHAR> SWORD 3 <SQL_DECIMAL> SQLULEN 1 SWORD 0 PTR 0x01EAE5F4 SQLLEN 65 SQLLEN * 0x01E1D5E4 (65) dg4odbcFORMICA f08-d50 ENTER SQLExecute HSTMT 01B51960 dg4odbcFORMICA f08-d50 EXIT SQLExecute with return code -1 (SQL_ERROR) HSTMT 01B51960 DIAG [01004] [ODBC Firebird Driver]Data truncated (0) DIAG [HY000] [ODBC Firebird Driver][Firebird]Dynamic SQL Error SQL error code = -303 conversion error from string " " (-303) ---------------------------- And here with trim: dg4odbcFORMICA e44-194 ENTER SQLPrepare HSTMT 01B51960 UCHAR * 0x01E9C6B4 [ 27] "SELECT "NR" FROM "PERSONAL"" SDWORD 27 dg4odbcFORMICA e44-194 EXIT SQLPrepare with return code 0 (SQL_SUCCESS) HSTMT 01B51960 UCHAR * 0x01E9C6B4 [ 27] "SELECT "NR" FROM "PERSONAL"" SDWORD 27 dg4odbcFORMICA e44-194 ENTER SQLNumResultCols HSTMT 01B51960 SWORD * 0x01E11638 dg4odbcFORMICA e44-194 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS) HSTMT 01B51960 SWORD * 0x01E11638 (1) dg4odbcFORMICA e44-194 ENTER SQLExecute HSTMT 01B51960 dg4odbcFORMICA e44-194 EXIT SQLExecute with return code 0 (SQL_SUCCESS) HSTMT 01B51960 So it seems that the problem is related to the binding during execution. -----Ursprüngliche Nachricht----- Von: Alexander Potapchenko [mailto:ale...@re...] Gesendet: Dienstag, 13. Januar 2009 16:54 An: fir...@li... Betreff: Re: [Firebird-odbc-devel] selecting from Oracle 11g to firebird Hauser, Karsten wrote: > I've created the issue. I don't know how to trace the execution of the statement in Firebird. Maybe you can give me an manual for doing this? > > I have only one further statement which works: > SELECT pe.NR, us.USER_LOGIN > FROM IBKPVS_SYS_USER us > LEFT JOIN PERSONAL@formica pe ON us.USER_PERS_ID_FK = pe.NR > where TRIM(us.USER_LOGIN) = 'ADMIN' > > But inserting a trim should not be the solution.. > > No, I have said about ODBC trace file. I want to look at the first query (without TRIM in the SQLPrepare) and the second query with TRIM at ODBC level. Regards, Alexander -- Alexander Potapchenko Senior developer ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel ------------------------------------------------------------------------------------------------------------ IBYKUS AG für Informationstechnologie, Erfurt / HRB 108616 - D-Jena / Vorstand: Helmut C. Henkel, Dr. Lutz Richter / Vorsitzender des Aufsichtsrates: Dr. Frieder Schäuble |
|
From: Alexander P. <ale...@re...> - 2009-01-13 15:54:24
|
Hauser, Karsten wrote: > I've created the issue. I don't know how to trace the execution of the statement in Firebird. Maybe you can give me an manual for doing this? > > I have only one further statement which works: > SELECT pe.NR, us.USER_LOGIN > FROM IBKPVS_SYS_USER us > LEFT JOIN PERSONAL@formica pe ON us.USER_PERS_ID_FK = pe.NR > where TRIM(us.USER_LOGIN) = 'ADMIN' > > But inserting a trim should not be the solution.. > > No, I have said about ODBC trace file. I want to look at the first query (without TRIM in the SQLPrepare) and the second query with TRIM at ODBC level. Regards, Alexander -- Alexander Potapchenko Senior developer |
|
From: Hauser, K. <Kar...@ib...> - 2009-01-13 15:34:04
|
I've created the issue. I don't know how to trace the execution of the statement in Firebird. Maybe you can give me an manual for doing this? I have only one further statement which works: SELECT pe.NR, us.USER_LOGIN FROM IBKPVS_SYS_USER us LEFT JOIN PERSONAL@formica pe ON us.USER_PERS_ID_FK = pe.NR where TRIM(us.USER_LOGIN) = 'ADMIN' But inserting a trim should not be the solution.. -----Ursprüngliche Nachricht----- Von: Alexander Potapchenko [mailto:ale...@re...] Gesendet: Dienstag, 13. Januar 2009 15:53 An: fir...@li... Betreff: Re: [Firebird-odbc-devel] selecting from Oracle 11g to firebird Hauser, Karsten wrote: > > Hi, > > I have the following Problem with the combination of Firebird 1.5.x or > 2.1, Oracle 11g and Firebird ODBC 2.00.00.148 on a winXP system: > > the command: > SELECT pe.NR, us.USER_LOGIN > FROM IBKPVS_SYS_USER us > LEFT JOIN PERSONAL@formica pe ON us.USER_PERS_ID_FK = pe.NR > where us.USER_LOGIN = 'ADMIN' > > ends up in this error msg: > > ORA-28500: Verbindung von ORACLE zu Fremdsystem gab diese Nachricht > zurück: > [ODBC Firebird Driver]Data truncated[ODBC Firebird > Driver][Firebird]Dynamic SQL Error > SQL error code = -303 > conversion error from string " " > ORA-02063: vorherige 4 lines von FORMICA > > Other, simple statement are working like: > > SELECT pe.NR FROM PERSONAL@formica pe where pe.VORNAME = 'Nicole' > > The Problem appears when joining one table of Firebird with one of > Oracle and restricting the result set. I've created a thread in the > oracle forum > (http://forums.oracle.com/forums/thread.jspa?threadID=845777). Here > you can find the trace-information of oracle and windows. > > How can I solve this problem? Is there a tracing capability in > Firebird? I've tried to log the failure with Dr. Watson and the > debug-Version of Firebird as written in an Post on formicasql.org, but > I didn't get it working. > > Hi, This is like a bug in the Firebird ODBC driver, but I am not sure completely. Please add it into the bug tracker here: http://tracker.firebirdsql.org/browse/ODBC Next we are resuming an analysis of this problem there soon. Now I need only a part of a trace file where is an query (SQLPrepare) which are generating the error in the SQLExecute after that. Regards, Alexander -- Alexander Potapchenko Senior developer ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel ------------------------------------------------------------------------------------------------------------ IBYKUS AG für Informationstechnologie, Erfurt / HRB 108616 - D-Jena / Vorstand: Helmut C. Henkel, Dr. Lutz Richter / Vorsitzender des Aufsichtsrates: Dr. Frieder Schäuble |
|
From: Hauser, K. <Kar...@ib...> - 2009-01-13 15:18:35
|
Both fields are numeric.. Your statement delivers the result set (1->Number, ADMIN->String) and is the base for following statement 'SELECT "NR" FROM "PERSONAL" WHERE ?="NR"' send to firebird while during excecution the sign '?' should be replace by the number 1 (from result set). There somewhere is the failure.
-----Ursprüngliche Nachricht-----
Von: Frank Schlottmann-Gödde [mailto:fs...@us...]
Gesendet: Dienstag, 13. Januar 2009 16:00
An: fir...@li...
Betreff: Re: [Firebird-odbc-devel] selecting from Oracle 11g to firebird
Hauser, Karsten wrote:
>
>
> Hi,
>
>
>
> I have the following Problem with the combination of Firebird 1.5.x or
> 2.1, Oracle 11g and Firebird ODBC 2.00.00.148 on a winXP system:
>
>
>
> the command:
> SELECT pe.NR, us.USER_LOGIN
> FROM IBKPVS_SYS_USER us
> LEFT JOIN PERSONAL@formica pe ON us.USER_PERS_ID_FK = pe.NR
> where us.USER_LOGIN = 'ADMIN'
> ends up in this error msg:
> conversion error from string " "
Seems that either IBKPVS_SYS_USER.USER_PERS_ID_FK is declared as numeric
type and PER...@fo... is declared as char typ and contains ' '
(or null ?) or vice versa.
What does
Select SELECT us.USER_PERS_ID_FK,us.USER_LOGIN
FROM IBKPVS_SYS_USER us
where us.USER_LOGIN = 'ADMIN'
return?
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
- J.K. Rowling
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
------------------------------------------------------------------------------------------------------------
IBYKUS AG für Informationstechnologie, Erfurt / HRB 108616 - D-Jena / Vorstand: Helmut C. Henkel, Dr. Lutz Richter /
Vorsitzender des Aufsichtsrates: Dr. Frieder Schäuble
|
|
From: Frank Schlottmann-G. <fs...@us...> - 2009-01-13 15:05:12
|
Hauser, Karsten wrote:
>
>
> Hi,
>
>
>
> I have the following Problem with the combination of Firebird 1.5.x or
> 2.1, Oracle 11g and Firebird ODBC 2.00.00.148 on a winXP system:
>
>
>
> the command:
> SELECT pe.NR, us.USER_LOGIN
> FROM IBKPVS_SYS_USER us
> LEFT JOIN PERSONAL@formica pe ON us.USER_PERS_ID_FK = pe.NR
> where us.USER_LOGIN = 'ADMIN'
> ends up in this error msg:
> conversion error from string " "
Seems that either IBKPVS_SYS_USER.USER_PERS_ID_FK is declared as numeric
type and PER...@fo... is declared as char typ and contains ' '
(or null ?) or vice versa.
What does
Select SELECT us.USER_PERS_ID_FK,us.USER_LOGIN
FROM IBKPVS_SYS_USER us
where us.USER_LOGIN = 'ADMIN'
return?
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
- J.K. Rowling
|
|
From: Alexander P. <ale...@re...> - 2009-01-13 14:53:17
|
Hauser, Karsten wrote: > > Hi, > > I have the following Problem with the combination of Firebird 1.5.x or > 2.1, Oracle 11g and Firebird ODBC 2.00.00.148 on a winXP system: > > the command: > SELECT pe.NR, us.USER_LOGIN > FROM IBKPVS_SYS_USER us > LEFT JOIN PERSONAL@formica pe ON us.USER_PERS_ID_FK = pe.NR > where us.USER_LOGIN = 'ADMIN' > > ends up in this error msg: > > ORA-28500: Verbindung von ORACLE zu Fremdsystem gab diese Nachricht > zurück: > [ODBC Firebird Driver]Data truncated[ODBC Firebird > Driver][Firebird]Dynamic SQL Error > SQL error code = -303 > conversion error from string " " > ORA-02063: vorherige 4 lines von FORMICA > > Other, simple statement are working like: > > SELECT pe.NR FROM PERSONAL@formica pe where pe.VORNAME = 'Nicole' > > The Problem appears when joining one table of Firebird with one of > Oracle and restricting the result set. I’ve created a thread in the > oracle forum > (http://forums.oracle.com/forums/thread.jspa?threadID=845777). Here > you can find the trace-information of oracle and windows. > > How can I solve this problem? Is there a tracing capability in > Firebird? I’ve tried to log the failure with Dr. Watson and the > debug-Version of Firebird as written in an Post on formicasql.org, but > I didn’t get it working. > > Hi, This is like a bug in the Firebird ODBC driver, but I am not sure completely. Please add it into the bug tracker here: http://tracker.firebirdsql.org/browse/ODBC Next we are resuming an analysis of this problem there soon. Now I need only a part of a trace file where is an query (SQLPrepare) which are generating the error in the SQLExecute after that. Regards, Alexander -- Alexander Potapchenko Senior developer |
|
From: Hauser, K. <Kar...@ib...> - 2009-01-13 13:49:32
|
Hi, I have the following Problem with the combination of Firebird 1.5.x or 2.1, Oracle 11g and Firebird ODBC 2.00.00.148 on a winXP system: the command: SELECT pe.NR, us.USER_LOGIN FROM IBKPVS_SYS_USER us LEFT JOIN PERSONAL@formica pe ON us.USER_PERS_ID_FK = pe.NR where us.USER_LOGIN = 'ADMIN' ends up in this error msg: ORA-28500: Verbindung von ORACLE zu Fremdsystem gab diese Nachricht zurück: [ODBC Firebird Driver]Data truncated[ODBC Firebird Driver][Firebird]Dynamic SQL Error SQL error code = -303 conversion error from string " " ORA-02063: vorherige 4 lines von FORMICA Other, simple statement are working like: SELECT pe.NR FROM PERSONAL@formica pe where pe.VORNAME = 'Nicole' The Problem appears when joining one table of Firebird with one of Oracle and restricting the result set. I've created a thread in the oracle forum (http://forums.oracle.com/forums/thread.jspa?threadID=845777). Here you can find the trace-information of oracle and windows. How can I solve this problem? Is there a tracing capability in Firebird? I've tried to log the failure with Dr. Watson and the debug-Version of Firebird as written in an Post on formicasql.org, but I didn't get it working. Thank you for helping Karsten IBYKUS AG für Informationstechnologie Herman-Hollerith-Str. 1 99099 Erfurt Fon +49 (361) 4410-310 Fax +49 (361) 4410-410 E-Mail mailto:kar...@ib... <blocked::mailto:kar...@ib...> Internet http://www.ibykus.com <blocked::http://www.ibykus.com/> ------------------------------------------------------------------------------------------------------------ IBYKUS AG für Informationstechnologie, Erfurt / HRB 108616 - D-Jena / Vorstand: Helmut C. Henkel, Dr. Lutz Richter / Vorsitzender des Aufsichtsrates: Dr. Frieder Schäuble |
|
From: <ola...@sa...> - 2008-12-21 20:17:09
|
Hello, I've a problem. In Firebird 1.5 the follow sql-statement works fine: SELECT TPROJEKTE.KOMMISIONSNR FROM TPROJEKTE WHERE (((TPROJEKTE.KUNDE)=[forms]![FAuftragNeu].[skunde])) GROUP BY TPROJEKTE.KOMMISIONSNR ORDER BY TPROJEKTE.KOMMISIONSNR DESC; Without the order by statement the data sorted by tprojekte.kommisionsnr ascending. But I need the data sorted descending. ...order by 1 does not work too. The Database-Server is now Firebird 2.1. The front-end is microsoft access over odbc (firebird-odbc-driver) Can I change the sql-statement that it works again? thank you very much. Regards Olaf |
|
From: Heine F. <hei...@gm...> - 2008-12-21 19:49:27
|
Hi May I suggest that you develop dynamic and keyset cursors for the Firebird ODBC drivers? These cursors are very important for VB and Access. Currently the driver only supports static cursors. Thanks Heine Ferreira |
|
From: eg <eg...@gm...> - 2008-12-12 17:46:23
|
On Thu, Dec 11, 2008 at 9:34 PM, Alexander Potapchenko <ale...@re...> wrote: > eg wrote: >> Specifically, I added the following include subdirectories to the >> solution: >> >> src\include >> src\include\gen >> src\jrd >> > You need use Firebird headers files after Sed processing. Generally Firebird > sources is not required for ODBC driver build. > Ready header files for using are located in the Firebird\include\ directory > of the installed (or built) server. > Doh... I didn't even think to look at the server install for the includes, I looked directly at the server sources. That certainly makes it easier. Thanks Alexander. Regards, Ed p.s.: I am replying back on - list... sorry for the direct cc |
|
From: eg <eg...@gm...> - 2008-12-11 20:43:57
|
Alexander Potapchenko wrote: > eg wrote: >> > I agree that it can be necessary and I will include *.lib and *.pdb > files into ODBC Firebird driver RC2. That would be much appreciated. >> > You can use any Firebird header files from official releases. Header > files from Firebird 2.1 and VS 2005 are used for ODBC Firebird driver V2 > build. > The structure of the header file relationships and the build set up seems to have changed between FB 2.0 and FB 2.1.1 I just downloaded Fb 2.1.1. sources, and the odbc sources. I then opened the OdbcFB.sln with VS 2005. I noticed an added include directory named c:\firebird\include in the solution. The build.bat file has commnents that you copy over the necessary firebird include files such as ibase.h and iberror.h to there and build. I ended up with ib_util.h, perf.h, types_pub.h and then noticed that ibase.h is now referring to "../jrd/dsc_pub.h" so of course this doesn't quite work. I am thinking that the solution file OdbcJdbc\Builds\MsVc80.win\OdbcFb.sln doesnt quite work out of the box. Is there a recommended setup for this to build odbcfb properly with vs2005 (or 2003 or 2008) and the firebird 2.1.1 source files? What I did was arrange my source tree as follows: Fb | -- Firebird-2.1.1.17910-0 | -- OdbcJdbc | -- include The include directory is where I placed the copies of the various firebird include files (and I tweaked the solution file to point to it) To finally get it to work, what I ended up doing instead was to change the solution so that it adds additional includes for the various include and source subdirectories under \Firebird-2.1.1.17910-0. The challenge is that the firebird include files seem to be in multiple different subdirectories under \Firebird-2.1.1.17910-0.. which I had to hunt down. Specifically, I added the following include subdirectories to the solution: src\include src\include\gen src\jrd That seems to build (albeit with 182 warnings.. most of which seem to be the annoying sprintf / strcpy variety). If there is another way, please let me know. If not, perhaps this message will help others build ODBC from the sources on windows from the solution file. |
|
From: Alexander P. <ale...@re...> - 2008-12-10 16:01:56
|
eg wrote: > I would like to test this with our embedded application. > There does not seem to be a .lib file provided with the dll package. Is > it possible to get one? > I agree that it can be necessary and I will include *.lib and *.pdb files into ODBC Firebird driver RC2. > I tried to make one (for VS2008) from the DLL using the procedure found > in: http://support.microsoft.com/?id=131313 ... but I get connection > errors at run time. Those errors are not there if I link my app with an > older library and just drop the new DLL in place (so I am pretty sure > the procedure didn't work). > > I know I can build it from sources... but then I also need to find the > correct versions of firebird header files (ibase.h, iberror.h, etc). > What version of these header files were used and should be used to build > the odbcfb.dll? > You can use any Firebird header files from official releases. Header files from Firebird 2.1 and VS 2005 are used for ODBC Firebird driver V2 build. Regards, Alexander -- Alexander Potapchenko http://www.red-soft.biz Senior developer |
|
From: Alexander P. <ale...@re...> - 2008-12-10 15:49:38
|
Gabriel Centenari wrote: > 2) How can I disable autocommit ? > I know only one way - to call ODBC API function: SQLSetConnectAttr (connection, SQL_ATTR_AUTOCOMMIT, (SQLPOINTER) SQL_AUTOCOMMIT_OFF, 0); I didn't work with Clarion therefore I don't know its capabilities for a work with ODBC drivers. Regards, Alexander -- Alexander Potapchenko http://www.red-soft.biz Senior developer |
|
From: Alexander P. <ale...@re...> - 2008-12-08 12:21:34
|
Olaf Kluge wrote: > Hello, > > Please, can you help me, how can I realise it? The code is an example and is > understood to work. > > How is the architecture of the vba-code? > Something similar to it: Dim rs As ADODB.Recordset ... Set rs = cmd.Execute() Debug.Print rs(0) rs.Close() // http://msdn.microsoft.com/en-us/library/ms807027.aspx Alexander -- Alexander Potapchenko http://www.red-soft.biz Senior developer |
|
From: Olaf K. <ola...@sa...> - 2008-12-08 11:13:51
|
Hello,
Please, can you help me, how can I realise it? The code is an example and is
understood to work.
How is the architecture of the vba-code?
Thank you.
Olaf
Olaf Kluge wrote:
> Hello,
>
Hi,
> I have a problem with the firebird odbc driver. I use a connection with
> adodb in microsoft access: (vba) This one is only a test with
> test-parameters!
>
> When I use only a input-parameter, the procedure-call works fine. But the
> return-parameter doesn't work, the procedure does not startet.
>
ADO generates the following statement for ODBC driver in your case - {
call TTT(?,?) }.
Next Firebird ODBC driver generates statement - select * from TTT(?).
Therefore you can not use output parameters but you can use query result
set.
> If I switch the input/output-parameter (output first), I get an error
> message: Laufzeitfehler... [ODBC Firebird Driver]not yet implemented
>
It is by design.
Regards,
Alexander
--
Alexander Potapchenko
http://www.red-soft.biz
Senior developer
----------------------------------------------------------------------------
--
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Internal Virus Database is out of date.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.9.13/1828 - Release Date: 04.12.2008
08:05
|
|
From: Alexander P. <ale...@re...> - 2008-12-08 11:06:39
|
Olaf Kluge wrote:
> Hello,
>
Hi,
> I have a problem with the firebird odbc driver. I use a connection with
> adodb in microsoft access: (vba) This one is only a test with
> test-parameters!
>
> When I use only a input-parameter, the procedure-call works fine. But the
> return-parameter doesn't work, the procedure does not startet.
>
ADO generates the following statement for ODBC driver in your case - {
call TTT(?,?) }.
Next Firebird ODBC driver generates statement - select * from TTT(?).
Therefore you can not use output parameters but you can use query result
set.
> If I switch the input/output-parameter (output first), I get an error
> message: Laufzeitfehler... [ODBC Firebird Driver]not yet implemented
>
It is by design.
Regards,
Alexander
--
Alexander Potapchenko
http://www.red-soft.biz
Senior developer
|
|
From: Olaf K. <ola...@sa...> - 2008-12-08 09:39:30
|
Hello,
I have a problem with the firebird odbc driver. I use a connection with
adodb in microsoft access: (vba) This one is only a test with
test-parameters!
Private Sub Befehl1_Click()
Dim Cmd As New ADODB.Command
Dim cn As ADODB.Connection
Dim sConn As String
Dim param As ADODB.Parameter
Dim paramr As ADODB.Parameter
Dim i As Integer
Set cn = New ADODB.Connection
'cn.CursorLocation = adUseServer
'cn.CursorLocation = adUseClient
sConn = "DRIVER=Firebird/InterBase(r)
driver;UID=SYSDBA;PWD=masterkey;DBNAME=D:\Interbase\TEST.FDB"
Set cn = New ADODB.Connection
cn.Open sConn
cn.CursorLocation = adUseServer
Set Cmd.ActiveConnection = cn
Cmd.CommandType = adCmdStoredProc
Cmd.CommandText = "TTT"
Set param = Cmd.CreateParameter("INPUTPARAM", adVarChar, adParamInput, 2)
Cmd.Parameters.Append param param.Value = "jo"
Set paramr = Cmd.CreateParameter("OUTPUTPARAM", adVarChar,
adParamReturnValue, 2) Cmd.Parameters.Append paramr
Cmd.Execute
MsgBox Cmd.Parameters(0).Value & " " & Cmd.Parameters(1).Value Set param =
Nothing Set paramr = Nothing Set Cmd = Nothing cn.Close End Sub
When I use only a input-parameter, the procedure-call works fine. But the
return-parameter doesn't work, the procedure does not startet.
If I switch the input/output-parameter (output first), I get an error
message: Laufzeitfehler... [ODBC Firebird Driver]not yet implemented
Do you have any ideas?
Thank you so much.
the firebird procedure:
CREATE PROCEDURE TTT (
inputparam varchar(2))
returns (
outputparam varchar(2))
as
begin
OUTPUTPARAM = '65';
suspend;
end
|
|
From: Gabriel C. <gab...@xs...> - 2008-12-06 20:35:06
|
Hi 1) I was using Firebird_ODBC_1.2.0.69-Win32. Now I update to Firebird_ODBC_2.0.0.148_win32 and I don't recieve an error when I send "SET TRANSACTION" 2) How can I disable autocommit ? Thanks Again Gabriel Helen Borrie escribió: > At 12:22 AM 6/12/2008, Alexander Potapchenko wrote: > >>> On Fri, 05 Dec 2008, Helen Borrie wrote: >>> >>>> No Alexander, I sent Gabriel here because this is an ODBC-specific >>>> question... > > Well, ok. I have thought, that it is not a question for odbc-*devel.* > > There is only one ODBC list - this one. The name is "historical". ;-) > > Helen > > > ------------------------------------------------------------------------------ > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > |
|
From: Gabriel C. <gab...@xs...> - 2008-12-06 19:56:49
|
Hi 1) I was using Firebird_ODBC_1.2.0.69-Win32. Now I update to Firebird_ODBC_2.0.0.148_win32 and I don't recieve an error when I send "SET TRANSACTION" 2) How can I disable autocommit ? Thanks Again Gabriel Helen Borrie escribió: > At 12:22 AM 6/12/2008, Alexander Potapchenko wrote: > >>> On Fri, 05 Dec 2008, Helen Borrie wrote: >>> >>>> No Alexander, I sent Gabriel here because this is an ODBC-specific >>>> question... > > Well, ok. I have thought, that it is not a question for odbc-*devel.* > > There is only one ODBC list - this one. The name is "historical". ;-) > > Helen > > > ------------------------------------------------------------------------------ > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > |
|
From: Alexander P. <ale...@re...> - 2008-12-06 09:06:05
|
Jaison Gmail wrote: > Hi, > While working with the driver, it seems that when passing a date time > parameter, it truncates the time part and only the date part is stored > in the DB. > I am using Delphi 6, ADO. Do you have any solutions, or is it my > mistake? or Should I have to change some setting? > > This error seems to occur in the latest version of ODBC driver. > > Hi, It is a known problem. ADO transfers ftDateTime parameter into SQLBindParameter (ODBC driver level) as SQL_C_TYPE_DATE (not SQL_C_TYPE_TIMESTAMP). I can recommend to use String parameters for operations with DateTime values in ADO... Please see this too: http://tracker.firebirdsql.org/browse/ODBC-27. Regards, Alexander -- Alexander Potapchenko http://www.red-soft.biz Senior developer |
|
From: Jaison G. <jai...@gm...> - 2008-12-06 05:23:19
|
Hi, While working with the driver, it seems that when passing a date time parameter, it truncates the time part and only the date part is stored in the DB. I am using Delphi 6, ADO. Do you have any solutions, or is it my mistake? or Should I have to change some setting? This error seems to occur in the latest version of ODBC driver. Thanks in advance, Jaison |
|
From: Helen B. <he...@ii...> - 2008-12-05 20:15:34
|
At 12:22 AM 6/12/2008, Alexander Potapchenko wrote: >> On Fri, 05 Dec 2008, Helen Borrie wrote: >> >>> No Alexander, I sent Gabriel here because this is an ODBC-specific >>> question... Well, ok. I have thought, that it is not a question for odbc-*devel.* There is only one ODBC list - this one. The name is "historical". ;-) Helen |
|
From: Alexander P. <ale...@re...> - 2008-12-05 13:22:24
|
bill lam wrote: > On Fri, 05 Dec 2008, Helen Borrie wrote: > >> No Alexander, I sent Gabriel here because this is an ODBC-specific >> question: someone needs to tell him how the ODBC driver implements >> SET TRANSACTION (gets handle, initialises handle) so that he can use >> it in his program. The docs refer to "declaring" a transaction >> (which is not in SQL) but they don't say what you have to do. >> Well, ok. I have thought, that it is not a question for odbc-*devel.* > In ODBC, new connection handle allocated is started in autocommit > mode. To start a transaction it needs to call odbc api to change > attributes for that handle to autocommit off. Both commit and rollback > are implemented with another api sqlendtran. The connection handle > will not be set to 'autocommit on' with this sqlendtran. > > Odbc documentation recommends its own api for transaction rather than > using database specific sql statement such as 'SET TRANSACTION'. > > OP said he used clarion which is another layer between his program and > odbc. The issue may also come from clarion and I'm not sure why using > sql statement for transaction under odbc should work for firebird or > other databases. > > The transactions start automatically in autocommit mode in Firebird ODBC driver. (BEGIN TRANSANCTION is not required) You can manage transactions through SQL using COMMIT and ROLLBACK statements. Regards, Alexander -- Alexander Potapchenko http://www.red-soft.biz Senior developer |
|
From: b2j <b2...@gm...> - 2008-12-05 03:20:22
|
On Fri, 05 Dec 2008, Helen Borrie wrote: > No Alexander, I sent Gabriel here because this is an ODBC-specific > question: someone needs to tell him how the ODBC driver implements > SET TRANSACTION (gets handle, initialises handle) so that he can use > it in his program. The docs refer to "declaring" a transaction > (which is not in SQL) but they don't say what you have to do. In ODBC, new connection handle allocated is started in autocommit mode. To start a transaction it needs to call odbc api to change attributes for that handle to autocommit off. Both commit and rollback are implemented with another api sqlendtran. The connection handle will not be set to 'autocommit on' with this sqlendtran. Odbc documentation recommends its own api for transaction rather than using database specific sql statement such as 'SET TRANSACTION'. OP said he used clarion which is another layer between his program and odbc. The issue may also come from clarion and I'm not sure why using sql statement for transaction under odbc should work for firebird or other databases. -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 唐詩120 王維 過香積寺 不知香積寺 數里入雲峰 古木無人徑 深山何處鐘 泉聲咽危石 日色冷青松 薄暮空潭曲 安禪制毒龍 |
|
From: bill l. <cbi...@gm...> - 2008-12-05 03:00:34
|
On Fri, 05 Dec 2008, Helen Borrie wrote: > No Alexander, I sent Gabriel here because this is an ODBC-specific > question: someone needs to tell him how the ODBC driver implements > SET TRANSACTION (gets handle, initialises handle) so that he can use > it in his program. The docs refer to "declaring" a transaction > (which is not in SQL) but they don't say what you have to do. In ODBC, new connection handle allocated is started in autocommit mode. To start a transaction it needs to call odbc api to change attributes for that handle to autocommit off. Both commit and rollback are implemented with another api sqlendtran. The connection handle will not be set to 'autocommit on' with this sqlendtran. Odbc documentation recommends its own api for transaction rather than using database specific sql statement such as 'SET TRANSACTION'. OP said he used clarion which is another layer between his program and odbc. The issue may also come from clarion and I'm not sure why using sql statement for transaction under odbc should work for firebird or other databases. -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 唐詩228 王維 雜詩 君自故鄉來 應知故鄉事 來日綺窗前 寒梅著花未 |
71 messages has been excluded from this view by a project administrator.
