Linux & Windows Web Hosting

  

Affordable Reliable Web Hosting Services

Sign-up Now!

Database Help
If you are looking to use a Microsoft Access DB on your server, we suggest that you do NOT use this type of database. We offer MySQL which is over 10 times faster and works in the same way. You can EASILY convert to MySQL by first creating the MySQL DB file on the server from within WebsiteOS. Click on Website Management, then click on Database Manager. Follow the menus to create your database. There are FREE tools you can download from many sites on the Internet but we find that MySQL Front is an easy and simple to use tool to work with that will convert your existing Access DB on your computer and publish it to the MySQL Server.

The MySQL server name is sqlXX.megasqlservers.com where XX is 2 character like 0e of the server that was assigned to you. When you first click on Database Manager in the WebsiteOS, you will see this hostname. You will create the username and password when you setup the DB in WebsiteOS. You can have up to two MySQL databases. One MySQL database can handle all data for even the largest sites and most applications let you enter a prefix in front of table names.

There are 2 ways to connect to databases on our servers. You can use DSN or DSNless connections. Its much faster to use DSNless connections as its less roundtrip time on the server to process your requests. If you do require a DSN you would need to contact us in order to have it created. Below is information on DSN and DSNless connections.

NOTE: the code examples may wrap from 1 line to the next.

Sample MS Access DSNless connection:
mdbfile = "/stuff/sample.mdb"
connstr = "Driver={Microsoft Access Driver (*.mdb)};
DBQ="&Server.MapPath(mdbfile)&";"

If you have database errors, try this connection instead:
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source="&Server.MapPath(mdbfile)&";"

Sample MySQL DSNless connection:
Driver={MySQL};Server=megasqlservers.com;
DATABASE=databasename_domain_com;
UID=dbm.domainname.com;PWD=password;

Sample MS Access DSN connection:
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN=databasename_domain_com

Sample MySQL DSN connection:
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN=databasename_domain_com;
UID=dbm.domain.com;PWD=password"

If you do require a DSN, be sure that you have enabled ASP or ASP.net on your site before you send a request to create a DSN. Please complete the online request form in My Services.
 General Information

 .htaccess Help

 Email Settings

 Spam Filtering

 Database Help

 Windows Services
    ASP
    ASP.NET