ODBC - Store

By selecting the ODBC module the scanned document will be stored to an ODBC source. The Open Database Connectivity (ODBC) interface by Microsoft allows applications to access data in database management systems (DBMS) using SQL as a standard for accessing the data. ODBC permits maximum interoperability, which means a single application can access different DBMS.

Connection settings:

• Databaseselect what kind of ODBC source is used, the options are:
• Firebird
• Microsoft Access
• Microsoft Visual FoxPro
• MySQL
• PostgreSQL
• Progress SQL
• Sybase Adaptive Server Enterprise
• DSN select when connection with the ODBC source is made through a DSN (Data Source Name).
• DSN name the name of the DSN.
• Connection stringselect when connection with the ODBC source is made using a connection string.
• Connection stringspecify the connection string needed to connect with the ODBC source.

Database & ODBC driver compatibility list:

The lists below denote compatibility with databases and ODBC drivers. If a combination of database and ODBC driver is not listed its compatibility is unknown and must be tested.

Full Functionality:

Database / Version / ODBC driver version

• Firebird / 2.0.3.12.981 (Super Server) / 1.2.0.69
• Microsoft Access
• 2000 format (*.mdb) / 4.00.6304.00 / 12.00.4518.1014
• 2002-2003 format (*.mdb) / 4.00.6304.00 / 12.00.4518.1014
• 2007 format (*.accdb) / 12.00.4518.1014
• Microsoft Visual FoxPro / 6.00.8167.00 / 6.01.8629.01
• MySQL / 5.0.51a / 3.51.23
• PostgreSQL / 8.3.0.1 / 8.03.01.00
• Sybase ASE / 15.0.2 / 15.00.00.152 (comes with DB)

Reduced Functionality:

DatabaseVersionODBC driver versionSpecification

Progress SQL (Open Edge) 10.1B 05.20.0039 (b0034, u0022) (DataDirect) Database binary storage does not work. File location storage does work.

According to Progress this is solved in version 10.1B02.

Additional configuration instructions:

Most databases work correctly with default ODBC settings. In a few instances however these settings are not sufficient and should be modified according to the specifications below:

All databases

DSN’s should be defined as a System DSN to ensure proper access.

Progress SQL 10.1B

Progress SQL needs to know on which schema the user is working. Filling in this value is mandatory and because of that the DSN cannot be used without adding various parameters within a connection string. The ODBC driver provided by DataDirect also does not allow for the entry of a password. Below is an example of a connection string shown which points to a DSN and adds the required information. The ‘pub’ default schema is the most common used schema.

DSN=Progress;Uid=Username;Pwd=Password;DefaultSchema=pub;

Microsoft Visual FoxPro 6

Within the ‘ODBC Visual FoxPro Setup’ the option ‘Fetch data in background’ should be turned off. If this setting is not turned off unexpected connection behavior might occur.

Article ID: 494
Created On: Wed, Jan 15, 2014 at 12:46 PM
Last Updated On: Wed, Jan 15, 2014 at 12:46 PM
Authored by: Administrator [[email protected]]

Online URL: https://kb.quikbox.com/article.php?id=494