Versions Compared

Old Version 2

changes.mady.by.user user-a7162

Saved on

compared with

New Version Current

changes.mady.by.user user-a7162

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Minor edits

...

The following sample values assume that you will use the JDBC-ODBC bridge included with your JDK on the Windows server running LANSA Composer in order to connect to your Microsoft Access database.  This approach requires that the machine also have the Microsoft Access ODBC driver installed.  There are also other JDBC solutions available for Microsoft Access from third-party providers.

Database driver class

Following is the class name used with the JDBC-ODBC bridge:

sun.jdbc.odbc.JdbcOdbcDriver

Database connection string 

Following is a sample JDBC connection string to connect to a Microsoft Access database using the JDBC-ODBC bridge:

jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ=C:\COMPOSER\TUTORIAL\TUTORIAL.mdb

Further considerations

  • The JDBC-ODBC bridge is deprecated and has been removed from Java 1.8 and above.  There are other JDBC solutions available for Microsoft Access from third-party providers.
  • The Database Configuration need not specify a username and password unless you have defined security in your Microsoft Access database.