Error when trying to upsize Access database

Author	« Topic »
cooper Ecommerce Template Guru USA 2807 Posts Pre-sales questions only (More Details...)	Posted - 12/03/2019 : 05:15:41 https://img.hostek.net/i/5cd1dba33c9bc91968f5 Any idea what may cause this error when attempting to upsize my Access database to MS SQL? Cooper
Vince Administrator 42874 Posts	Posted - 12/03/2019 : 05:36:44 Hi Bill Are both the Access databse and the SQL Server upsizing script on the same ECT version? It looks like you are using the script on an Access DB version pre-abandoned cart emails. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
cooper Ecommerce Template Guru USA 2807 Posts Pre-sales questions only (More Details...)	Posted - 12/03/2019 : 05:42:24 Thanks for the quick reply, Vince. I just reverted back to the back up of the Access database to bring the store back up. Access is running Ecommerce PlusASP v7.1.3. I'm using the V6.7x updatestore.asp file. Cooper
Vince Administrator 42874 Posts	Posted - 12/03/2019 : 07:29:27 Hi Bill quote: I'm using the V6.7x updatestore.asp file. But why use such an old version of the SQL Server script? Don't you have a more up-to-date copy? Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
cooper Ecommerce Template Guru USA 2807 Posts Pre-sales questions only (More Details...)	Posted - 12/03/2019 : 08:42:41 Purchased yesterday. Didn't see the updated one in the zip. Cooper
Vince Administrator 42874 Posts	Posted - 12/04/2019 : 01:06:54 I've just sent Bill an updated version by email, but if anyone else has this problem it seems the scripts had been overwritten by an older version. I've updated it now and if anyone has problems I'll send you a new copy. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
cooper Ecommerce Template Guru USA 2807 Posts Pre-sales questions only (More Details...)	Posted - 12/04/2019 : 06:14:28 Got it, Vince. I uploaded the correct file and ran it again. Still getting: Starting creating database tables. This can take some time so please don't refresh. Processing Table: abandonedcartemail Upsizing table abandonedcartemail Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'abandonedcartemail'. /updatestore.asp, line 189 Cooper
Vince Administrator 42874 Posts	Posted - 12/04/2019 : 07:47:53 Hi Bill quote: Access is running Ecommerce PlusASP v7.1.3. Are you upsizing only rather than creating the SQL Server Database? If so, what version is the SQL Server database on? The line of the error it is trying to clean out the abandonedcartemail table but it seems it doesn't exist. If the SQL Server database were on v7.0 or v7.1 it would exist. If the SQL Server database is on a previous version you can either use an older version of the upsize script or just run the regular updatestore script on it to bring the database up to date. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
cooper Ecommerce Template Guru USA 2807 Posts Pre-sales questions only (More Details...)	Posted - 12/04/2019 : 10:20:13 Vince, Thanks for the support and the follow-up. Late night and bleary eyes didn't help last night. Once I got the correct download, I created the SQL database, upsized the Access database and then updated the store to the latest version of the shopping cart and it is all working like a charm now! Thank you for your help!!! Bill Cooper
	« Topic »