ODBC Setup

In the Image Capture Processing, scanned pages need to be assigned the index data on them. Then the Index data will be stored in the database. A database is a collection of tables. A table is a collection of data, like a spreadsheet. A table contains rows and columns. Sometimes, the Column is called Field and the Row is called Record. A collection of same type of images is called a Document.

The PDV Module uses Open Database Connectivity (ODBC) method to communicate with database. MS Windows provides different ODBC drivers for different databases. Therefore PDV enables to connect with different databases using different ODBC drivers. For each database needs a Data Source Name (DSN) to keep the database connection information in the ODBC Administration module. There are two way to create a DSN for a project. One is from the ODBC Administration module in the Control Panel. The other is the PDV Setup module. 

To setup the DSN for ODBC for a project s from the ODBC  icon in the Select a Data View Type window.

To select ODBC Data Source Name item in the Setup Menu Bar will bring up Setup ODBC window, too.

If a new project is creating, a blank Setup ODBC window will appear for a new project.

If the Data Source Name (DSN) already exists in the system, select the DSN from Combo Box and the ODBC information will bring up on the screen. To click the Save button will save DSN and ODBC information to the new project.

If the DSN is not in the system, a new DSN must be created. We can assign Data Source Name as the database name. Type the DSN name into the DSN Combo Box, select the database Driver from Driver Combo Box and click new ODBC button to bring up Microsoft ODBC setup window.

Use Select... button to locate the database, then click on the OK button to create the new DSN. After returning the Setup ODBC window, click the Save button to save DSN and ODBC information to the new project and return to the Setup Project Window.

After knowing the database, PDS Admin module needs to know which tables are going to use in the project. To select the database table is to click the ODBC Tables Setup button from the Setup Project window.

Create New Project    Table of Content     Setup Index Data Window