Hi,
I have been trying to connect my ASP page to my MySQL DB for days and as a newbie to connecting to MySQL and using MySQL... It's not working and I'm at my wits end! Please help!
This is my code with connection script and how I'm using it...
<%Response.buffer = true%>
<HTML>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<%
'create connection, recordset objects
var rsEvents = Server.CreateObject("ADODB.Recordset");
rsEvents.ActiveConnection = "Driver={MySQL};DATABASE=dbname;UID=username;PASSW ORD=password;";
SQL= "SELECT * FROM NEWS;"
rs.Open SQL, ActiveConnection, 1
%>
<body>
<p class="shadow">News Board</P>
<table width="100%">
<tr>
<td>TITLE</td>
<td>PUBLICATION DATE</td>
<td>PARAGRAPH 1</td>
<td>PARAGRAPH 2</td>
<td>PARAGRAPH 3</td>
<td>PARAGRAPH 4</td>
<td>PARAGRAPH 5</td>
<td>PARAGRAPH 6</td>
<td>PARAGRAPH 7</td>
<td>PARAGRAPH 8</td>
</tr>
<%
IF not rs.eof Then
rs.MoveFirst
do while not rs.eof
%>
<tr>
<td><%=rs.Fields.item("TITLE").Value%></td>
<td><%=rs.Fields.item("PUB_DATE").Value%></td>
<td><%=rs.Fields.item("PARA1").Value%></td>
<td><%=rs.Fields.item("PARA2").Value%></td>
<td><%=rs.Fields.item("PARA3").Value%></td>
<td><%=rs.Fields.item("PARA4").Value%></td>
<td><%=rs.Fields.item("PARA5").Value%></td>
<td><%=rs.Fields.item("PARA6").Value%></td>
<td><%=rs.Fields.item("PARA7").Value%></td>
<td><%=rs.Fields.item("PARA8").Value%></td>
</tr>
<%
rs.MoveNext
Loop
END IF
%>
</table>
My host account uses chillisoft ASP as its linux based, and this is the format they tell us to connect to MySQL with.
Please help?!
dBforums
>
Connecting ASP to MySQL DB not working
05-07-04, 11:47
Connecting ASP to MySQL DB not working
Linear Mode
