i write the following codes
----------------------------
<%
Dim mysqlConn,rs
Set mysqlConn=Server.CreateObject("Adodb.Connection")
ConnString = "Driver=mySQL};Server=gateway;Option=16834;Databas e=mysql;"
mysqlConn.open ConnString
Set rs=Server.CreateObject("Adodb.Recordset")
sql="Select * from tblusers"
rs.open sql,mysqlConn
while rs.eof <> true
Response.Write(rs("User_ID"))
Response.Write(rs("Password"))
rs.movenext
wend
rs.close
Set rs=nothing
mysqlConn.close
Set mysqlConn=nothing
%>
-----------------------
this script showing the following error at line 13
pointing in red line as under
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/online/mysqltest.asp, line 13
pls help me

Hi Knight,

You are missing a "{" bracket there.

"Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase ;"

Cheers!

_________________________
- Vijay G
Strive for Perfection

no dear it was my cut and paste mistake the actual code have it
ConnString = "Driver={mySQL};Server=gateway;Option=16834;Databa se=mysql;"
the problem isnt there

Is that a local database or remote database?

_________________________
- Vijay G
Strive for Perfection

it is local database as the connection string said
same machine server and client

I am not sure, but may be an MDAC upgrade can help you out.

Cheers!

_________________________
- Vijay G
Strive for Perfection