I'm having a problem connecting to my ISP's MySQL database via ASP using Dreamweaver MX on a Macintosh. My ISP is running Chili!soft ASP on a Linux server.
<P>
When I create a new dynamic page in Dreamweaver, call it <I>myDatabase.asp</I>. I then select the plus symbol from the Databases tab in the Applications panel, and select Custom Connection String. I give the Connection Name: <I>connMyDatabase,</I> and set the Connection String to:<P>
<font color=red>
"Driver={Mysql};Server=00.00.00.000; Database=myDatabase; UID=myDatabaseUserName; PWD=myDatabasePassword"
</font><P>
When I click on the "Test" button, I get a message saying <I>"An unidentified error has occurred."</I> I click 'OK" on the error message and then "OK" on the Connection String dialogue box.

Then, Dreamweaver automatically creates a new folder in my site called "Connections" and in that folder a new file is created called <I>connMyDatabase.asp</I>. Inside is the following code:
<P><font color=red>
<%<BR>
' FileName="Connection_ado_conn_string.htm"<BR>
' Type="ADO" <BR>
' DesigntimeType="ADO"<BR>
' HTTP="true"<BR>
' Catalog=""<BR>
' Schema=""<BR>
<P>
Dim MM_connMyDatabase_STRING<BR>
MM_connMyDatabase_STRING = "Driver={Mysql};Server=00.00.00.000; Database=myDatabase; UID=myDatabaseUserName; PWD=myDatabasePassword"
%>
</font><P>
If I copy & paste this code below the first line in my original file <I>myDatabase.asp</I>, I can finally get records to show up from my database. Unfortunately, at this point, I lose a lot of Dreamweaver's functionality and have to start hand coding.
<P>
How can I get the connection to work, using the standard Dreamweaver method, so I can utilize all of Dreamweaver's dynamic capabilities?