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 ================================== The easiest way to import XML, CSV and textual files into Firebird: http://www.guacosoft.com/xmlwizard ==================================