Cannot connect to remote MySQL DB from GoDaddy

Question

I developed an ASP application (VBScript backend, JavaScript frontend) that makes use of a remote MySQL database (Bugzilla). The applicaiton works well on a localhost, yet fails to work when uploaded to GoDaddy. Spending two hours on the phone with GoDaddy's support didn't help...

The error I'm getting is:

==============================================================

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

==============================================================

My connection string is:

"DRIVER={MySQL ODBC 5.1 Driver}; SERVER=xxx.org; DATABASE=xxx;UID=xxx;PWD=xxx;OPTION=16427"

I tried to modify it by removing the OPTION, changing the MySQL driver, reducing the driver to DRIVER={MySQL}, changing the case of UID and PW, etc. - no progress...

I would appreciate any help.

Answer 1

Ask Godaddy if they have the MySQL ODBC Driver installed on the server that hosts your website.

Answer 2

http://help.godaddy.com/article/253

This example describes using ASP/ADO to connect to a MySQL Database.

<%
Dim oConn, oRs
Dim qry, connectstr
Dim db_name, db_username, db_userpassword
Dim db_server

db_server = "mysql.secureserver.net"
db_name = "your_dbusername"
db_username = "your_dbusername"
db_userpassword = "your_dbpassword"
fieldname = "your_field"
tablename = "your_table"

connectstr = "Driver={MySQL ODBC 3.51 Driver};SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";PWD=" & db_userpassword

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) & "<br>"
oRS.movenext
wend
oRS.close
end if

Set oRs = nothing
Set oConn = nothing

%>