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

0 Likes

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
Comment List
Anonymous
Related Discussions
Recommended