--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...> wrote:

>
> horushardware wrote:
> > Copying table: TABLE1
> > Connecting to: '' as 'SYSDBA'...Connected.
> > Reading charset: NONE. No need for reconnecting.
> > Connecting to: '' as 'SYSDBA'...Connected.
> > Reading charset: NONE. No need for reconnecting.
> > Disabling triggers...done.
> > New format detected.
> > ERROR!
> > *** IBPP::SQLException ***
> > Context: Statement::Prepare( INSERT INTO TABLE1 ("FIELD1","FIELD2","FIELD3") VALUES (?,?,?) )
> > Message: isc_dsql_prepare failed
> >
> > SQL Message : -104
> > Invalid token
> >
> > Engine Code : 335544569
> > Engine Message :
> > Dynamic SQL Error
> > SQL error code = -104
> > Token unknown - line 1, column 22
> > "FIELD1"
>
> Looks like Dialect1 problem. FBCopy only supports Dialect 3 databases.
> You can use gfix to switch the dialect to 3 and then do the copy:
>
> http://www.firebirdsql.org/manual/gfix-dialect.html
>
> Regards,
>
> --
> Milan Babuskov
>

Thanks Milan and sorry to be late.

But no luck here. I changed the dialect to 3 and do a gstat to verify. But fbcopy keeps saying the same error about the unknown token.


Best regards,
Jose