A R U N

Problem description-

When creating Datasource with MS Access or MS Access Unicode driver seleceted produces this error even though there is valid Access database file-

Connection verification failed for data source: DSN name
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.

Solution-

Chose “other” as the driver type and entered the following:

JDBC URL:
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=[Full path to your database file];DriverID22;

Driver Class:
sun.jdbc.odbc.JdbcOdbcDriver

Drive Name:
MS Access via JDBC