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: stevyn d. <sr...@ya...> - 2010-08-01 23:59:26
|
Hello:
I am continuing to get these errors using OdbcFb.dll version 2.0.0.148. These are entries in the Windows 2003 R2 event log:
Faulting application dllhost.exe, version 5.2.3790.3959, faulting module OdbcFb.dll, version 2.0.0.148, fault address 0x00022cc4.
The system has called a custom component and that component has failed and generated an exception. This indicates a problem with the custom component. Notify the developer of this component that a failure has occurred and provide them with the information below.
Component Prog ID:
Server Application ID: {6EA2FA28-A7F8-4BA7-97FD-FEC4901A2248}
Server Application Instance ID:
{CDF2EC1D-2890-4019-853E-DF47053C76E9}
Server Application Name: LSMSWAPP
The serious nature of this error has caused the process to terminate.
Exception: C0000005
Address: 0x10022CC4
Call Stack:
OdbcFb!SQLSetStmtAttrW + 0x204
I reported this problem a while back but have not seen anything since to resolve this issue.
This problem is negatively impacting a production system. Should I be posting this problem elsewhere?
Firebird Server Version is WI-V2.1.2.18118 Firebird 2.1
Any help in addressing this issue would be appreciated.
regards,
stevyn r dembo
This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended you are hereby notified
that any dissemination, distribution or copying of this
communication is strictly prohibited. If you are not the intended reader, then you must destroy this communication immediately.
|
|
From: Jorge A. B. <li...@da...> - 2010-07-29 12:07:41
|
http://www.red-soft.biz/files/downloads/odbc/Firebird_ODBC_2.0.0.148_win32.exe http://www.red-soft.biz/files/downloads/odbc/Firebird_ODBC_2.0.0.148_x64.exe http://www.red-soft.biz/files/downloads/odbc/OdbcFb_DLL_RC1_2-0-0148_Win32.zip http://www.red-soft.biz/files/downloads/odbc/OdbcFb_DLL_RC1_2-0-0148_x64.zip http://www.red-soft.biz/files/downloads/odbc/OdbcFb-LIB-RC1-2.0.0148.amd64.tar.gz http://www.red-soft.biz/files/downloads/odbc/OdbcFb-LIB-RC1-2.0.0148.i686.tar.gz http://www.red-soft.biz/files/downloads/odbc/OdbcFb-Source-RC1-2.0.0148.tar.gz Yes, I´ve missed the linux part in previous message ;) El 29/07/2010 06:24 a.m., Nick Upson escribió: > Hi, the most recent odbc install for linux seems to be dated 2004, is > that correct? > > http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_60_odbc > > ------------------------------------------------------------------------------ > The Palm PDK Hot Apps Program offers developers who use the > Plug-In Development Kit to bring their C/C++ apps to Palm for a share > of $1 Million in cash or HP Products. Visit us here for more details: > http://p.sf.net/sfu/dev2dev-palm > _______________________________________________ > 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: Nick U. <nic...@gm...> - 2010-07-29 09:24:15
|
Hi, the most recent odbc install for linux seems to be dated 2004, is that correct? http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_60_odbc |
|
From: Michael M. <m.m...@mb...> - 2010-07-21 13:53:16
|
I think the Problem is here:
FB 1.5 is 32 Bit only – fbclient.dll and gds32.dll are from this installation and also 32 Bit. The ODBC driver depends on them, and the 64 Bit version of the ODBC can’t use them. So no connect with 64 Bit drivers ;-)
Solution 1 (Tested):
Install 32 ODBC driver and use this one (Use the right ODBC Manager on 64 Bit Windows!)
Solution 2 (untested):
Install client only firebird 2.x in 64 Bit. Then you should be able to connect with 64 bit ODBC driver!
Solution 3 (untested):
Solution 1 + Solution 2: fbclient.dll + gds32.dll from FB 1.5 in c:\windows\syswow64, fbclient.dll + gds32.dll from FB 2.x 64 Bit in c:\windows\system32, both ODBC drivers installed – Connection should be possible from 64 bit ODBC Manager and 32 bit ODBC Manager!
Michael
Von: CDMVSS [mailto:ch...@ev...]
Gesendet: Mittwoch, 21. Juli 2010 01:21
An: fir...@li...
Betreff: Re: [Firebird-odbc-devel] Open database failed FB1.5, ODBC, Win2008-64bit
Yes I am able to switch the application pool to use 32 bit stuff then
use the odbc DSN from the 32 bit list.
On 7/20/2010 4:00 PM, Michael Möhle [via Firebird] wrote:
> Maybe use the 32 Bit ODBC Driver?
>
> Michael
>
> -----Ursprüngliche Nachricht-----
> Von: CDMVSS [mailto:[hidden email]
> </user/SendEmail.jtp?type=node&node=2296400&i=0>]
> Gesendet: Dienstag, 20. Juli 2010 00:29
> An: [hidden email] </user/SendEmail.jtp?type=node&node=2296400&i=1>
> Betreff: [Firebird-odbc-devel] Open database failed FB1.5, ODBC,
> Win2008-64bit
>
>
> On a windows 2008 64bit machine, firebird 1.5.6 is installed.
>
> Win 64-bit DLL .zip, 351 Kb OdbcFb_DLL_RC1_2-0-0148_x64.zip
>
> is installed as the ODBC driver.
>
> The file for now is on c:\data.fdb
>
> Security.fdb and data.fdb both have everyone as full access.
>
> fbclient.dll and gds32.dll are in win\sys32 directory.
>
> Everytime you try to do a 'test connection' you get "open database <any
> path> failed'.
>
> a telnet to port 3050 is successful and firebird is running.
>
> It does not matter what path you put in you will just get an open database
> failed.
>
> Any ideas?
> --
> View this message in context:
> http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200 <http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200?by-user=t>
> <http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200?by-user=t <http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200?by-user=t&by-user=t> >
> 8-64bit-tp2294710p2294710.html
> Sent from the firebird-odbc-devel mailing list archive at Nabble.com.
>
> ----------------------------------------------------------------------------
>
> --
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> _______________________________________________
> Firebird-odbc-devel mailing list
> [hidden email] </user/SendEmail.jtp?type=node&node=2296400&i=2>
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
> ------------------------------------------------------------------------------
>
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> _______________________________________________
> Firebird-odbc-devel mailing list
> [hidden email] </user/SendEmail.jtp?type=node&node=2296400&i=3>
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
> ------------------------------------------------------------------------
> View message @
> http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win2008-64bit-tp2294710p2296400.html <http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win2008-64bit-tp2294710p2296400.html?by-user=t>
>
> To unsubscribe from Open database failed FB1.5, ODBC, Win2008-64bit,
> click here
> <<Link Removed>>.
>
>
_____
View this message in context: Re: <http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win2008-64bit-tp2294710p2296414.html> Open database failed FB1.5, ODBC, Win2008-64bit
Sent from the firebird-odbc-devel <http://firebird.1100200.n4.nabble.com/firebird-odbc-devel-f1284633.html> mailing list archive at Nabble.com.
|
|
From: Bart S. <bar...@gm...> - 2010-07-21 13:36:35
|
Have checked now with this customer and the BDE is not even present on that machine, so I don't think the problem lies with that. Have also checked the Firebird version and that looks fine as well: DBMS Name Firebird 1.5 DBMS Version 06.03.4910 WI-V Firebird 1.5 Also checked the version of the file IscDbc.dll and that is fine (same as mine) as well. Bear in mind that there only is a problem with SQL of the type: select first X all else is fine. Any other suggestions and thanks in advance for that? RBS On Mon, Jul 19, 2010 at 3:01 PM, Bart Smissaert <bar...@gm...> wrote: > Will double-check, but I am sure he does use FB 1.5 > Installation is part of clinical patient software and all machines > access the same database > over the network. > > RBS > > On Mon, Jul 19, 2010 at 2:21 PM, Dimitry Sibiryakov <sd...@ib...> wrote: >> 19.07.2010 14:41, Bart Smissaert wrote: >>> Have a customer where there is a problem with the IBPhoenix driver >>> handling a query of the type: >>> >>> select >>> first 1000 >>> >>> Falling over on the number 1000 with token unknown. >> >> Full and exact error text, please. >> >>> Any idea what the problem could be here? >> >> This customer uses NOT Firebird 1.5. >> >> -- >> SY, SD. >> >> ------------------------------------------------------------------------------ >> This SF.net email is sponsored by Sprint >> What will you do first with EVO, the first 4G phone? >> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first >> _______________________________________________ >> Firebird-odbc-devel mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >> > |
|
From: CDMVSS <ch...@ev...> - 2010-07-20 23:21:09
|
Yes I am able to switch the application pool to use 32 bit stuff then use the odbc DSN from the 32 bit list. On 7/20/2010 4:00 PM, Michael Möhle [via Firebird] wrote: > Maybe use the 32 Bit ODBC Driver? > > Michael > > -----Ursprüngliche Nachricht----- > Von: CDMVSS [mailto:[hidden email] > </user/SendEmail.jtp?type=node&node=2296400&i=0>] > Gesendet: Dienstag, 20. Juli 2010 00:29 > An: [hidden email] </user/SendEmail.jtp?type=node&node=2296400&i=1> > Betreff: [Firebird-odbc-devel] Open database failed FB1.5, ODBC, > Win2008-64bit > > > On a windows 2008 64bit machine, firebird 1.5.6 is installed. > > Win 64-bit DLL .zip, 351 Kb OdbcFb_DLL_RC1_2-0-0148_x64.zip > > is installed as the ODBC driver. > > The file for now is on c:\data.fdb > > Security.fdb and data.fdb both have everyone as full access. > > fbclient.dll and gds32.dll are in win\sys32 directory. > > Everytime you try to do a 'test connection' you get "open database <any > path> failed'. > > a telnet to port 3050 is successful and firebird is running. > > It does not matter what path you put in you will just get an open database > failed. > > Any ideas? > -- > View this message in context: > http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200 > <http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200?by-user=t> > 8-64bit-tp2294710p2294710.html > Sent from the firebird-odbc-devel mailing list archive at Nabble.com. > > ---------------------------------------------------------------------------- > > -- > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first > _______________________________________________ > Firebird-odbc-devel mailing list > [hidden email] </user/SendEmail.jtp?type=node&node=2296400&i=2> > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > > ------------------------------------------------------------------------------ > > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first > _______________________________________________ > Firebird-odbc-devel mailing list > [hidden email] </user/SendEmail.jtp?type=node&node=2296400&i=3> > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > > ------------------------------------------------------------------------ > View message @ > http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win2008-64bit-tp2294710p2296400.html > > To unsubscribe from Open database failed FB1.5, ODBC, Win2008-64bit, > click here > < (link removed) =>. > > -- View this message in context: http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win2008-64bit-tp2294710p2296414.html Sent from the firebird-odbc-devel mailing list archive at Nabble.com. |
|
From: Michael M. <m.m...@mb...> - 2010-07-20 23:00:12
|
Maybe use the 32 Bit ODBC Driver? Michael -----Ursprüngliche Nachricht----- Von: CDMVSS [mailto:ch...@ev...] Gesendet: Dienstag, 20. Juli 2010 00:29 An: fir...@li... Betreff: [Firebird-odbc-devel] Open database failed FB1.5, ODBC, Win2008-64bit On a windows 2008 64bit machine, firebird 1.5.6 is installed. Win 64-bit DLL .zip, 351 Kb OdbcFb_DLL_RC1_2-0-0148_x64.zip is installed as the ODBC driver. The file for now is on c:\data.fdb Security.fdb and data.fdb both have everyone as full access. fbclient.dll and gds32.dll are in win\sys32 directory. Everytime you try to do a 'test connection' you get "open database <any path> failed'. a telnet to port 3050 is successful and firebird is running. It does not matter what path you put in you will just get an open database failed. Any ideas? -- View this message in context: http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win200 8-64bit-tp2294710p2294710.html Sent from the firebird-odbc-devel mailing list archive at Nabble.com. ---------------------------------------------------------------------------- -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
|
From: CDMVSS <ch...@ev...> - 2010-07-20 18:51:11
|
Was this issue ever resolved? it is similar to mine (or identical) -- View this message in context: http://firebird.1100200.n4.nabble.com/64-bit-odbc-on-Server-2008-fails-to-connect-tp1285673p2296057.html Sent from the firebird-odbc-devel mailing list archive at Nabble.com. |
|
From: CDMVSS <ch...@ev...> - 2010-07-19 22:46:53
|
On a windows 2008 64bit machine, firebird 1.5.6 is installed. Win 64-bit DLL .zip, 351 Kb OdbcFb_DLL_RC1_2-0-0148_x64.zip is installed as the ODBC driver. The file for now is on c:\data.fdb Security.fdb and data.fdb both have everyone as full access. fbclient.dll and gds32.dll are in win\sys32 directory. Everytime you try to do a 'test connection' you get "open database <any path> failed'. a telnet to port 3050 is successful and firebird is running. It does not matter what path you put in you will just get an open database failed. Any ideas? -- View this message in context: http://firebird.1100200.n4.nabble.com/Open-database-failed-FB1-5-ODBC-Win2008-64bit-tp2294710p2294710.html Sent from the firebird-odbc-devel mailing list archive at Nabble.com. |
|
From: Thomas N. <Tho...@co...> - 2010-07-19 14:06:06
|
Thomas Nelson HIPAA Security Officer and IT Director, Information Systems CoxHealth Tho...@co... Phone: (417) 269-8961 Mobile: (417) 459-3528 Fax: (417) 269-2133 __________ CoxHealth – a Top 100 Integrated Health Care Network COXHEALTH CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information protected by law. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. |
|
From: Bart S. <bar...@gm...> - 2010-07-19 14:01:36
|
Will double-check, but I am sure he does use FB 1.5 Installation is part of clinical patient software and all machines access the same database over the network. RBS On Mon, Jul 19, 2010 at 2:21 PM, Dimitry Sibiryakov <sd...@ib...> wrote: > 19.07.2010 14:41, Bart Smissaert wrote: >> Have a customer where there is a problem with the IBPhoenix driver >> handling a query of the type: >> >> select >> first 1000 >> >> Falling over on the number 1000 with token unknown. > > Full and exact error text, please. > >> Any idea what the problem could be here? > > This customer uses NOT Firebird 1.5. > > -- > SY, SD. > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > |
|
From: Dimitry S. <sd...@ib...> - 2010-07-19 13:41:26
|
19.07.2010 14:41, Bart Smissaert wrote: > Have a customer where there is a problem with the IBPhoenix driver > handling a query of the type: > > select > first 1000 > > Falling over on the number 1000 with token unknown. Full and exact error text, please. > Any idea what the problem could be here? This customer uses NOT Firebird 1.5. -- SY, SD. |
|
From: Bart S. <bar...@gm...> - 2010-07-19 13:39:54
|
Good suggestion will have a look at that and report back. RBS On Mon, Jul 19, 2010 at 2:04 PM, André Knappstein, Controlling <Kna...@be...> wrote: > Could this by any chance be an application where the BDE is used? > I saw this on machines with BDE settings not properly configured. > > > > > > mit freundlichen Grüßen, > > André Knappstein > EDV und Controlling > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH > Hafenweg 4 > 59192 Bergkamen-Rünthe > > Telefon: +49 2389 9240 140 > Telefax: +49 2389 9240 150 > e-mail: in...@be... > > Amtsgericht Hamm Nr. B 420 > Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus > > USt-IDNr.: DE 125215402 > > > ~~~Ihre Nachricht~~~ > > BS> Have a customer where there is a problem with the IBPhoenix driver > BS> handling a query of the type: > > BS> select > BS> first 1000 > > BS> Falling over on the number 1000 with token unknown. > BS> I have tried both the 1.2 driver and the 2.0 driver and both have the > BS> same problem. > BS> On the home system (same setup, 1.2 driver) this query runs fine. > BS> Any idea what the problem could be here? > > BS> RBS > > BS> ------------------------------------------------------------------------------ > BS> This SF.net email is sponsored by Sprint > BS> What will you do first with EVO, the first 4G phone? > BS> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first > BS> _______________________________________________ > BS> Firebird-odbc-devel mailing list > BS> Fir...@li... > BS> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > --- > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > |
|
From: André K. C. <Kna...@be...> - 2010-07-19 13:10:21
|
Could this by any chance be an application where the BDE is used? I saw this on machines with BDE settings not properly configured. mit freundlichen Grüßen, André Knappstein EDV und Controlling ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH Hafenweg 4 59192 Bergkamen-Rünthe Telefon: +49 2389 9240 140 Telefax: +49 2389 9240 150 e-mail: in...@be... Amtsgericht Hamm Nr. B 420 Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus USt-IDNr.: DE 125215402 ~~~Ihre Nachricht~~~ BS> Have a customer where there is a problem with the IBPhoenix driver BS> handling a query of the type: BS> select BS> first 1000 BS> Falling over on the number 1000 with token unknown. BS> I have tried both the 1.2 driver and the 2.0 driver and both have the BS> same problem. BS> On the home system (same setup, 1.2 driver) this query runs fine. BS> Any idea what the problem could be here? BS> RBS BS> ------------------------------------------------------------------------------ BS> This SF.net email is sponsored by Sprint BS> What will you do first with EVO, the first 4G phone? BS> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first BS> _______________________________________________ BS> Firebird-odbc-devel mailing list BS> Fir...@li... BS> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel --- |
|
From: Bart S. <bar...@gm...> - 2010-07-19 13:05:36
|
Sure, they are proper zero's. Thanks for the suggestion though. This is very puzzeling! RBS On Mon, Jul 19, 2010 at 1:59 PM, Mark Ford <mar...@co...> wrote: > Hi Bart, > > Are you sure that one of the zeros isn't a capital 'O' (oh) in the > customer's SQL? Maybe in your tests you copy and pasted from the script > they sent? If one of the zeros was an O then it will fail with a token > unknown error. Just a wild guess though. > > -Mark > > > -----Original Message----- > From: Bart Smissaert [mailto:bar...@gm...] > Sent: Monday, July 19, 2010 8:41 AM > To: fir...@li... > Subject: [Firebird-odbc-devel] Problem Firebird 1.5 IBPhoenix ODBC > > Have a customer where there is a problem with the IBPhoenix driver > handling a query of the type: > > select > first 1000 > > Falling over on the number 1000 with token unknown. > I have tried both the 1.2 driver and the 2.0 driver and both have the > same problem. > On the home system (same setup, 1.2 driver) this query runs fine. > Any idea what the problem could be here? > > RBS > > ---------------------------------------------------------------------------- > -- > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > |
|
From: Mark F. <mar...@co...> - 2010-07-19 12:59:23
|
Hi Bart, Are you sure that one of the zeros isn't a capital 'O' (oh) in the customer's SQL? Maybe in your tests you copy and pasted from the script they sent? If one of the zeros was an O then it will fail with a token unknown error. Just a wild guess though. -Mark -----Original Message----- From: Bart Smissaert [mailto:bar...@gm...] Sent: Monday, July 19, 2010 8:41 AM To: fir...@li... Subject: [Firebird-odbc-devel] Problem Firebird 1.5 IBPhoenix ODBC Have a customer where there is a problem with the IBPhoenix driver handling a query of the type: select first 1000 Falling over on the number 1000 with token unknown. I have tried both the 1.2 driver and the 2.0 driver and both have the same problem. On the home system (same setup, 1.2 driver) this query runs fine. Any idea what the problem could be here? RBS ---------------------------------------------------------------------------- -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
|
From: Bart S. <bar...@gm...> - 2010-07-19 12:41:35
|
Have a customer where there is a problem with the IBPhoenix driver handling a query of the type: select first 1000 Falling over on the number 1000 with token unknown. I have tried both the 1.2 driver and the 2.0 driver and both have the same problem. On the home system (same setup, 1.2 driver) this query runs fine. Any idea what the problem could be here? RBS |
|
From: André K. C. <Kna...@be...> - 2010-06-16 10:42:48
|
** I noticed too late that you sent this not via list but directly via mail. Someone else from the list subscribers could either profit from the thread or contribute to help you, so you should use the list ** CB> Like you, I think that it's not a problem of driver ODBC... But I don't CB> explain why the same report Crystal in version 9 work fine with driver ODBC CB> Firebird v1.2.0.69 and not work fine with driver ODBC Firebird v2.0.0.148 CB> I don't explain too why the report with Crystal in version 11 work fine with CB> driver ODBC Firebird v2.0.0.148 and the same report with Crystal in version CB> 9 not work fine with the same driver... I know from personal experience that 1.2.0.70 (the last 1.2. version) removed some problems with downward compatibility of ODBC 3.x to ODBC 2.x. You should replace 1.2.0.69 by 1.2.0.70. But that is just a shot into the dark, because it would explain your problems with CR 9, but not those with CR 11.... I think... regards, André --- |
|
From: André K. C. <Kna...@be...> - 2010-06-16 09:51:58
|
AvdB> Dear Cyrille, AvdB> please see attached complete thread. I don't know yet if AvdB> solution works since I haven't tried yet myself AvdB> Kind Regards AvdB> Arie van den Bos AvdB> (Logistics Manager) Arie, Cyrille, I am astonished that Cyrille has a similar problem, using about exactly the same wording to describe it. I am working a real lot with Crystal Reports (all versions) and Firebird (several versions) via ODBC and find no problems other than design problems of the database itself (caused by the DB; me *g*). I would be interested to find out which solution works for you and what really was the cause for your problems. If no solution was found so far, and you still don't know the reason for the problems, I will try to assist further. But since I don't believe that it is ODBC driver related, and to spare Helen from doing so, I suggest that you move further questions to the appropriate group. --- |
|
From: Werner F. B. <wer...@fr...> - 2010-05-03 14:04:25
|
I am trying to register the above using: regsrv32.exe c:\windows\system32\odbcfb32.dll But it does not register, I get an error "Config Install (Firebird/Interbase(r) driver c\windows\system32 failed with 6 "composant introuvable dans le registre". Translation of last part: "component not found in the registry" Anyone as a hint on what causes this? Werner |
|
From: ionutz g. <ion...@ya...> - 2010-04-29 11:42:09
|
Are you using EVENTS?
Ionut Gorea
________________________________
From: ionutz gorea <ion...@ya...>
To: fir...@li...
Sent: Thu, 29 April, 2010 2:26:07 PM
Subject: Re: [Firebird-odbc-devel] Ports needed to connect
That's strange because I've just tested (with netstat -a) on a Windows machine and the only port opened to the server is 3050 TCP.
Are you sure you opened in your firewall port 3050 for TCP not UDP
Ionut Gorea
________________________________
From: Ken Buska <kb...@co...>
To: fir...@li...
Sent: Wed, 28 April, 2010 12:33:51 AM
Subject: [Firebird-odbc-devel] Ports needed to connect
I have a customer who wants to connect to our database using the odbc connector on his machine. What ports need to be open besides 3050 in order for the ODBC connector to connect to the Firebird Server? I'm able to connect fine with windows firewall disabled but connection fails with only port 3050 open.
Cheers,
Ken
|
|
From: ionutz g. <ion...@ya...> - 2010-04-29 11:26:14
|
That's strange because I've just tested (with netstat -a) on a Windows machine and the only port opened to the server is 3050 TCP.
Are you sure you opened in your firewall port 3050 for TCP not UDP
Ionut Gorea
________________________________
From: Ken Buska <kb...@co...>
To: fir...@li...
Sent: Wed, 28 April, 2010 12:33:51 AM
Subject: [Firebird-odbc-devel] Ports needed to connect
I have a customer who wants to connect to our database using the odbc connector on his machine. What ports need to be open besides 3050 in order for the ODBC connector to connect to the Firebird Server? I'm able to connect fine with windows firewall disabled but connection fails with only port 3050 open.
Cheers,
Ken
|
|
From: Arie v. d. B. <Ar...@it...> - 2010-04-28 11:50:36
|
Dear André, First of all thanks for your reply. You are absolutely true. Despite I should have maybe extended my request by the fact that I have three primary key columns which depend on each other. Hence in the sum each line is unique. To underline my problem please consider following example table: Database: PrimarKey_1_Name PrimarKey_2_Object PrimarKey_3_Typ Jan1 123/10 A Jan1 A Jan1 124/10 A Excel Outcome: PrimarKey_1_Name PrimarKey_2_Object PrimarKey_3_Typ Jan1 123/10 A Jan1 12!?!?!/§%& A Jan1 124/10 A Kind Regards Arie van den Bos (Logistics Manager) Ph.: +49 2102 99697-18 Fax: +49 2102 99697-10 www.iteco-supply.com _______________________________________________________ ITECO Oilfield Supply GmbH Corresponding Address: An der Pönt 62a, 40885 Ratingen, Germany Place of Administration: Beethovenstr. 2a, 41462 Neuss Bart Duijndam - Venue: Neuss, HRB8794 -----Ursprüngliche Nachricht----- Von: André Knappstein, Controlling [mailto:Kna...@be...] Gesendet: 28, Apr. 2010 13:36 An: Arie van den Bos Betreff: Re: [Firebird-odbc-devel] ODBC / Excel Yes! Of course you can't trust the consistency of databases which have non-unique values in primary key fields. You should fix the cause, not the symptom. ~~~Ihre Nachricht~~~ AvdB> Dear Team, AvdB> I have a client which is requesting to connect excel via ODBC AvdB> to Firebird database. So far no problem. AvdB> I have configured all required DSN and ODBC settings so that AvdB> connections is established and excel is able to read the database. AvdB> The only problem which occurs is that some primary key columns AvdB> have empty cells (not <Null> but simply empty). AvdB> Excel seems to have a problem in interpreting those and AvdB> replaces some empty fields with scrap values made out of "neighbors cells". AvdB> Do you have any idea how to tackle this? AvdB> General Information: AvdB> ODBC Driver: Firebird/Interbase driver Version: 2.00.00.148 AvdB> from IBPhoenix Inc (ODBCFB.dll) as of 18.11.2008 AvdB> Dialect: 1 AvdB> Your support is highly appreciated AvdB> ATB AvdB> Arie --- ------------------------------------------------------------------------------ _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
|
From: André K. C. <Kna...@be...> - 2010-04-28 11:39:21
|
Yes! Of course you can't trust the consistency of databases which have non-unique values in primary key fields. You should fix the cause, not the symptom. ~~~Ihre Nachricht~~~ AvdB> Dear Team, AvdB> I have a client which is requesting to connect excel via ODBC AvdB> to Firebird database. So far no problem. AvdB> I have configured all required DSN and ODBC settings so that AvdB> connections is established and excel is able to read the database. AvdB> The only problem which occurs is that some primary key columns AvdB> have empty cells (not <Null> but simply empty). AvdB> Excel seems to have a problem in interpreting those and AvdB> replaces some empty fields with scrap values made out of "neighbors cells". AvdB> Do you have any idea how to tackle this? AvdB> General Information: AvdB> ODBC Driver: Firebird/Interbase driver Version: 2.00.00.148 AvdB> from IBPhoenix Inc (ODBCFB.dll) as of 18.11.2008 AvdB> Dialect: 1 AvdB> Your support is highly appreciated AvdB> ATB AvdB> Arie --- |
|
From: Arie v. d. B. <Ar...@it...> - 2010-04-28 11:17:18
|
Dear Team, I have a client which is requesting to connect excel via ODBC to Firebird database. So far no problem. I have configured all required DSN and ODBC settings so that connections is established and excel is able to read the database. The only problem which occurs is that some primary key columns have empty cells (not <Null> but simply empty). Excel seems to have a problem in interpreting those and replaces some empty fields with scrap values made out of "neighbors cells". Do you have any idea how to tackle this? General Information: ODBC Driver: Firebird/Interbase driver Version: 2.00.00.148 from IBPhoenix Inc (ODBCFB.dll) as of 18.11.2008 Dialect: 1 Your support is highly appreciated ATB Arie |
71 messages has been excluded from this view by a project administrator.
