problem with cloning a product

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I receive an error message below (in red) when I tried to clone any products from admin.
But I can add, edit and delete products from admin. So I guess this is not a database connection issue. If anyone has suggestions, please advise.
You are receiving this message because the system is not able to connect to the database. Please take the following steps: 

(1) If you are using MS Access: reset permissions on the database file. The database file must have Read/Write access. 

(2) MS Access and MS SQL: Make sure that the database connection string is correct. To test it, use the ProductCart Setup Wizard, even if you have already setup and activated the shopping cart. Consult the ProductCart User Guide for examples of connection strings that you may use with ProductCart. 

(3) If you are using a DSN connection, make sure that the name of the connection is correct, and that it is pointing to the right file. To do so, you will have to check the settings on your Web server. Many Web hosting companies allow you to do this through an administration panel. In other cases, you will have to contact the hosting company.
(4) If you are using a MS SQL database, make sure that you can access the SQL server and that the user that is listed in your database connection strings has ownership rights on the database (it must be a database owner or "DBO"). For more information, please contact your Web hosting company. 

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Espressotec Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 10-August-2007 Location: Canada Status: Offline Points: 0	Post Options Post Reply Quote Espressotec Report Post Thanks(0) Quote Reply Topic: problem with cloning a product Posted: 07-April-2010 at 3:31pm
	I receive an error message below (in red) when I tried to clone any products from admin. But I can add, edit and delete products from admin. So I guess this is not a database connection issue. If anyone has suggestions, please advise. You are receiving this message because the system is not able to connect to the database. Please take the following steps: (1) If you are using MS Access: reset permissions on the database file. The database file must have Read/Write access. (2) MS Access and MS SQL: Make sure that the database connection string is correct. To test it, use the ProductCart Setup Wizard, even if you have already setup and activated the shopping cart. Consult the ProductCart User Guide for examples of connection strings that you may use with ProductCart. (3) If you are using a DSN connection, make sure that the name of the connection is correct, and that it is pointing to the right file. To do so, you will have to check the settings on your Web server. Many Web hosting companies allow you to do this through an administration panel. In other cases, you will have to contact the hosting company. (4) If you are using a MS SQL database, make sure that you can access the SQL server and that the user that is listed in your database connection strings has ownership rights on the database (it must be a database owner or "DBO"). For more information, please contact your Web hosting company.
	Espressotec Sales and Services

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 07-April-2010 at 3:36pm
	Some customization to your product admin may have a problem. You will need to comment out the "on error resume next" at the top of /includes/opendb.asp and /youradmin/adminv.asp. After making those edits, try clone again. whatever is choking should become evident.

Espressotec Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 10-August-2007 Location: Canada Status: Offline Points: 0	Post Options Post Reply Quote Espressotec Report Post Thanks(0) Quote Reply Posted: 13-April-2010 at 12:25pm
	We located a file which had an error. Thank you so much!
	Espressotec Sales and Services