Viewing Article

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.