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
|
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
|
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
|
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
|
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
|
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 SoftwareClick Here to sign up for our newsletterClick 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...…
|
|
|