Hi, mysql

I want to put a image into mysql database,but when I run program listed below

<%
formsize=Request.TotalBytes
formdata=Request.BinaryRead(formsize)

set rs=server.CreateObject("adodb.recordset")
strconn="driver={mysql};dbq="&server.MapPath("test.mdb")&";uid=root;pwd=l05m;"
sql="SELECT * FROM imgtable"
rs.Open sql,strconn,1,3

rs.AddNew
rs("img").appendchunk formdata
rs.Update
rs.Close
%>

the system says:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC Drivers can't support this attribute
/upload.asp, line 7


I want to know what is the problem.
I have the Mysql 3.23.52-max-nt, ODBC2.50, windows XP and ASP.

Can anyone help?

Regards,
luoya


_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail


---------------------------------------------------------------------
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

Reply via email to