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>"
' closing connection
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

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

also use option 3. aparently it makes a difference

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.