Problem in querying Filemaker table using 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

[csauve]

Hi Aditya,

I have a similar problem when accessing data via an ASP page. But I've notice that this is happening only when my query contains Two "numeric" fields. I have the following error :

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

[DataDirect][ODBC SequeLink driver]Numeric value out of range. Error in column 3.

When there's no data in any of the numeric fields of every records, there's no error and the texte fields data display.

I've try to change the "NUMERIC" fields has "TEXT" field and it worked! The data display without error.

I think it's a ODBC driver problem

NB : I'm on Windows 2000 too.

Christian Sauve

www.atlastelecom.com

[kalliman]

Hi All,

A have same problem when trying to fetch my database. The ODBS said the records are empty, but the aren't. Any Ideas?