a2c
Starting Member
USA
32 Posts |
 Posted - 03/16/2018 : 13:32:57
Hi,
I've got server moved and database also.
But the database seems not connected.
When I go to proddetail.asp,
An error occurred on the server when processing the URL. Please contact the system administrator.
If you are the system administrator please click here to find out more about this error.
The server support said,
This issue appears to be related to your connection string not using a provider or method that supports TLS 1.1 or TLS 1.2. You or your web developer will need to update the connection string to one that works using one of the previously mentioned versions of TLS.
Is there any "connection string" using TLS1.0?
If so, where?
|
Sinbad
ECT Moderator
USA
65937 Posts |
Posted - 03/16/2018 : 13:49:24
Hi A2c, no the database connection for ASP with microsoft access will use windows drivers to connect. Is this a access database or sql or mysql database that you are trying to connect to, and who is the site hosting with. Winners never quit, quitters never win CSS and Responsive DesignsUser Manual for Ecommerce Templates |
a2c
Starting Member
USA
32 Posts |
Posted - 03/16/2018 : 13:55:20
I'm using MS SQL.
And new server is VPS at GoDaddy.
So, if no TLS to connect, what is the problem you think?
|
Sinbad
ECT Moderator
USA
65937 Posts |
Posted - 03/16/2018 : 14:15:42
Hi when you move the database to a new server the database connection has to be changed to reflect the new location, can you paste here what you have in the vsadmin/db_conn_open.asp X out the username and password credentials. Winners never quit, quitters never win CSS and Responsive DesignsUser Manual for Ecommerce Templates |
a2c
Starting Member
USA
32 Posts |
Posted - 03/16/2018 : 17:31:28
sDSN = "Driver={SQL Server}; Server=127.0.0.1; Database=atsushiyamanaka;
|
Andy
ECT Moderator
95440 Posts |
Posted - 03/16/2018 : 23:53:21
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/17/2018 : 15:39:14
Thank you for back.
Yes they said the IP is correct. Also the IP address for the server 132.148.84.165 should work.
include.asp in both vsadmin and fvsfadfmin have the line sqlserver=TRUE.
The godaddy support is asking the exact detail of the requirement for the ecommerce template (v6.7.4)
And also for "Custom Air Message" which I don't know what it is.
|
Andy
ECT Moderator
95440 Posts |
Posted - 03/18/2018 : 01:01:03
There shouldn't be any special requirements and I haven't come across the term "custom air message". Could it be something in the web.config file - do you have one and if so, can you temporarily rename it to check? Andy Please feel free to review / rate our software |
a2c
Starting Member
USA
32 Posts |
Posted - 03/18/2018 : 12:18:09
I found out she was talking about "custom ERROR message". the data/web.config file has; <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
how to change it to show error detail? |
Andy
ECT Moderator
95440 Posts |
Posted - 03/18/2018 : 12:40:07
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/18/2018 : 14:56:58
Thank you Andy,
I got some different messages.
I'll get back here when I found something.
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/18/2018 : 15:52:17
IE gave me almost same information with simple 500, but Chrome said "HTTP/1.1 New Application Failed".
And surprisingly find out it is not related to database connection, but all the files in /shop directory,
gave this same message even like /shop/termsandconditions.asp which never touch database.
So, will you please help me again?
|
Sinbad
ECT Moderator
USA
65937 Posts |
Posted - 03/18/2018 : 21:26:55
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/18/2018 : 21:40:31
Thank you for back Sinbad.
Plesk Hosting setting set Microsoft ASP support checked.
Edited by - a2c on 03/18/2018 21:41:24
|
Andy
ECT Moderator
95440 Posts |
Posted - 03/19/2018 : 01:00:26
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/19/2018 : 13:29:57
They said the hosting setting is ok for classic ASP. And no more error message "New Application Failed" by changing web.config file to; <asp scriptErrorSentToBrowser="true"/> comment out. Now it's problem to connect database again. Only the pages need to connect database show the page title and logo and; An error occurred on the server when processing the URL. Please contact the system administrator.
If you are the system administrator please click here to find out more about this error. error message. What anything I can do next? |
a2c
Starting Member
USA
32 Posts |
Posted - 03/19/2018 : 14:30:10
I'm asking GoDaddy support to connect database and waiting their reply.
I'll be back if I got what was cause.
Big appreciate for all helps above.
|
Sinbad
ECT Moderator
USA
65937 Posts |
Posted - 03/19/2018 : 14:32:01
Hi it may not be the database connection can you try creating a hello world asp page copy the following into a blank page name it testing.asp upload testing.asp to the server then browse to the page and you should see hello world. If you see any other message contact your host and give them a link to the page. <!DOCTYPE html> <html> <body> <% Response.Write("Hello World!") %> </body> </html> Winners never quit, quitters never win CSS and Responsive DesignsUser Manual for Ecommerce Templates |
a2c
Starting Member
USA
32 Posts |
Posted - 03/19/2018 : 16:26:00
It works.
Will you make something like that but test the database connection?
|
Paradise
Ecommerce Template Guru
USA
1602 Posts Pre-sales questions only (More Details...)
|
Posted - 03/19/2018 : 17:19:45
That was to test the connection .....
Responsive Design Deals Ecomm Plus - ASP 6.8
www.paradiseclothingco.com
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/19/2018 : 17:51:47
Hi Paradise,
Thank you for the res.
I mean connect to the database and try to get the table list or something in Sql,
and get some error message if not able to connect.
|
| |
database migration