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.