Web Hosting - Online Help - Mecca Hosting Web Hosting - Inform. Educate. Assist.
Home
General
Domain
Website
Email
Account Login
 
23th Anniversary

Web Hosting - 99.99% Service Uptime - Guaranteed!

Security Verified Seal

Get Firefox! The browser you can trust

 

We support database access on all web publishing programs, but are not
able to provide instructions for all of them.
The configuration options come down to five main things:

1. DRIVER: MySQL

This driver must be installed on your computer. You can download this
driver here.

2. DATABASE: mydomain_com

The database name cannot contain '.' or '-' characters, so we replace them
with the '_' (underscore) character. Note: Please replace "yourdomain_com"
with your domain name.

3. SERVER: www.mydomain.com

Use your normal web site address.

4. UID: a0000033

Use the database user id that you were assigned. This would have been
provided to you in an e-mail entitled "Your database has been created.".
Please contact our support team if you did not receive it.

5. PWD: (your password)

This is the same password that you use to login to other areas of your account.

You do not use a DSN to connect to our database, so do not select that when
setting up your database connection. You would typically create a "custom"
connection string, which would typically look like the following:

"DRIVER={MySQL};DATABASE=mydomain_com;SERVER=www.mydomain.com;UID=a0000033;PWD=mypassword"

 
 

ASP CODE SAMPLE:

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={MySQL};DATABASE=mydomain_com;SERVER=www.mydomain.com;UID=a0000033;PWD=mypassword;"
Set myTable = Conn.Execute("SELECT * From myTable")
%>

Home | General | Domain | Website | Email | Account Login

© Copyright Mecca Hosting 2000-2024. All rights reserved.