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")
%>