| Subject | Firebird Windows->Linux peculiarity |
|---|---|
| Author | dirtyrentedmule |
| Post date | 2005-02-22T13:46:17Z |
Hey all,
I have a bit of a peculiar problem, and some direction would be great.
Currently, my company uses Firebird 1.5.something on a Windows server,
used primarily for our web applications that are written in ColdFusion
5, served by apache 1.3.*.
Everything has been peachy for a year or so thus far, but our database
server is in some pretty big need of upgrading and we all decided that
moving the database server from Windows to Linux would be our best course.
ColdFusion interfaces with Firebird via older IB6 ODBC drivers (I
think that shipped with Interbae 6, from Easysoft). Back when we moved
from Interbase 6 to Firebird 1.5, there was no issues what so ever....
it made the transition so much more manageable.
Anyway, I setup Firebird 1.5 onto a Gentoo Linux machine. Some
peliminary testing showed that everything worked fine using the Linux
build of Firebird instead of the Windows build. With that, I moved
everything into production. Rather quickly I started getting phone
calls that sections deep in some of our web applications simply
weren't doing anything. It was a bit puzzling being that the only
thing that changed was the DB backend went from Windows to Linux.
Anyway, I started debugging... and what I found is simply... strange.
When I run a query in a ColdFusion template, up front, it SEEMS I have
no restictions on size of the query in any regard. But some toying
around, here is what I found:
If I select less then eight fields from any ONE table (I can select
from any amount of tables), everything works fine. When I select eight
fields from a table, the connection to Firebird is terminated, and
ColdFusion returns an error. If I select MORE then eight fields from
any table, the query simply NEVER returns. Running the same query via
isql or IBConsole, it works fine, which leads me to believe it has
SOMETHING to do with the ODBC driver, but the fact that it worked for
the same version of Firebird on Windows, I dont see how that could be it.
Any thoughts, insite, suggestions, questions... anything would be
appreciated.
Jason Dodson
I have a bit of a peculiar problem, and some direction would be great.
Currently, my company uses Firebird 1.5.something on a Windows server,
used primarily for our web applications that are written in ColdFusion
5, served by apache 1.3.*.
Everything has been peachy for a year or so thus far, but our database
server is in some pretty big need of upgrading and we all decided that
moving the database server from Windows to Linux would be our best course.
ColdFusion interfaces with Firebird via older IB6 ODBC drivers (I
think that shipped with Interbae 6, from Easysoft). Back when we moved
from Interbase 6 to Firebird 1.5, there was no issues what so ever....
it made the transition so much more manageable.
Anyway, I setup Firebird 1.5 onto a Gentoo Linux machine. Some
peliminary testing showed that everything worked fine using the Linux
build of Firebird instead of the Windows build. With that, I moved
everything into production. Rather quickly I started getting phone
calls that sections deep in some of our web applications simply
weren't doing anything. It was a bit puzzling being that the only
thing that changed was the DB backend went from Windows to Linux.
Anyway, I started debugging... and what I found is simply... strange.
When I run a query in a ColdFusion template, up front, it SEEMS I have
no restictions on size of the query in any regard. But some toying
around, here is what I found:
If I select less then eight fields from any ONE table (I can select
from any amount of tables), everything works fine. When I select eight
fields from a table, the connection to Firebird is terminated, and
ColdFusion returns an error. If I select MORE then eight fields from
any table, the query simply NEVER returns. Running the same query via
isql or IBConsole, it works fine, which leads me to believe it has
SOMETHING to do with the ODBC driver, but the fact that it worked for
the same version of Firebird on Windows, I dont see how that could be it.
Any thoughts, insite, suggestions, questions... anything would be
appreciated.
Jason Dodson