-
Mysql 4.0.21 windows 2003
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
-
Which version of mdac do you have on that machine?
-
hi,
i am using MySQL ODBC Version MyODBC-3.51.11-2-win and MDAC Version - 2.8.1022.0
-
What is your query that you're trying to run?
-
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
-
Sounds like your query is returning 0 records, thus the update is invalid.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|