0

i m very new to asp. i m trying to learn asp. i m trying to connect to mysql database.
i m using this code
<%
' Open database
Dim Conn, RS
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={MySql}; Server=localhost; database=db name; uid=name; pwd=pass; option=0;"
Set RS = Conn.Execute("SELECT * From userss")
' display results
While Not RS.EOF
Response.Write RS.Fields("usercode") & "<br>"
RS.MoveNext
Wend
' closing connection
RS.Close
Conn.Close
Set RS = Nothing
Set Conn = Nothing
%>

but i m getting the error as


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/myweb/a.asp, line 5


i have apache on port 80 on my pc
thats y i m working asp on iis
as localhost:81/myweb/a.asp
is this causing any problem

2
Contributors
2
Replies
3
Views
12 Years
Discussion Span
Last Post by william_stam
0

the error was i had no myodbc connection. i downloaded myodbc connector the it worked.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.