Working on with Mangage Product Page

To manage products, I have decided to create a manage product page on which there are links to the add product page and update product page.

Mange product page will show the list of product in the database and it has links with each product to the update product page.

Update product page will allow changing any product details or deleting any product details.

Add product page will simply bring a add product form to add a new product. After each addition or update of product, confirmation message will be shown on the manage product page.

Error message 1:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/phr004/coursework1/manageproducts.asp, line 102

Error message 2:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'product_id='.

/phr004/coursework1/updateProduct.asp, line 13

Solution:

Above two error messages are from the manageproduct.asp page and updateproduct.asp page. I fixed the problem by creating the correct dsn and pointing it right to the Access Database file on the server.

Open DSN Connection:

Set dsnCon = Server.CreateObject("ADODB.Connection")

dsnCon.Open "dsn=phr004cw1;uid=phr004;pwd=ce95099wi;"