odbc – How do I create a System DSN

odbc – How do I create a System DSN

  1. Open the ODBC Data Source Administrator dialog by navigating Start -> Control Panel -> Administrative Tools -> Data Sources (ODBC)
  2. Select the System DSN tab and pass Add
  3. Select the Microsoft Access Driver and press Finish
  4. Enter the Data Source Name MondrianFoodMart (and a suitable description)
  5. Press Select and use the Select Database dialog to pick the .mdb
  6. Press Ok, keep your fingers crossed and test

While in docs they say about JDBC URL to Access db: jdbc:odbc:MondrianFoodMart it may be easier to use such URL in other form:

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=MONDRIAN_HOME\demo\access\MondrianFoodMart.mdb

Of course replace MONDRIAN_HOME with real directory name. It may be useful if such URL is part of configuration file. Then creating DNS will not be necessary.

odbc – How do I create a System DSN

Leave a Reply

Your email address will not be published.