since i've not done much with blobs, i hesitate to respond, but since nobody else has, maybe some observations might help.
first of all, you're coding to an oledb provider, but specifying an odbc driver. you can use both if you feed the provider from the driver. otherwise, you need to use one or the other. if the microsoft documentation is not clear, take a look at corereader's documentation http://corereader.com/document.htm i sure don't know that i did a better job than macrosoft, but maybe it'll help. but at least you can be certain that i'm not trying to confuse you to make money from you. i notice also that you've not positioned the cursor in your code. insure that you're pointing to a record before you try an update. i notice also that you've not declared a cursor to the odbc driver. the mysql driver gave me some problems when i first started using it because i sometimes needed to declare a client side cursor. you might fiddle with that. step back and look at what your code is doing. hope that this helps some. > > > > > 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 > > -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ --------------------------------------------------------------------- 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
