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 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:inetpubvhostsprivatemydb.mdb;User Id=;Password=;"}}}
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:
The only reason for using a DSN would be because your site is already written using this older connection technique.