ASP and MYSQL

[janet]

hi

I am trying to form a connectivity with MySQL. I installed
mySQL from the net. I created a simple table and want to
show the same through asp.

I am writing the below script--->

<%
DIM SQL
DIM RSA
DIM BGC
ConnString = "Driver={MySQL};"
ConnString = ConnString & "Port=8888; "
ConnString = ConnString & "DATABASE=TEST; "
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open
BGC = "BDBDFF"
SQL = "SELECT * from trial"
set RSA = Server.CreateObject("ADODB.Recordset")
Set RSA = conn.Execute(SQL,,adCmdText)
If not RSA.EOF and not RSA.BOF then
Do while not RSA.EOF
Response.Write "<table>"
Response.Write "<tr>"
Response.Write "<td bgcolor=" & BGC & "> " & RSA.Fields
("name").Value & "</td>"
Response.Write "<td bgcolor=" & BGC & "> " & RSA.Fields
("age").Value & "</td>"
Response.Write "</tr>"
Response.Write "</table>"
RSA.MoveNext
loop
end if
%>

and i am getting the following error:
Technical Information (for support personnel)

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/testconnect.asp, line 9


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)

Page:
GET /myweb/testconnect.asp

can anyone tell me what wrong i have done with the
script ! I am giving the DSN name and have also specified
the driver.

thanks in advance!

[Alan]

Try looking at the syntax used for MySQL connections on this page:
[url]http://www.able-consulting.com/ADO_Conn.htm[/url]

Alan

"janet" <knowgroup@hotmail.com> wrote in message
news:012c01c362fa$b9008170$a001280a@phx.gbl...

> hi
>
> yah that was a silly mistake. But even after i added
> the "ConnString" it doesnt connect and still is giving
> exactly the same error?
>
> thanks

> >-----Original Message-----
> >You haven't associated your connection string with your

> connection:

> >
> >Try this:
> >
> >ConnString = ConnString & "DATABASE=TEST; "
> >Set Conn = Server.CreateObject("ADODB.Connection")
> >Conn.Open ConnString ' <------ Add ConnString here.
> >
> >Cheers,
> >
> >Alan
> >
> >
> >"janet" <knowgroup@hotmail.com> wrote in message
> >news:073201c362f4$d7b9dbd0$a501280a@phx.gbl...

> >> hi
> >>
> >> I am trying to form a connectivity with MySQL. I

> installed

> >> mySQL from the net. I created a simple table and want to
> >> show the same through asp.
> >>
> >> I am writing the below script--->
> >>
> >> <%
> >> DIM SQL
> >> DIM RSA
> >> DIM BGC
> >> ConnString = "Driver={MySQL};"
> >> ConnString = ConnString & "Port=8888; "
> >> ConnString = ConnString & "DATABASE=TEST; "
> >> Set Conn = Server.CreateObject("ADODB.Connection")
> >> Conn.Open
> >> BGC = "BDBDFF"
> >> SQL = "SELECT * from trial"
> >> set RSA = Server.CreateObject("ADODB.Recordset")
> >> Set RSA = conn.Execute(SQL,,adCmdText)
> >> If not RSA.EOF and not RSA.BOF then
> >> Do while not RSA.EOF
> >> Response.Write "<table>"
> >> Response.Write "<tr>"
> >> Response.Write "<td bgcolor=" & BGC & "> " & RSA.Fields
> >> ("name").Value & "</td>"
> >> Response.Write "<td bgcolor=" & BGC & "> " & RSA.Fields
> >> ("age").Value & "</td>"
> >> Response.Write "</tr>"
> >> Response.Write "</table>"
> >> RSA.MoveNext
> >> loop
> >> end if
> >> %>
> >>
> >> and i am getting the following error:
> >> Technical Information (for support personnel)
> >>
> >> 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/testconnect.asp, line 9
> >>
> >>
> >> Browser Type:
> >> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
> >>
> >> Page:
> >> GET /myweb/testconnect.asp
> >>
> >> can anyone tell me what wrong i have done with the
> >> script ! I am giving the DSN name and have also

> specified

> >> the driver.
> >>
> >> thanks in advance!
> >>

> >
> >
> >.
> >