Facebook Foursquare Google Plus LinkedIn Pinterest Twitter



 
General
Domain
Hosting
Frontpage
Email
FTP
Database
Hosting Controller
Others
1. What is the difference between uploading our database (.mdb) file into DB folder instead of the www folder?
2. I have uploaded my Access database file (.mdb file) into the DB folder, how should I connect to it?
3. I have sign up an hosting account with you. How do I setup MySQL account?
4. How do I control my MySQL database?

1. What is the difference between uploading our database (.mdb) file into DB folder instead
of the www folder?

Your database file runs the risk of being downloaded by unauthorised personnel if it is in the WWW folder as it is the root directory which is browse-able from the web. DB folder on the other hand is set to non-browse-able for security purposes, your database file is protected in this case.

Top!
2. I have uploaded my Access database file (.mdb file) into the DB folder, how should I connect to it?
 

There are 2 ways to connect to the .mdb file in the DB folder.

a. DSN connection
b. DSN-less connection


We recommend DSN-less connection as it works faster and is more reliable compared to DSN connection especially when multiple users are accessing your database concurrently.

The DSN-less script is provided below for your use. Please copy, paste it in your script and amend the "filename" according to your requirement.

You may email us for instructions if you still wish to use DSN connection.

<%
dim RS, dbConn, dbPath

dbPath = Server.MapPath("db/filename.mdb")
Set dbConn = Server.CreateObject("ADODB.Connection")
dbConn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath

%>

Top!
3. I have sign up an hosting account with you. How do I setup MySQL account?
 MySQL database comes free with every RapidCloud's hosting account. Please request through support@rapidcloud.sg
Top!
4. How do I control my MySQL database?
 A user friendly interface PHPmyadmin has been installed to allow easy control to your MySQL. Please log on to http://mysql.exxelnet.com/index.php or http://mysql1.exxelnet.com/index.php according to the server you are in. 
Top!

 

RapidCloud Singapore is a top Singapore Web Hosting and E-Business Consulting Company specializing in Domain Name Registration, Dedicated Server Hosting, Website Design, Website Development and Application Programming. RapidCloud is also a Singapore SEO Company with services that includes Keyword Research, On-Page Optimization, Directory Submission, Link Building and Social Media Marketing.