FMP4.v3 and ODBC

[Bob Carels]

I have both 4.1v3 and 5.0v3 and have been working to import data from and Oracle

DM.

With FMp5 I have no problem, however when I attempt the import with 4.1 I get

duplicate fields showing on the right (columns) when I select the table. Each field is

listed twice for some reason that I can't determine. Any one have any ideas?

also:

I am having a problem with ODBC imports from Oracle using FMP4.v3.

On 2 different files one field defined as text in the oracle table and as text in FM.

Will give be the following errors on each record.

[Microsoft][ODBC driver for Oracle]error in row 1 (1)

then on OK

[ Microsoft][ODBC driver for Oracle]error in column 1: Numeric value out of range

(1)

All other fields import with no problem.

These fields will import with no problem with FMP5.

I am open to suggestions. Has anyone else seen this?

Is the ODBC driver for 4 different than the one for 5? I am using Microsoft ODBC

for Oracle.

Any clues appreciated.

Thanks, Bob

[digifoto]

I get similar results with 4.1 and Microsoft SQL Server 6.5 - I can not import any numeric data and trying to format the output with varchar does not work - although I am pretty green in SQL statements.

In 5.0 - I am having problems with datetime conversions and must format the output with CONVERT(varchar(10), datefieldname,101) to get dates that 5.0 will accept - 4.1 had no problems with the same date fields.