Subject | Copy Paradox data to Firebird problem |
---|---|
Author | Erik De Laet |
Post date | 2008-01-30T15:36:58Z |
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]
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]