Upload your Access database file (.mdb) to the “/Private” folder which is above your web root. You will then either need to use OLEDB or a System DSN to connect your website to your DB. You may also need to write to Hyve support and ask us to set the appropriate permissions on the private folder. Please test this first and contact us if it is still not working.

OLEDB#

OLEDB does not require any server-side configurations, so you would simply write your code to reference the DB with the following connection string:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\inetpub\vhosts\private\mydb.mdb;User Id=;Password=;"

System DSN#

Using a system DNS a slower method of communicating with the server. It is also an older system which requires a server-side configuration. This is how to do it via Plesk:

  • Click “ODBC Settings” within domain manager
  • Click “Add New ODBC DSN”
  • Add the name you wish to use to reference the DB from your code
  • Select “Microsoft Access Driver (*.mdb)”
  • Follow the wizard and save the configuration

Next, you will need to use the following DSN connection string:

"DSN=myDsn;Uid=myUsername;Pwd=;"

The only reason for using a DSN would be because your site is already written using this older connection technique.

Back to Windows Plesk

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-3) was last changed on 24-May-2017 15:30 by Hyve Support
G’day (anonymous guest) My Prefs
  • View Page Source
  • This clear IPSec security association,
    clear ipsec sa peer X.X.X.X
    

All Pages

Page views: 2695

Private Tomcat

Linux

MySQL

Email

SQL Server

ASP

JSP

C#

Web Mail

Windows Plesk

Linux Plesk

PHP

Gaming

ASP.NET

Persits ASPUpload

Wiki Help

Referring Pages:
...nobody

JSPWiki v2.8.1