I've installed the windows version of mysql. I configured nothing.
This is the code I'm trying to use to access mysql from an asp web service
(in vb):
---------
<WebMethod()> Public Function dbConnect() As String
Dim connString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=localhost;" & _
"DATABASE=test;" & _
"UID=test;" & _
"PASSWORD=test;" & _
"OPTION=3"
Dim MyConnection As New OdbcConnection(connString)
Try
MyConnection.Open()
MyConnection.Close()
Return connString
Catch e As Exception
Return e.Message
End Try
End Function
----------------------
It's returning the following exception: ERROR [IM002] [Microsoft][ODBC
Driver Manager] Data source name not found and no default driver specified
Any ideas?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php