Subject Re: Error in converted database
Author sanjayamatya
The utility I am using is IBAccess. I tried various ways to access
tables, but couldn't. I found that I am not allowed even to create
the table or insert data.

When I try to insert data into imported table from Access: get the
error: Table unknown.

When trying to create a new table into imported database, get the
error: Token unknown.


--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:
> 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
> >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
> >
> >Ideas?
> The utility you used to make the conversion may have created case-
> identifiers (object names). This will be so if it created them
> double-quoted delimiters. For example, if it created this table
> 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
> that tool probably applies quoted identifiers to Access data,
> Access permits "illegal" characters - which, in Firebird/InterBase
6.x is
> not permitted unless the quote delimiters are used.
> cheers,
> Helen
> All for Open and Open for All
> Firebird Open SQL Database · ·
> _______________________________________________________