How to connect to the MS Access database using the ODBC DataServer

« Go Back


EnvironmentProduct: OpenEdge
Version 10.x, 11.x
Product: Progress
Version: 9.x
OS: All supported platforms
Other: ODBC DataServer
Question/Problem Description
How to connect to the MS Access Database using the ODBC DataServer
How to create a schema holder for MS Access Database using the ODBC DataServer
How to create a schema holder from MS Access database
How to configure a datasever odbc to connect a Microsoft Access database
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number

Here are the steps to accomplish this, it is assumed:

ODBC DataServer license is installed on the machine where MS Access Database is installed and the schema holder is going to be created on this machine, no DataServer broker is required.

1. Create an ODBC DSN under Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN.

USE Microsoft Access Driver (*.mdb) ODBC Driver.

2. Test the ODBC DSN to verify that the connection is working by using any SQL tool or MS Excel.

3. Create a Progress empty database (schema holder) with any identifiable name, and connect to it in single user mode.

4. From the "Data Administration" window, go to DataServer > ODBC Utilities > Create DataServer Schema...

5. Supply "Logical Database Name". This also could be any identifiable name but not the same as the schema holder name).

6. If the access Database does not have any user security, the connection parameter will not require any -U <user_name> and -P <password> parameters.

7. Enter the name of the ODBC DSN name that was created in step 2, and click OK.

8. Click OK on the next screen without entering the user name and the password. If you supply -U and -P in the step 6, this screen will not require any input.

9. In the "Pre-Selection Criteria For Schema Pull", either leave stars in all of the input text box, or enter the appropriate name for any one of the criteria. If all the tables is required to pull into the schema holder, only the owner name is required.

10. Use a single mouse click to choose a table or another single mouse click to select a table or use "Select Some..." and "Deselect Some..." buttons to select and deselect the table(s).

11. Click OK and it should bring all the selected tables' references to the schema holder.

12. After schema holde is created, use following connction parameters to connect to schema holder and MS Access database

prowin32 odbholder -RO -db dsn_demo -dt ODBC -ld demo -H host1 -S oserviceA -U bob -P bobpass

 odbholder - schema holder name

dsn_demo - ODBC DSN name

demo - logical name

Was this article helpful?


Your feedback is appreciated.

Please tell us how we can make this article more useful.

Characters Remaining: 255