Upsize Access to MSsql error

Author	« Topic »
cooper Ecommerce Template Guru USA 2807 Posts Pre-sales questions only (More Details...)	Posted - 10/24/2017 : 18:15:58 Just upsized my access database to MSsql and my home page is now giving me the following error: error '80020009' /vsadmin/inc/languagefile.asp, line 16 Any ideas what step I might have missed? Cooper
dbdave ECT Moderator USA 10406 Posts	Posted - 10/24/2017 : 18:50:33 Did you alter your includes file to show that you are on an sql database? I bet that's it. If using the ect script, I think the info is there. I can look at my setting or try to find it here, but I am guessing you missed that step. David ECT Power User
cooper Ecommerce Template Guru USA 2807 Posts Pre-sales questions only (More Details...)	Posted - 10/25/2017 : 11:09:15 Thanks, Dave. I have "sqlserver=true" in the INCLUDES file and have FTP'd it to the site. Still no luck. Cooper
Sinbad ECT Moderator USA 65937 Posts	Posted - 10/25/2017 : 11:15:24 Hi Cooper, can you let us know what you have on line 16 of /vsadmin/inc/languagefile.asp the other thing to try is replace the languagefile.asp with <!--#include file="languagefile_en.asp"--> on the home page and see if that helps. Winners never quit, quitters never win CSS and Responsive Designs User Manual for Ecommerce Templates
Andy ECT Moderator 95440 Posts	Posted - 10/26/2017 : 00:03:21 Hi Bill Do you have this working now? Andy Please feel free to review / rate our software
cooper Ecommerce Template Guru USA 2807 Posts Pre-sales questions only (More Details...)	Posted - 10/26/2017 : 09:44:23 Changed the Language file and now I get: error '80020009' /vsadmin/inc/incfunctions.asp, line 70 Cooper
Andy ECT Moderator 95440 Posts	Posted - 10/26/2017 : 10:09:55 When you used the sql wizard you received from us - did you get a success message after upsizing the database through the browser updatestore.asp file? Andy Please feel free to review / rate our software
cooper Ecommerce Template Guru USA 2807 Posts Pre-sales questions only (More Details...)	Posted - 10/27/2017 : 17:56:16 Andy, I did the "Install Ecommerce Plus" and get all sorts of errors. So I then installed it wiping prior versions and didn't get any errors. Tonight I deleted the MSSQL database and created a new one. I got no errors and I am still getting the error messages when I browse to the site. Cooper
Andy ECT Moderator 95440 Posts	Posted - 10/27/2017 : 23:56:56 Would you like to send me on your FTP details, is this a site with your products in the Access database or a completely new install? Andy Please feel free to review / rate our software
cooper Ecommerce Template Guru USA 2807 Posts Pre-sales questions only (More Details...)	Posted - 10/28/2017 : 06:49:08 Thanks, Andy. Just sent the FTP details. I was a site with an Access database with 1,900 products in it. I am certain it is user error. I did this for another site without an issue. Cooper
Andy ECT Moderator 95440 Posts	Posted - 10/28/2017 : 10:01:26 I have the details but should have also asked, what version is the store on do you know? Andy Please feel free to review / rate our software
Andy ECT Moderator 95440 Posts	Posted - 10/28/2017 : 10:37:39 Ignore that, I see it is 6.7.1 Andy Please feel free to review / rate our software
	« Topic »