AnsweredAssumed Answered

ODBC driver error

Question asked by pmarceaujr on May 17, 2010
Latest reply on Apr 16, 2011 by PaulCowper

Summary

ODBC driver error

Description of the issue

FileMaker ODBC is not returning results as expected.  For example, when using the OLE DB driver to connect to FileMaker, the IsFieldUpdateable flag returns NO for all fields, FieldLengths come back as 1,000,000 characters, etc...Our connection connects to ODBC using ADO.  Snippet from http://en.wikipedia.org/wiki/ActiveX_Data_Objects: Microsoft's ActiveX Data Objects (ADO) is a set of Component Object Model (COM) objects for accessing data sources. A part of MDAC, it provides a layer between programming languages and OLE DB (a means of accessing data stores, whether they be databases or otherwise, in a uniform manner). ADO allows a developer to write programs that access data without knowing how the database is implemented. You must be aware of your database for connection only. No knowledge of SQL is required to access a database when using ADO, although one can use ADO to execute SQL commands.

Outcomes