Hi Craig,
You can give the following a try which does give you direct access to MySQL
from ASP skipping the slower ODBC and is almost code compatible with your
code:
http://www.scibit.com/MySQLX
or
MyVBQL on the mysql API/contrib pages
Regards
Jacques
http://www.scibit.com
http://www.scibit.com/MySQL
http://www.scibit.com/Mascon
> -----Original Message-----
> From: Craig Atkins [mailto:[EMAIL PROTECTED]]
> Sent: 19 March 2001 15:39
> To: '[EMAIL PROTECTED]'
> Subject: Problem with MySQL & ASP
>
>
> 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
>
>
---------------------------------------------------------------------
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
