mediator
Ecommerce Template Expert
United Kingdom
663 Posts Pre-sales questions only (More Details...)
|
 Posted - 06/07/2019 : 11:51:54
I have had to transfer my domain over to another account to be able to gain an SSL ( which i have not set up yet ) with fashosts
before I did this I backed up all the files and DB, the DB was actually backup up to a DB that was already on the new account and it all worked fine
now it's transfered over and I'm seeing nothing, fast host claim they can see a DB error but im just getting browser message saying its cant find pages
can you see anything on www.snuff.me.uk
its asp files running with mysql DB , its on windows platform
i cant even get the ftp to work
|
Andy
ECT Moderator
95440 Posts |
Posted - 06/07/2019 : 12:04:48
|
mediator
Ecommerce Template Expert
United Kingdom
663 Posts Pre-sales questions only (More Details...)
|
Posted - 06/07/2019 : 12:08:21
Hi this was the original working connection
<%
DIM sDSN
sDSN = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=*******;DATABASE=*******;UID=*******;PWD=*******;OPTION=16427"
%>
Fasthost told me to change it to
<%
Dim sConnection, objConn
sConnection = "Driver={MySQL ODBC 5.3 UNICODE Driver};
Server=*******;
Database=*******
Uid=*******;
Password=*******;
Option=3"
Set objConn=Server.CreateObject("ADODB.connection")
objConn.Open(sConnection)
%>
But that doesnt work either
|
mediator
Ecommerce Template Expert
United Kingdom
663 Posts Pre-sales questions only (More Details...)
|
Posted - 06/07/2019 : 12:10:31
sqlserver is set to true,I have being using the sql db for years
|
mediator
Ecommerce Template Expert
United Kingdom
663 Posts Pre-sales questions only (More Details...)
|
Posted - 06/07/2019 : 12:23:13
the only thing i can see different from the scripting is that when it was running before I transferred it over
ASP Net 4.5 also php 5.2 ( which is not used )
New scripting is
ASP Net 4.6 also php 7.2 ( which is not needed )
would this be the reason ?
|
Andy
ECT Moderator
95440 Posts |
Posted - 06/07/2019 : 12:23:47
|
mediator
Ecommerce Template Expert
United Kingdom
663 Posts Pre-sales questions only (More Details...)
|
Posted - 06/07/2019 : 12:47:36
MySQL
|
Andy
ECT Moderator
95440 Posts |
Posted - 06/07/2019 : 13:28:34
|
mediator
Ecommerce Template Expert
United Kingdom
663 Posts Pre-sales questions only (More Details...)
|
Posted - 06/07/2019 : 13:40:32
which is the correct setting ?
<%
DIM sDSN
sDSN = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=*******;DATABASE=*******;UID=*******;PWD=*******;OPTION=16427"
%>
Fasthost told me to change it to
<%
Dim sConnection, objConn
sConnection = "Driver={MySQL ODBC 5.3 UNICODE Driver};
Server=*******;
Database=*******
Uid=*******;
Password=*******;
Option=3"
Set objConn=Server.CreateObject("ADODB.connection")
objConn.Open(sConnection)
%>
ALSO does it matter if the scripting has 4.6 rather than the 4.5 ?
Edited by - mediator on 06/07/2019 13:43:25
|
mediator
Ecommerce Template Expert
United Kingdom
663 Posts Pre-sales questions only (More Details...)
|
Posted - 06/07/2019 : 14:25:38
Ok so I switched it back over to my old account luckily it was still active!
the site is working again, so it seems the software doesn't work on scripting asp 4.6 im running V v7.0.4 - Should it ?
I do need to move it over again at some point so i can get an SSL assigned
Cheers
Jamie
|
insight
ECT Moderator
USA
4476 Posts |
Posted - 06/07/2019 : 14:40:49
Something like this should work based on what's been written here: <%
DIM sDSN
sDSN = "Driver={MySQL ODBC 5.3 UNICODE Driver};Server=XXXXXX;Database=XXXXXX;User=XXXXXX;Password=XXXXXX;Option=16427;"
%> and you need mysqlserver=true in your includes file (not sqlserver=true as indicated earlier) ASP.NET version is immaterial as you don't even use it with your cart, you can turn that (and PHP) off completely for all the difference it makes. https://servelink.com/clients/index.php?rp=/knowledgebase/33/What-SQL-database-connection-string-do-you-recommend.html Peter  Professional ecommerce web hosting services Ecommerce Templates specialists since 2003 https://servelink.com |
stevep
Advanced Member
USA
182 Posts Pre-sales questions only (More Details...)
|
Posted - 06/18/2020 : 13:05:25
I've just changed hosts to ServeLink, not live yet due to DNS not yet registered. I did see one setting I have a question about - does the ECT template require ASP.net? In the web scripting & statistics settings in the control panel it provides the ability to check CGI support, Microsoft ASP support, Microsoft ASP.net support and the ability to choose a version, and custom error documents. I checked all except ASP.net - are these the correct choices? I'm using ASP v7.2.2.
Thank you,
Steve
|
insight
ECT Moderator
USA
4476 Posts |
Posted - 06/18/2020 : 13:10:40
No, ASP.NET is not used or required. The default settings you receive are fine, so if you put it back the way it was you'll be good to go. Generally speaking, checking things that you don't need is bad policy and just increases your attack surface. Peter Professional ecommerce web hosting services Shared hosting Windows & Linux | Dedicated servers | Domains | SSL Ecommerce Templates specialists since 2003 https://servelink.com |
stevep
Advanced Member
USA
182 Posts Pre-sales questions only (More Details...)
|
Posted - 06/18/2020 : 14:00:28
Many thanks, just unchecked them all and saved.
Steve
|
dbdave
ECT Moderator
USA
10272 Posts |
Posted - 06/18/2020 : 14:10:26
Don't uncheck "Microsoft ASP support" or your site will not work.  quote:
just unchecked them all and saved
David |
stevep
Advanced Member
USA
182 Posts Pre-sales questions only (More Details...)
|
Posted - 06/19/2020 : 05:17:51
Wow thanks for the followup Dave, the default was all unchecked, I hope no other surprises. It's not been an intuitive transition.
Steve
|
insight
ECT Moderator
USA
4476 Posts |
Posted - 06/19/2020 : 10:11:42
quote:
the default was all unchecked
Actually, the default is Microsoft ASP support & Custom error documents both checked and that serves for ECT users without any further attention, which is why we have it that way  . There isn't much demand for the other stuff from here. Peter Professional ecommerce web hosting services Shared hosting Windows & Linux | Dedicated servers | Domains | SSL Ecommerce Templates specialists since 2003 https://servelink.com
|
| |
|
Need some help