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: <car...@te...> - 2002-11-21 19:00:20
|
Hello: I send a patch for the dates on acces, but this continues to have problems: - Dates - Works well ( as i see on my tests ). - Time - Gives conversion error ( as i see on my tests ). - TimeStamp - Gives conversion error ( as i see on my tests ). Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Wieslaw P. <wie...@po...> - 2002-11-21 18:16:41
|
> out some money for a commercial one. I would prefer to use the Open Source > version and contribute as a tester. Once I go to a commercial one, it > doesn't > make much sense for us to test the Open Source driver. I got a commercial driver, I am quite happy with, but I think to test Open Source driver makes sense anyway. > Wiesiek |
|
From: Thomas M. <tm...@bs...> - 2002-11-21 17:56:44
|
The bigger problem is that I am getting to a point where I need this to work or fork out some money for a commercial one. I would prefer to use the Open Source version and contribute as a tester. Once I go to a commercial one, it doesn't make much sense for us to test the Open Source driver. I understand that this is all voluntary, but if there is any way you can fix this problem sooner, I would be very great full. I will also continue to test the driver extensively. Paul Reeves wrote: > Thomas Miller wrote: > >> In Crystal, all the numbers decimal places are out of place >> >> 0.53 shows up as 530000. >> >> With out this fix, there really isn't anything we can do testing >> wise. Unfortunately I don't >> know ODBC or C/C++ and can't give much help on the programming issue. >> >> Tell me if this makes sense. >> > > Yep - this makes sense. > > The reason I haven't put the snapshot out earlier is because I > discovered that the driver seems to mangle the datatypes during the > metadata querying phase. This means that applications that do metadata > lookups (ie the clever ones like Crystal and Access) get one thing and > think it is something else. Or, they just ignore the bad data completely. > > I discovered this because I wanted to get to the bottom of the whole > issue of why the driver doesn't work properly with Access. > > It appears to be a problem in the original release of the driver and > not one that has crept in with recent enhancements. I didn't have the > time to verify this before today, hence the delay. > > I'd like to get this fixed, but I wont have a chance to take a more > serious look at it until next month. > > This only affects applications that rely on metadata querying. With > pure SQL statements they are executed and data is retrieved correctly. > Not much consolation if you are using Crystal or Access. > > > Paul -- Thomas Miller Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com |
|
From: Paul R. <pr...@ib...> - 2002-11-21 17:31:37
|
Thomas Miller wrote: > In Crystal, all the numbers decimal places are out of place > > 0.53 shows up as 530000. > > With out this fix, there really isn't anything we can do testing wise. > Unfortunately I don't > know ODBC or C/C++ and can't give much help on the programming issue. > > Tell me if this makes sense. > Yep - this makes sense. The reason I haven't put the snapshot out earlier is because I discovered that the driver seems to mangle the datatypes during the metadata querying phase. This means that applications that do metadata lookups (ie the clever ones like Crystal and Access) get one thing and think it is something else. Or, they just ignore the bad data completely. I discovered this because I wanted to get to the bottom of the whole issue of why the driver doesn't work properly with Access. It appears to be a problem in the original release of the driver and not one that has crept in with recent enhancements. I didn't have the time to verify this before today, hence the delay. I'd like to get this fixed, but I wont have a chance to take a more serious look at it until next month. This only affects applications that rely on metadata querying. With pure SQL statements they are executed and data is retrieved correctly. Not much consolation if you are using Crystal or Access. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird and InterBase |
|
From: Ignacio J. O. <na...@si...> - 2002-11-21 17:18:30
|
Paul, i'm about to commit the patch commented below, any problems? it's
ok for you?
Saludos,
Ignacio J. Ortega
> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Ignacio J. Ortega
> Sent: Tuesday, November 05, 2002 11:21 PM
> To: 'fir...@li...'
> Subject: [Firebird-odbc-devel] [Patch] SQL_IDENTIFIER_QUOTE_CHAR
> problems when using Dialect 1 databases
>
>
> The attached patch solves a conformance problem for the SQLGetInfo
> element SQL_IDENTIFIER_QUOTE_CHAR when using Dialect 1 databases, the
> Spec says :
>
> 8<-------------------------------------------
> SQL_IDENTIFIER_QUOTE_CHAR (ODBC 1.0)
>
> The character string used as the starting and ending delimiter of a
> quoted (delimited) identifier in SQL statements. (Identifiers
> passed as
> arguments to ODBC functions do not need to be quoted.) If the data
> source does not support quoted identifiers, a blank is returned.
> 8<-------------------------------------------
>
> Now the OdbcJdbc Driver is returning a empty ("") string as value for
> the element for a Dialect 1 database, this is wrong, most Tools failed
> to link tables with this patch will solve most of them ( i ve tested
> with Access97 myself )
>
> Saludos,
> Ignacio J. Ortega
>
|
|
From: Thomas M. <tm...@bs...> - 2002-11-21 17:07:46
|
In Crystal, all the numbers decimal places are out of place 0.53 shows up as 530000. With out this fix, there really isn't anything we can do testing wise. Unfortunately I don't know ODBC or C/C++ and can't give much help on the programming issue. Tell me if this makes sense. The Numeric(18,6) field is being stored internally as a Int64. When it is retrieved from the database, it should put back the decimal place (6 places). It doesn't seem to be doing that (putting back the decimal place). Paul Reeves wrote: > Thomas Miller wrote: > >> Per your request, I am reminding you to get a new build out real soon!!!! >> > > I'm working on it as we speak. It should appear somewhere within the > next 24 hours. I'll announce it here anyway. > >> Did you ever figure out the decimal location issue? 530000 ; 0.53 >> > > I don't think anything has been done. I can't see anything about this > in a quick trawl through recent posts - can you remind me what the > issue was? > > > Paul -- Thomas Miller Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com |
|
From: Paul R. <pr...@ib...> - 2002-11-21 16:12:25
|
Thomas Miller wrote: > Per your request, I am reminding you to get a new build out real soon!!!! > I'm working on it as we speak. It should appear somewhere within the next 24 hours. I'll announce it here anyway. > Did you ever figure out the decimal location issue? 530000 ; 0.53 > I don't think anything has been done. I can't see anything about this in a quick trawl through recent posts - can you remind me what the issue was? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird and InterBase |
|
From: Thomas M. <tm...@bs...> - 2002-11-21 14:57:30
|
Per your request, I am reminding you to get a new build out real soon!!!! Did you ever figure out the decimal location issue? 530000 ; 0.53 Paul Reeves wrote: > Thomas Miller wrote: > >> I'll try one more time. Any update???? >> > > Yep - it is always worth persevering. I had drafted a reply, and then > canned it, thinking it was too lame. And, indeed it is. > > A snapshot will be forthcoming RSN. I rate it as high-priority, but > unfortunately it keeps getting pushed back by things that are urgent > or even higher priority. > > I shall force myself to make some time to throw a build out this week, > along with the usual indemnity disclaimers. If nothing has appeared by > Thursday feel free to harass me. > > > Paul -- Thomas Miller Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com |
|
From:
<car...@te...> - 2002-11-11 09:53:50
|
Hello:
A little patch for SqlExtendedFetch:
1. Add SQL_API_SQLEXTENDEDFETCH to the Supported Functions array.
OdbcConnection.cpp:
static const int supportedFunctions [] = {
// Deprecated but important stuff
SQL_API_SQLALLOCCONNECT,
SQL_API_SQLALLOCENV,
SQL_API_SQLALLOCSTMT,
SQL_API_SQLFREECONNECT,
SQL_API_SQLFREEENV,
SQL_API_SQLFREESTMT,
...
...
SQL_API_SQLEXTENDEDFETCH,
...
...
};
2. New declaration of OdbcStatement::sqlExtendedFetch:
RETCODE OdbcStatement::sqlExtendedFetch(int orientation, int offset,
SQLUINTEGER *rowCountPointer, SQLUSMALLINT *rowStatusArray)
{
if (!resultSet)
return sqlReturn (SQL_ERROR, "24000", "Invalid cursor state");
if (cancel)
{
releaseResultSet();
return sqlReturn (SQL_ERROR, "S1008", "Operation canceled");
}
try
{
if(rowCountPointer)
*rowCountPointer = 1;
if (eof || !resultSet->next())
{
eof = true;
if(rowStatusArray)
rowStatusArray[0] = SQL_ROW_NOROW;
return SQL_NO_DATA;
}
else
{
if(rowStatusArray)
rowStatusArray[0] = SQL_ROW_SUCCESS;
}
}
catch (SQLException& exception)
{
OdbcError *error = postError ("HY000", exception);
error->setRowNumber (rowNumber);
return SQL_ERROR;
}
return returnData();
}
I have this tested with MS Odbc Test application and seems to works well.
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From: Paul R. <pr...@ib...> - 2002-11-10 10:44:00
|
Thomas Miller wrote: > I'll try one more time. Any update???? > Yep - it is always worth persevering. I had drafted a reply, and then canned it, thinking it was too lame. And, indeed it is. A snapshot will be forthcoming RSN. I rate it as high-priority, but unfortunately it keeps getting pushed back by things that are urgent or even higher priority. I shall force myself to make some time to throw a build out this week, along with the usual indemnity disclaimers. If nothing has appeared by Thursday feel free to harass me. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird and InterBase |
|
From: Thomas M. <tm...@bs...> - 2002-11-08 19:18:40
|
I'll try one more time. Any update???? Thomas Miller wrote: > TIA > -- Thomas Miller Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com |
|
From: Dan P. <dan...@ya...> - 2002-11-08 15:55:44
|
|
From: Ignacio J. O. <na...@si...> - 2002-11-05 22:16:38
|
The attached patch solves a conformance problem for the SQLGetInfo
element SQL_IDENTIFIER_QUOTE_CHAR when using Dialect 1 databases, the
Spec says :
8<-------------------------------------------
SQL_IDENTIFIER_QUOTE_CHAR (ODBC 1.0)
The character string used as the starting and ending delimiter of a
quoted (delimited) identifier in SQL statements. (Identifiers passed as
arguments to ODBC functions do not need to be quoted.) If the data
source does not support quoted identifiers, a blank is returned.
8<-------------------------------------------
Now the OdbcJdbc Driver is returning a empty ("") string as value for
the element for a Dialect 1 database, this is wrong, most Tools failed
to link tables with this patch will solve most of them ( i ve tested
with Access97 myself )
Saludos,
Ignacio J. Ortega
|
|
From: Thomas M. <tm...@bs...> - 2002-11-05 19:28:03
|
TIA -- Thomas Miller Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com |
|
From: Paul R. <pr...@ib...> - 2002-11-05 16:55:41
|
Dustin Caldwell wrote: > Hello, > > I need to have my install script install the XTG ODBC driver. The new > installation tool is great, but as a result, I don't know what to copy > where, what registry entries to add/modify, .ini files to change, etc. > > Can anyone help me with how to install it by hand? > XTG? Seriously - this list is for discussion of the development issues surrounding the ODBC driver that is a part of the Firebird project. It doesn't cover general support issues for that driver, let alone other drivers. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird and InterBase |
|
From: Dustin C. <du...@as...> - 2002-11-05 16:40:12
|
This may be off-topic. If so, could you please direct me to a source for this info? I'm trying to create an ODBC Datasource by hand (in code). Anyone know how? TIA, Dustin |
|
From: Dustin C. <du...@as...> - 2002-11-05 16:38:23
|
Hello, I need to have my install script install the XTG ODBC driver. The new installation tool is great, but as a result, I don't know what to copy where, what registry entries to add/modify, .ini files to change, etc. Can anyone help me with how to install it by hand? thanks, Dustin Caldwell DSC Ventures |
|
From: <wie...@po...> - 2002-10-29 17:48:35
|
Hi,
I was not quite right, that Firebird ODBC driver is working with oracle
forms without
problems. When I use in PL/SQL (client side) - SYSDATE function
Oracle Passes to Gemini Driver :
SELECT {fn now()} from dual
and
Select sysdate from dual
to Firebird.
Since there is no sysdate function/column the statement fails.
I think I am able (anybody is) to work it around.
I was so glad that my applications are working wtih Firebird,
so I mistook drivers. Should you find useful to do further testing
o Firebird ODBC
with Oracle forms/reports please let me know.
I really like Firebird (after 12 years of coding using Oracle) so if
you find usefull my contribution in testing ODBC I am eager to do it.
Wiesiek
> > I was wrong, there are problems with accessing
> (And, please, do not post in html)
I did ? Excuse me
>
>
> Paul
> --
>
> Paul Reeves
> http://www.ibphoenix.com
> Supporting users of Firebird and InterBase
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
|
|
From: Paul R. <pr...@ib...> - 2002-10-29 16:43:26
|
Wies=B3aw Poszewiecki wrote: > I was wrong, there are problems with accessing > Firebird using the driver > I mistakenly used Karyakin's (Gemini) ODBC driver :-) > =20 Ok, so what was wrong? (And, please, do not post in html) Paul --=20 Paul Reeves http://www.ibphoenix.com Supporting users of Firebird and InterBase |
|
From: <wie...@po...> - 2002-10-29 13:15:13
|
I was wrong, there are problems with accessing=20 Firebird using the driver I mistakenly used Karyakin's (Gemini) ODBC driver :-) |
|
From: <wie...@po...> - 2002-10-29 13:09:15
|
Hi, I just wanted to let you know that I am testing your driver=20 (snapshot 20020802 with Oracle Forms 6i. It seems to work. I will cotinue to do this because I am going to=20 port my applications to firebird. Wiesiek |
|
From: Bjørge S. <bj...@ha...> - 2002-10-29 00:12:09
|
Hi ! I'm having a hard time getting info on Firebird ODBC / JDBC drivers used with ColdFusion (Win2000 / WinXP). This is maybe nott the appropriate place for this posting, but I can't get any info anywhere... The error "file id (11) out of range" is thrown no matter what SQL I write. Anybody knows what this is ? Thanks ! -- Bjørge Sæther bjorge@hahaha_itte.no |
|
From: Thomas M. <tm...@bs...> - 2002-10-18 14:17:18
|
The way you guys are approaching this gives the work much more "legs". This is the way I would have done it too. I am great with Delphi, but C++ just isn't my cup of tea. Let me know how I can help. For the moment, I think testing is going to be my best area. Paul Reeves wrote: > Thomas Miller wrote: > >> I didn't realize there was another project. Is there a reason you >> guys haven't >> tried to merge the two projects? >> > > The architecture of each is very different. > > The XTG project is a straightforward, non-object oriented > implementation of the ODBC functions over the IB/Fb api. > > The IBPhoenix driver is a layered, object oriented implementation. The > database access layer is implemented using the JDBC interface > specification. The ODBC functions are implemented using a set of OO > classes that map the ODBC function calls onto the 'JDBC' objects. A > lot more ambitious, but ultimately a lot more flexible. > > I doubt that many are aware that a fully functioning, object-oriented > class library exists for Firebird, written in C++. > > It would probably be more pertinent to ask why we don't work with > Olivier Mascia's IBPP project - that too is a fully functioning, > object-oriented class library for Firebird, written in C++. However, > it uses a different interface, so I doubt that there is much that can > be shared. > > > Paul -- Thomas Miller Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com |
|
From: Paul R. <pr...@ib...> - 2002-10-18 14:01:41
|
Thomas Miller wrote: > I didn't realize there was another project. Is there a reason you guys > haven't > tried to merge the two projects? > The architecture of each is very different. The XTG project is a straightforward, non-object oriented implementation of the ODBC functions over the IB/Fb api. The IBPhoenix driver is a layered, object oriented implementation. The database access layer is implemented using the JDBC interface specification. The ODBC functions are implemented using a set of OO classes that map the ODBC function calls onto the 'JDBC' objects. A lot more ambitious, but ultimately a lot more flexible. I doubt that many are aware that a fully functioning, object-oriented class library exists for Firebird, written in C++. It would probably be more pertinent to ask why we don't work with Olivier Mascia's IBPP project - that too is a fully functioning, object-oriented class library for Firebird, written in C++. However, it uses a different interface, so I doubt that there is much that can be shared. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird and InterBase |
|
From: Thomas M. <tm...@bs...> - 2002-10-18 13:22:55
|
I didn't realize there was another project. Is there a reason you guys haven't tried to merge the two projects? Carlos Guzmán Álvarez wrote: > Hello: > >> I'm looking for an ODBC driver for Firebird 1.0 or IB 6.02. >> What's the best free and where can i download it for a test ? > > > There are two ODBC drivers for free ( that i know ), the IBPhoenix > ODBC Driver and the XTG ODBC Driver, you can download the latest > snapshot of the ODBC Driver of IBPhoenix at : > > http://www.ibphoenix.com/downloads/OdbcJdbc-20020802-snapshot.zip > > > > > Best regards > Carlos Guzmán Álvarez > Vigo-Spain > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > -- Thomas Miller Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com |
71 messages has been excluded from this view by a project administrator.
