April 26, 200421 yr Newbies 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
April 26, 200421 yr Newbies 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
June 12, 200421 yr Newbies 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?
Create an account or sign in to comment