Error querying Filemaker database from ODBC

[aditya sanghi]

Environment : windows 2000 , VC 6.0

Dear all,

I have installed evaluation version of Filemaker Pro 7.0

I am trying to fetch data in filemaker database

from my VC application using ADO.

I am using the DataDirect 32 bit SequeLink 5.4 odbc driver to make a DSN based

connection.

I am successfully able to make a connectin and write into it.

But when im trying to read data from it , it gives problems.

Its observed that if it has a multiple of fields with same

datatype ( e.g. numeric) and the fields have data present in

them in the table , there is a problem in retrieving data.

ADO reports "Numeric Value out of bounds" for numeric fields

and different error if the problem is for text data type.

Does anyone have a clue whats the problem and how

it can be fixed?

Regards,

Aditya

[murtje]

I have no clue, but maybe some wild ideas can help.

- Numbers will be "Decimals" as datatype, if you make use of ODBC and Text will be a "Varchar" as datatype.

- Numbers can have a precision of 400 digits. Maybe ADO can't handle this.

there is a calculation in FileMaker to set the precision.

- What about the length of the text fields?

Koen

Koen