Menu
▾
▴
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: 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 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: 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: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: 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 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: 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 >> > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X