Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site
 All Forums
 Technical
 ASP (Windows server) versions
 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

42428 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

42428 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

42428 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

42428 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 »  
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2022 ecommercetemplates.com
This page was generated in 0.03 seconds. Snitz Forums 2000