Connection string for a MySQL database needed-this is driving me nuts!

Wayne... · May 17, 2004

I'm trying to get asp to conect to a MySQL database, I've tried copying a
few examples online that I found [there doesn't seem to be many!!] and I
always get a 500 error with the code below. what am i doing wrong?
any examples of a working connection string anyone could show me would be
fantastic. thanks i advance.

Wayne...

<%@ LANGUAGE="VBSCRIPT" %>
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MyConn.Open = "DSN=main;Uid=wayne;Pwd=******;"

SQL_query = "SELECT * FROM content;"
Set RS = MyConn.Execute(SQL_query)
%>
<HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BASEFONT FACE="arial">
<BODY>

<% Response.Write SQL_query %>

<%while not RS.eof%>
<%=RS("")%> <%=RS("title")%> <%=RS("date")%> <%=RS("content")
%> 
<%RS.MoveNext%>
<%wend%>

<%
RS.Close
MyConn.Close
%>
===========
the other version I tried:
===========
<%@ LANGUAGE="VBSCRIPT" %>
<%
strConnection =
"driver={MySQL};server=IP_NUMBER_GOES_HERE;uid=wayne;pwd=******;database=mai
n;option=NUM"
Set adoDataConn = Server.CreateObject("ADODB.Connection")
adoDataConn.Open strConnection

strQuery = "SELECT * FROM content;"
Set RS = adoDataConn.Execute(strQuery)
%>

==================
HEEELLLPPPP!!!!!!!!!!!!!!!!!!!!!!!!!!

[ + 2 0 r p 3 ] · May 17, 2004

you need to make sure you have the latest mysql odbc drivers installed.
available from www.mysql.org then this string should be good.

"driver={MySQL ODBC 3.51
Driver};server=YOUR_SERVER;database=YOUR_DB;uid=YOUR_USERNAME;pwd=YOUR_PASSW
ORD"

Wayne... said:
I'm trying to get asp to conect to a MySQL database, I've tried copying a
few examples online that I found [there doesn't seem to be many!!] and I
always get a 500 error with the code below. what am i doing wrong?
any examples of a working connection string anyone could show me would be
fantastic. thanks i advance.

Wayne...

<%@ LANGUAGE="VBSCRIPT" %>
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MyConn.Open = "DSN=main;Uid=wayne;Pwd=******;"

SQL_query = "SELECT * FROM content;"
Set RS = MyConn.Execute(SQL_query)
%>
<HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BASEFONT FACE="arial">
<BODY>

<% Response.Write SQL_query %>

<%while not RS.eof%>

this is driving me batty....	1	Jan 10, 2006
Recordset paging headache .....	0	Apr 24, 2007
Recordset paging headache .....	5	Apr 24, 2007
MySQL Connection String?	1	Feb 13, 2004
ASP & Database Connection Question	1	May 19, 2006
ASP + Format Dates from Database	0	Dec 21, 2003
Newbie, connection timing out problem	3	Oct 17, 2006
Database Connection Problem	1	Feb 6, 2004

Connection string for a MySQL database needed-this is driving me nuts!

Wayne...

[ + 2 0 r p 3 ]

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads