How do I create a datasource, dsn, or an odbc connection to my MsAccess database? -- Oct 8 2009, 6:35 PM
This is an example
Prepare Login to Plesk control panel using your Plesk login.
Navigate to the domain where you want to add your DSN. Put Database .mdb file on the server Note: You must have your mdb file with your web site files on the server. Upload your database to your web site via FTP. IE: C:\Inetpub\vhosts\xxxxxxxx.com\private ( a good location for enhanced security )
Add ODBC DSN Choose ODBC Data Sources icon under Services.
Choose Add New ODBC DSN icon.
Fill in the connection name and connection description fields. IE: Connection Name: xxxxxxxx.com
Choose what type of driver you'd like to use. IE: Microsoft Access Driver (*.mdb)
[DBQ]Database File Path: find the actual .mdb file you've uploaded. Click on OK.
Fill out the preferences form for the DSN [DBQ] * Database File Path IE: C:\Inetpub\vhosts\xxxxxxxx.com\private\xxxxxx.mdb Note: Full path is required. [UID]Login ID: [PWD] Password: Note: id and password are only required for MSAccess if you have the file protected with a login/password.
All remaining fields can stay as they are.
Test Click on Test, you should see Info: Connection successful Note: if you do not, Correct your settings and try again.
Click Next and Plesk will create the DSN for you.
Click finish Note: You should see your file listed under ODBC DSN Connections. Note: Click the connection name if you need to edit the dsn connection.