Does anyone have a great connection script to use with GoDaddy? I'm using Dreamweaver MX to develop with....and this is kicking my arse!!! Please help! I'm at my wits ends, and GoDaddy's tech support's favorite line is "We don't support scripting!" The example connection string sux big time.

Thanks in advance for any and all help!

What does your connection script look like thus far?
Have you looked through the GoDaddy support forums?

Here's some code taken from GoDaddy's website:
<%
Dim oConn, oRs
Dim qry, connectstr, sDSNDir
Dim db_name, db_username, db_userpassword
Dim db_server, dsn_name

dsn_name = "your_dsn_name"
fieldname = "your_fieldname"
tablename = "your_tablename"

sDSNDir = Server.MapPath("_dsn")

connectstr = "filedsn=" & sDSNDir & "\" & dsn_name

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open connectstr
qry = "SELECT * FROM " & tablename

Set oRS = oConn.Execute(qry)

if not oRS.EOF then
while not oRS.EOF
response.write ucase(fieldname) & ": " & oRs.Fields(fieldname) & " "
oRS.movenext
wend
oRS.close
end if

Set oRs = nothing
Set oConn = nothing

%>
Original source: http://help.godaddy.com/article.php?...59&topic_id=&&

- Adam Kahtava [http://adam.kahtava.com]