Subject | [firebird-support] isql issue with FB 2.1 on Mac OS X 10.4.11 PPC |
---|---|
Author | Paul Beach |
Post date | 2008-04-22T10:02:24Z |
Any ideas?
Yes, it looks like the ppc build for MacOSX has been broken somehow.
I need to check and find out why.
Paul
I am having some issues after having installed the SuperServer-Package
of Firebird 2.1 for Mac OS PPC.
I get no results when issuing any query in isql. Issuing the query
again results in the error message
-SQL error code = -519
-The prepare statement identifies a prepare statement with an open cursor
Here's what to do to reproduce the error, at least on my system:
Marvin:~ thomas$ isql -u sysdba -p masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'test.fdb';
SQL> connect 'test.fdb';
Commit current transaction (y/n)?y
Committing.
Database: 'test.fdb', User: sysdba
SQL> select * from rdb$database;
SQL> select * from rdb$database;
Statement failed, SQLCODE = -519
Dynamic SQL Error
-SQL error code = -519
-The prepare statement identifies a prepare statement with an open cursor
SQL>
Connecting from PHP 5.2.6RC6 (freshly compiled against FB2.1) works flawlessly.
I then tried CS just to be sure. The above error does not occur, but
isql keeps segfaulting on exit.
Paul Beach
Tel (France): +33 (0) 2 47 58 30 43
Mob (France): +33 (0) 6 79 24 32 32
Yes, it looks like the ppc build for MacOSX has been broken somehow.
I need to check and find out why.
Paul
I am having some issues after having installed the SuperServer-Package
of Firebird 2.1 for Mac OS PPC.
I get no results when issuing any query in isql. Issuing the query
again results in the error message
-SQL error code = -519
-The prepare statement identifies a prepare statement with an open cursor
Here's what to do to reproduce the error, at least on my system:
Marvin:~ thomas$ isql -u sysdba -p masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'test.fdb';
SQL> connect 'test.fdb';
Commit current transaction (y/n)?y
Committing.
Database: 'test.fdb', User: sysdba
SQL> select * from rdb$database;
SQL> select * from rdb$database;
Statement failed, SQLCODE = -519
Dynamic SQL Error
-SQL error code = -519
-The prepare statement identifies a prepare statement with an open cursor
SQL>
Connecting from PHP 5.2.6RC6 (freshly compiled against FB2.1) works flawlessly.
I then tried CS just to be sure. The above error does not occur, but
isql keeps segfaulting on exit.
Paul Beach
Tel (France): +33 (0) 2 47 58 30 43
Mob (France): +33 (0) 6 79 24 32 32