ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> ODBC DDF file creation problem (ODBCDDF)
http://www.istechforum.com/YaBB.pl?num=1081275745

Message started by ndemarco on 04/06/04 at 10:22:25

Title: ODBC DDF file creation problem (ODBCDDF)
Post by ndemarco on 04/06/04 at 10:22:25

Hi,

I am trying to IMPORT the BKICMSTR table into Access 2000 XP. I got an error in Access, so I tried rebuilding the ODBC DDF (ODBCDDF.RUN) in Evo and in DOS DBA.

Running ODBCDDF gives "An error occurred while copying FILE.NEW to FILE.DDF. Contact DBA Support for assistance."

Ideas?

Regards,

Nick

Title: Re: ODBC DDF file creation problem (ODBCDDF)
Post by aricon on 04/06/04 at 10:30:04

What error in Access?

Title: Re: ODBC DDF file creation problem (ODBCDDF)
Post by ndemarco on 04/06/04 at 15:18:48

The text of the error is:

[Pervasive][ODBC Client Interface] Numeric value out of range (#0)

I am searching on Pervasive's KB, but the topic doesn't link to a working page (perhaps someone at Pervasive is getting a "Numeric value out of range (#0)" error.

Title: Re: ODBC DDF file creation problem (ODBCDDF)
Post by aricon on 04/06/04 at 22:22:03

Yeah there is one field in BKICMSTR that Access doesn't like. Try making it a pass-through query.