» Databases : FAQ
How do I connect to my MSSQL database using Enterprise Manager?First of all, ensure that your database is already created. To do so:
1. Login to your Account
2. Click to Administer your domain name
3. Click "Database" icon
4. Click to create the database of MSSQL type
Once the database is created, all the login information will be available to you on the screen. The hostname, database name, username and password are all you need to make a connection to the database using Enterprise Manager software.
Note: If you do not have a "Database" icon in your domain administration, it means that your hosting plan does not support it. You can upgrade to Business Hosting or above to get the functionality.
MySQL table types
Solution By default, new tables will be created as myISAM,
however you can specify the type of the table you wish to
create, such as InnoDB.
How often will my website be backed up?
Website backups are performed on a weekly basis and are run on Sunday afternoons. We keep up to 2 months worth of your website backups.
Database backups are performed nightly and we keep 2 weeks worth of nightly backups for your database.
Connecting to MSAccess database using ASP
Connection to the database is made using the following string using ASP:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "path/database.mdb"
To add an MS Access database to your site, just copy the ASP code above, and then FTP the database onto your hosting account. You can add more then one MS Access database to your site if required (but it is not recommended that you have more then 4 separate databases).
It is not recommended that you use MS Access databases for heavy traffic sites, or if the database is providing dynamic content to the site via SQL queries. Doing this can dramatically slow your site down as MS Access is not designed as a high volume database engine. The following links may assist with optimisation of your MS Access database, but it generally recommended that you migrate to one of the other supported databases below:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q209126
http://support.microsoft.com/?kbid=286222
Other Categories