I'm wondering if anyone had this problem or know what I can do to make this work. I am using Dreamweaver 8 on OS X 10.4, ASP, mySQL and VB. I have Brinkster as my hosting which I have a mySQL database on it. I connect to the database using this:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_web_mysql_STRING
MM_web_mysql_STRING = "DRIVER={MySQL ODBC 3.51 Driver};Server=mysql5.brinkster.com;Datatbase=####;UID=####;PWD=#####;"
%>

When I test it, it says Connection Successful. But when I go to the database tab and look for the tables none of the tables show up. Now the hosting company told me to use this connection:
Dim oConn, sConnection

Set oConn = Server.CreateObject("ADODB.Connection"
sConnection = "Driver={MySQL ODBC 3.51 Driver};" &_
"Server=MySQL.Brinkster.com;uid=UserName;pwd=password;database=UserName;"
oConn.Open(sConnection)

oConn.Close
Set oConn = nothing

But that doesn't seem to work in Dreaweaver to connect to the database. And they said to use a different software which I can not do since I'm using 3rd party software that only works with Dreamweaver. I try to find out if Go Daddy might work but they said that remote connections are not permitted to a database. Can someone tell me what I'm doing wrong or if there is a work around? Or if there is nothing I can do then can you recommend an NT server host that it does work on. Someone please help me.

You will need to configure your panel the way you did it on your local system so tell your host to give yo access to the remote server. I once had that problem

Urmy