Thank u Shannon for sharing the error possiblities. with me.
Ur guess is absolutely right.

Am creating a Tool which will import all tables from Mdb file.
Fib plus is really great (while bulk inserting) fast..!!!

After spending a Long time in Checking with different machines, I
found that Its the problem with CHARSET- The Pblm comes when I select
the ASCII charset. If I selected None - working fine

Thanks once again

Dilish












--- In firebird-support@yahoogroups.com, "Clay Shannon"
<cshannon@d...> wrote:

>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Ray Jenkins
> Sent: Thursday, November 17, 2005 11:01 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] FIB Plus Error
>
> On 11/17/05, Dilish <dilish_tv@y...> wrote:
> >
> > While Executing my application am getting the following error.
> > (Working fine in Win 2003 Servers..!!!)
>
> Does this mean you have two different databases that your trying this
> query on, and its working on one but not the other?
>
> > arithmetic exception, numeric overflow, or string truncation.
> >
>
> <<If the above assumption is correct, I would first check that the Table
> definitions are the same, this error for me has almost always been my
> app trying to send down more string data than I had column width for,
> so I would have to go back into my app and guard against strings with
> too many characters being sent in a query.>>
>
> Also, if you have used a new TpFIBDatabase component and forgot to

change

> the SQLDialect property to 3 from 1, this can cause worlds of headaches
> (easily remedied, though).
>
> Clay Shannon,
> Dimension 4 Software
>