Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

How do I create a data source that connects to an access database?

How do I create a data source that connects to an access database?

Problem:

How do I create a data source that connects to an access database?

Resolution:

This can be achieved by either using a DSN (see When database testing with SilkTest, how can I create my own DSN? ) or a DSN-less connection.

  1. From within Silk Central Test Manager go to Administration | Configuration | Data Sources
  2. Click "New Data Source"
  3. Enter a name into the "Name" field
  4. Set "Driver class" to sun.jdbc.odbc.JdbcOdbcDriver
  5. Set the URL field to:
    • DSN Connection: "jdbc:odbc:MydsnName" were MydsnName is the name associated with the recently created DSN within ODBC Data Source Administrator
    • DSN-Less Connection: "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=////.mdb"
  6. Manually enter the name of the database table in the "Table filer" field i.e. tbl_user
  7. Manually enter the name of the primary key column in the "Key column" i.e. user_id
  8. Click "Ok" to save the configuration
  9. Click "Yes" to import the data
  10. Click "Ok" on confirmation message

The new data source will now appear in the list of current Data Sources.


Old KB# 25094

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:52
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.