ADODB Connection Issue

[ski_geek]

I am using Dreamweaver MX 2004 and have a site set up to use ASP (VBSCRIPT). When I create a new page and create a database connection, I am selecting the custom connection and eneter my string. I enter my string and it connects to the database great, but it does not show any of my tables.

What am I doing wrong?

Thanks in advance!

[Newsgroup_User]

Can we see your string?

Piers

[annyearsley]

I am a newby to databases and am having a similar problem with asp and my remote sql database. My hosting provider told me to use this script:
<%
Dim DBName,DBUser,DBPass,objRS,objConn
DBName="cham_members"
DBUser="cham_member"
DBPass="mypassword"

Set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database="&DBName&";UID="&DBUser&";pwd="&DBPass&";"

objConn.Open
Set objRS=Server.CreateObject("ADODB.Recordset")
%>

Since that code doesn't work with DreamWeaver's Databases panel Custom Connection String dialogue box I came up with this one:
DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database=cham_members;UID=cham_member;PWD=mypassword;objConn.Open Set objRS=Server.CreateObject(ADODB.Recordset)

It connected but doesn't show my tables. I followed all the advice I found in another subject:
1. Connect using the "Use passive FTP"
2. Corrected a few illegal hyphens in my database.
3. Tried MySQL 127.0.0.1:3306 which would not connect at all
4. Remove Connection Scripts. No change.
5. I have been running DreamWeaver 7.01 update.

I noticed the database connection names come up in the "Connections" folder so I opened the file it had just created and pasted in the script my hosting company gave me. Still no luck. I am determined to learn to create dynamic websites so I really appreciate your help.
Thanks, Ann Y.