Technicals Weblog

ODBC Connection DNS In Plesk October 2, 2007

Hi,

Sometimes may you forced about using ACCESS databases in PLESK.For make a new ODBC connection between ACCESS databases or other else DBs and *.asp files on server uses PLESK you should modify the connection like these notes:

1. Login to PLESK control panel.
2. Search your exact domain.(For Admins)
3. In your domain configuration, choose ODBC setting.
4. Click on “Add New ODBC DSN”.
5. Your Connection name is optional. So make it now.
6. Explain your description on Connection Description field.
7. Choose your Driver type (Microsoft Access Driver *.mdb)
8. Let’s go on OK!
9. Now in [DBQ] Database File Path write this path which is in some servers: E:\Inetpub\vhosts\YOURDOMAIN.TLD\httpdocs\Your DB Folder \Yourdb.mdb
10. If your database has a USERNAME and PASSWORD, write it on fields.
11. Please hit the Test button to check your connection.It will be connected.
12. Enjoy it.