[Firebird-odbc-devel] Problem Firebird 1.5 IBPhoenix ODBC

Discussion:

Bart Smissaert

2010-07-19 12:41:28 UTC

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

Mark Ford

2010-07-19 12:59:24 UTC

Permalink

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:***@gmail.com]
Sent: Monday, July 19, 2010 8:41 AM
To: firebird-odbc-***@lists.sourceforge.net
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

Bart Smissaert

2010-07-19 13:05:29 UTC

Permalink

Sure, they are proper zero's.
Thanks for the suggestion though.
This is very puzzeling!

RBS

Post by Mark Ford
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-----
Sent: Monday, July 19, 2010 8:41 AM
Subject: [Firebird-odbc-devel] Problem Firebird 1.5 IBPhoenix ODBC
Have a customer where there is a problem with the IBPhoenix driver
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
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
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

André Knappstein, Controlling

2010-07-19 13:04:25 UTC

Permalink

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: ***@beta-eigenheim.de

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> Firebird-odbc-***@lists.sourceforge.net
BS> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

---

Bart Smissaert

2010-07-19 13:39:39 UTC

Permalink

Good suggestion will have a look at that and report back.

RBS

On Mon, Jul 19, 2010 at 2:04 PM, André Knappstein, Controlling

Post by AndrÃ© Knappstein, Controlling
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
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> 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> 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
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Dimitry Sibiryakov

2010-07-19 13:21:56 UTC

Permalink

Post by Bart Smissaert
Have a customer where there is a problem with the IBPhoenix driver
select
first 1000
Falling over on the number 1000 with token unknown.

Full and exact error text, please.

Post by Bart Smissaert
Any idea what the problem could be here?

This customer uses NOT Firebird 1.5.

--
SY, SD.

Bart Smissaert

2010-07-19 14:01:27 UTC

Permalink

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

Post by Bart Smissaert
Have a customer where there is a problem with the IBPhoenix driver
select
first 1000
Falling over on the number 1000 with token unknown.

Full and exact error text, please.

Post by Bart Smissaert
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
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Bart Smissaert

2010-07-21 13:36:04 UTC

Permalink

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

Post by Bart Smissaert
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

Post by Bart Smissaert
Have a customer where there is a problem with the IBPhoenix driver
select
first 1000
Falling over on the number 1000 with token unknown.

Full and exact error text, please.

Post by Bart Smissaert
Any idea what the problem could be here?