--- In firebird-support@yahoogroups.com, "tomkrej" <respektive@...>
wrote:

>
> >
> > Aritmetic overflow or division by zero has occured.
> > Arithmetic exception, numeric overlof, or string truncation. Cannot
> > transliterate between character sets.
> >
>
> Are You sure, that You use exactly the same character set in connectin
> parameters??

The program is not recompiled and uses a global connection routine
which reeds only the server and alias from an ini file. So, if the
connection string is wrong, it should be wrong in both runs.

As I said, same executable, same (binary copy of the) database. Only
difference is one time localhost:alias (using embedded server), second
time server:alias (normal connection over the local network).

I thought it had something to with default characters specified in some
Firebird setting, but can't find any.

>
> This could be caused by the fact that You did not specify the
> character set and client is connected via NONE, and the problem are
> all characters with code 128 and above.
>
> Tom
>

[---- original post -------------------------------------------]
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 ?