Creating DSN for MS Access Database(.accdb type)

To connect Adeptia with MS Access Database, first you need to create the DSN.


To create the DSN , please refer to the link below :

http://www.devasp.com/samples/dsn_access.asp

It shows the DSN for MS Access, in same way you can create the DSN for other Databases.For MS Access 2007,you need to create DSN for .accdb type(See the below screenshot)

After creating the DSN, you need to create the Database connection and Database info in Adeptia. For MS Access 2007, please follow the steps below :
STEP 1:
Go to Administer > Connectors > Database Driver.

Create a new driver for Access DB.
- Give name and description
- Skip the Upload Jar file step
- Paste the following in the 'Driver Main Class' field: sun.jdbc.odbc.JdbcOdbcDriver

--------------------
STEP 2:

Now go to Administer > Connectors > Database Info
- give name and description
- select the driver created in the previous step

- In the Server URL field of the DB Info object, manually enter the path of the Access database.
Example:

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=c:\\myfolder\\accesdbfile.accdb

User is 'sa' and there is no password.

For earlier version of MS Access , please refer to the link below :

 http://support.adeptia.com/entries/21254193-connecting-to-ms-access-database

forum1_3135.jpg

Have more questions? Submit a request

0 Comments

Article is closed for comments.