Subject Re: [firebird-support] INTERBASE freezing...PLEASE HELP!!!
Author Helen Borrie
At 05:51 PM 4/12/2004 +0000, you wrote:



>Hello All,
>
>Well I'm really hoping somebody can help me out here..
>
>I had been running Interbase 7.1 trial version and everything seemed
>to be working just fine. Now that I've upgraded to the full licensed
>version I'm having some problems.
>
>I have a database with about 20000 some rows about 3mb. When I
>do a search, for example:
>
>select "column" from "Table";
>isql will only return about 280 values and then just lock up. It stops
>running and I have to kill it from another terminal on Linux.
>
>I've connected to the database through database workbench and the
>database is not corrupt because I can see all the data there. ISQL
>seems to be the problem not being able to display all my results.
>
>PLEASE HELP!!
>
>Thanks a lot!!

I note from another message that you are running your server on
Linux. Just as a reality check, would you just double-check that you are
running IB's isql and not a program of the same name that belongs to
another RDBMS?

IOW, either run isql locally from IB's ./bin directory, using dot-slash, or
provide the full path to the program.

./hb