Hi,
I want to put a image into mysql,but when I run program listed below
<%
formsize=Request.TotalBytes
formdata=Request.BinaryRead(formsize)
Dim mycon
set mycon=server.createobject("adodb.Connection")
mycon.mode=adModeReadWrite
mycon.connectionString="DSN=ez;UID=aa;PWD=bb"
mycon.open "ez"
set rs=Server.CreateObject("adodb.Recordset")
sql = "SELECT * from dxlxtk where id=1"
rs.open sql, mycon,1,3
rs("picture").appendchunk formdata
rs.Update
rs.Close
%>
the system says:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] invalid character string or buffer length
dxtpcl.asp, line 12
I want to know what is the problem.
I have the Mysql 3.23.52-max-nt and windows XP and ASP.
Can anyone help?
Regards,
Thanks
lifang
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus
---------------------------------------------------------------------
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