AnsweredAssumed Answered

Is FileMaker an ODBC level 1-compliant database?

Question asked by LeeHaris on Aug 30, 2010


Is FileMaker an ODBC level 1-compliant database?


Will Filemaker database communicate with the program HotDocs. HotDocs says that it works with any ODBC level 1-compliant database (using the Microsoft OLE DB provider for ODBC (MSDASQL))

HotDocs may also function with other OLE DB providers, as long as the following conditions are met: 1) The OLE DBprovider must accept plain-text command strings, 2) the OLE DB provider must return rowsets (ADO Recordsets) as the result of commands—not records and/or streams, and 3) the database must reside in a location accessible by HotDocs. OLE DB providers that expose data in individual Rows and/or Fields (but not Rowsets) will not work. Please keep in mindthat these are recommended guidelines and meeting these guidelines does not necessarily mean your provider will work with HotDocs.

HotDocs uses ActiveX Data Objects (or ADO) as the primary means of communicating with databases. (HotDocs 5 used ODBC.) ADO allows greater flexibility in the types of databases you can access and gives you greater control over how you extract information from a database.

In order to connect HotDocs to a database using an ADO connection, you must link your template to the database using an OLE DB provider. An OLE DB provider acts as a "translator" between HotDocs and the database, telling the two how to interpret the information that is being passed from the database to the template. Many database programs and/or clients include their own native OLE DB providers, but if you are using a database for which no provider is available, you can use an ODBC driver for your database and the OLE DB provider for ODBC. An ODBC-type connection allows you to connect to the database using an ODBC DSN (data source name), which associates a database driver with the database itself. This help file includes instructions for setting up both types of connections—see Create a Database Component