Subject Re: [ib-support] Error in converted database
Author Helen Borrie
At 10:03 PM 12-04-02 +0000, you wrote:
>A simple database got converted to gdb fine. But could access only
>one of the tables using commaand "select * from tblAAA". While trying
>to execute this command for other tables produced following error:
>Dynamic SQL Error
>- SQL Error code = -204
>- Table Unknown
>- tblAAA
>- At line 1, column 15

The utility you used to make the conversion may have created case-sensitive
identifiers (object names). This will be so if it created them with
double-quoted delimiters. For example, if it created this table with
CREATE TABLE "TBLAAA" then the name of the table is TBLAAA, not "tblAAA".

From another list I note that you used the sql2gdb converter. I suspect
that tool probably applies quoted identifiers to Access data, because
Access permits "illegal" characters - which, in Firebird/InterBase 6.x is
not permitted unless the quote delimiters are used.


All for Open and Open for All
Firebird Open SQL Database · ·