Subject Copy Paradox data to Firebird problem
Author Erik De Laet
I have written a program in Delphi 7 which copies my data from a
Paradox BDE alias to a Firebird 1.5 database (the program empties
the tables, and than generates INSERT statemenets to fill the Firebird db).

Know that I have the exact FB database copied to a network folder and
to a local folder for my tests.
Know further that it is the exact same executable which is started
twice and that I use the Firebird alias configuration file - no
recompilation is performed).

If I run the executable using embedded server ( connection via
localhost:theAlias ) I can copy the data from the Paradox to the FB
database. Local pc is a Windows XP.

If I run the executable using the server (connection via
theServer:theAlias ) I get the following error :

Aritmetic overflow or division by zero has occured.
Arithmetic exception, numeric overlof, or string truncation. Cannot
transliterate between character sets.

Server is a Windows 2000 server.

I use the FibPlus 6.8 components, so the problem might as well be
there, but I though I'd ask you before trying to contacting Devrace.

Are there any parameters in the Firebird config file which set some
default character set ? Or are the local settings of the local pc
and/or server influencing the database ?


thanks,
--
Erik De Laet
E.De.L.Com bvba
Antwerp - Belgium



[Non-text portions of this message have been removed]