Subject | Re: [firebird-support] Error using fbcopy |
---|---|
Author | Milan Babuskov |
Post date | 2012-12-12T18:46:06Z |
horushardware wrote:
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
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
> Copying table: TABLE1Looks like Dialect1 problem. FBCopy only supports Dialect 3 databases.
> 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"
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
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================