Hi I am running the latest versions of MySQL and MyODBC on my windows
200 webserver.
I am trying to connect to my database and pull out some simple data with
asp.
The code i am using is:
<%
dim db
dim strConn
dim rs
dim QueryStr
QueryStr = "SELECT * FROM imagedata"
strConn = "mediaSafe"
<!--Open the database-->
Set db = Server.CreateObject("ADODB.Connection")
db.open strConn, "web", "media1"
Set rs = Server.CreateObject("ADODB.Recordset")
set rs=db.execute(QueryStr)
if rs.eof then
response.write "RS EOF!"
else
response.write "NOT RS EOF!"
end if
%>
which works on my Access database, but it returns an empty recordset on
MySQL.
I have tried many different things, but cannot get the data out, yet if
I use an ODBC query tool, i can!
I really want to get this working!
Thanks in advance,
Craig
*********************************************************************
This e-mail and its contents are confidential and are for the
use of the intended recipient only. If you are not the
intended recipient, please notify the sender immediately.
The opinions, statements and thoughts expressed in this
email are only those of the individual sender.
*********************************************************************
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
