hello everybody. i am new to MySQL and want to build some asp pages
providing search facility where search result displays from database. i
have successfully created database in MySQL 5.0, but i can't show them
in asp pages. the browser gives me following error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver]Access denied for user: 'a@localhost' (Using
password: YES)
list.asp, line 9
i have used connection strings. the file i have included in aps page is
db.inc as follows:
<%
dim dbDriver
dim dbDatabase
dim dbUser
dim dbPass
dbDriver = "{MySQL ODBC 3.51 Driver}"
dbDatabase = "bhv"
dbUser = "a"
dbPassword = "a"
%>
where as the file i used to show data is list.asp as follows:
<%@LANGUAGE="VBSCRIPT"%>
<!-- #INCLUDE file="db.inc" -->
<%
dim adoConn
set adoConn = Server.CreateObject("ADODB.Connection")
adoConn.Open "Driver=" & dbDriver & "; SERVER=localhost; Database=" &
dbDatabase & "; Uid=" & dbUser & ";Pwd=" & dbPassword & ";OPTION=3;"
if adoConn.errors.count = 0 then
response.write "Connected Successfully!"
end if
%>
<html>
<head>
<title>welcome</title>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
</head>
<body>
<p> </p>
<p> </p>
<p> </p>
</body>
</html>
pl. help me
