Mysql 4.0.21 windows 2003

[sachinonnet]

hi,

i am using mysql with asp.. i creaetd dsn for the same with root permission.
i am getting below error

DSN=dcart;

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Invalid string or buffer length

/shop/admin/content/catalog/products/edit/1.asp, line 37

if i change connection string to below i am getting diffrent error.

connection string = "driver={MySQL ODBC 3.51 Driver};server=localhost;uid=root;pwd=;database=dc art;Option=3"

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Query-based update failed because the row to update could not be found.

/shop/admin/content/catalog/products/edit/1.asp, line 37

[rmiao]

Which version of mdac do you have on that machine?

[sachinonnet]

hi,

i am using MySQL ODBC Version MyODBC-3.51.11-2-win and MDAC Version - 2.8.1022.0

[Rawhide]

What is your query that you're trying to run?

[sachinonnet]

i am simply Updating table record with Recordset object..

if error_id = 0 then
set rsProduct = server.createobject("ADODB.recordset")
strSQL = "SELECT * FROM products WHERE product_id = " & pid

rsProduct.open strSQL, adoCon, 2, 2
rsProduct("product_name") = product_name
rsProduct("product_cat_id") = product_cat_id
rsProduct("product_manufacturer_id") = product_man_id
rsProduct("product_price") = product_price
rsProduct("product_image") = product_img
rsProduct("product_link") = product_url
rsProduct.update()

rsProduct.close
set rsProduct = nothing

response.redirect("?p=" & request.querystring("p") & "&action=edit&step=2&pid=" & pid)
end if

[Rawhide]

Sounds like your query is returning 0 records, thus the update is invalid.