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
 Getting Started and Pre-Sales
 Help with setup after host server crashed
Author « Topic »  

renixstore
New Member

USA
55 Posts

Posted - 08/18/2020 :  10:36:44  
My hosting company crashed.
I uploaded the backup of my Shopping cart to the new site.
I can not connect to cart, or Cart control panel.

Possible problems:
web.config is wrong?

I get:
(HTTP 500 Internal Server Error) when connecting to /vsadmin/login.asp

HTTP/1.1 New Application Failed when I run
http://www.renix-electronics.com/fpdb/test.asp

Any help appreciated


Vince
Administrator

42466 Posts

Posted - 08/18/2020 :  11:30:02  
quote:
Possible problems:
web.config is wrong?
I had a Google of the error and this came up a lot so it's possible. Try just renaming the web.config temporarily to see if the error changes. If that fails I really would get in touch with your host as it seems that ASP may not be starting up for some reason.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

renixstore
New Member

USA
55 Posts

Posted - 08/19/2020 :  07:06:23  
Vince,
When I rename the web.config file, I do get the
sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\xxxx\vsproducts.mdb;"

It is not clear what should be in the web.config file, or even where it should be.
I thought the hosting company created that?

Any help appreciated

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<system.webServer>
<httpErrors errorMode="Detailed" />
<asp scriptErrorSentToBrowser="true" />
</system.webServer>
<system.web>
<customErrors mode="Off" />
<compilation debug="true" />
</system.web>
</configuration>

Vince
Administrator

42466 Posts

Posted - 08/19/2020 :  08:37:19  
It looks like that web.config is just setting detailed error messages so if it is causing problems, just remove it. If you later need to set detailed error messages ask your host.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

renixstore
New Member

USA
55 Posts

Posted - 08/19/2020 :  10:52:55  
Vince, Thanks.
This is what the support person of the Hosting company tells me:

//=========================
I have enabled detailed error for ASP page and it is showing the following error message:

ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/vsadmin/inc/languagefile.asp, line 14

Can you let us know which type of database are you using? Also, can you let us know your connection string file?

Regards
//=============================================

I believe it is MS access database..

Where is the connection string file?

Any help appreciated

dbdave
ECT Moderator

USA
10276 Posts

Posted - 08/19/2020 :  11:16:07  
Hi, the connection string is in the db_conn_open.asp file in the vsadmin directory.

Please be sure your host has turned on classic asp, as by default some servers do not have that activated.
If the site was moved, it's quite possible the connection string needs to be updates, so it sounds like they may be on the right track.

Thanks,
David

Phil
ECT Moderator

United Kingdom
7621 Posts

Posted - 08/19/2020 :  11:28:09  
Hi,
There's some help here on setting up the database connection - https://www.ecommercetemplates.com/help/databases.asp



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*

*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

renixstore
New Member

USA
55 Posts

Posted - 08/19/2020 :  15:32:08  
Thanks Phil and others.

The hosting company got it working by:
"The issue has been resolved from the server side by enabling 32-bit applications for the application pool for your website in Plesk Panel."

I took me days to convince them that something on the server side was wrong.

Regards

Vince
Administrator

42466 Posts

Posted - 08/20/2020 :  03:23:44  
I'm very sorry about this but the documentation on that page is actually a bit out of date, and it would probably be better to use the 64 bit Access drivers. This would also mean that enabling 32 bit applications may not be necessary. The database connection string for the 64 bit drivers would be like this...
sDSN = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\web\database\vsproducts.mdb;"

I've updated the documentation now.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

renixstore
New Member

USA
55 Posts

Posted - 08/20/2020 :  06:23:36  
Vince,

If I use the new string, I guess I will brake the cart again. (Not that is functioning correct at this time)

I am having all kinds of trouble trying to reset the password.
Would it be possible / practical to get a fresh ASP 7.2.3 download from ECT, and start from scratch?
Then, from my backups, copy the images, products, and whatever else?

Any help appreciated

renixstore
New Member

USA
55 Posts

Posted - 08/20/2020 :  08:35:05  
OK.
In ../fpdb/test.asp
Replaced 32bit string
sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<%=server.mappath("vsproducts.mdb")%>;"

with 64bit string
sDSN = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<%=server.mappath("vsproducts.mdb")%>;"

---------------
Then
In ../vsadmin/db_conn_open.asp
sDSN = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=X:\..\fpdb\vsproducts.mdb;"

Then had to UNcheck the 32bit apps enable from the Host control panel.


Phil
ECT Moderator

United Kingdom
7621 Posts

Posted - 08/20/2020 :  09:04:35  
So is everything functioning now?



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*

*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

renixstore
New Member

USA
55 Posts

Posted - 08/20/2020 :  09:23:58  
Vince,

Would it be possible to a download of the full V7.2.3, to try and start with a fresh install?

For now, the only other option may be to go back to the original purchase of
6.xxx? and see if I can get that to work.
Then update to the latest..
I do not know how much trouble that will get me...

I have been at this now for days, and it just seems more spaghetti than it should be..
The updates I purchased are just updates, so not do-over possible.

Any help appreciated

Vince
Administrator

42466 Posts

Posted - 08/20/2020 :  09:33:38  
Hi Renixstore
I don't mind at all if it will help, but there really is nothing in the full install that isn't in the updater. Given that your products etc are already defined it would be so much simpler to just get this working, and most of the time it's something simple. What I would do is just post again with any error you are getting and we'll help you. If you want the full install just send me an email with the template details.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

renixstore
New Member

USA
55 Posts

Posted - 08/20/2020 :  12:12:42  
All that helped, thanks!

It now it works, but I don't know why.
I didn't change a thing, other ask host to check on DB RD/WR setting.

I asked the hosting company if they changed something, so I wait to hear from them...…
  « 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