a2c
Starting Member
USA
32 Posts |
 Posted - 03/19/2018 : 17:59:14
Another question is what file actually contains the error message above?
Or any other error message(s) to saying about database connection?
|
Andy
ECT Moderator
95440 Posts |
Posted - 03/20/2018 : 01:16:42
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/20/2018 : 10:40:58
Godaddy doesn't come back yet...
Edited by - a2c on 03/20/2018 10:45:54
|
Sinbad
ECT Moderator
USA
65937 Posts |
Posted - 03/20/2018 : 11:19:35
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/20/2018 : 12:47:34
I made a simple connection test.
<!DOCTYPE html>
<html>
<body>
TEST</br>
<%
Dim Conn, DSNtest
Err.Clear
On Error Resume Next
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionTimeout = 10
DSNtest="DRIVER={SQL Server};SERVER=127.0.0.1;UID=xxxxxxxxxx;PWD=xxxxxxxxx;DATABASE=atsushiyamanaka"
Conn.open DSNtest
If Err.Number <> 0 Then
Response.Write (Err.Description& "<br><br>")
End If
On Error GoTo 0
Conn.Close
Response.Write("Hello World!")
%>
</body>
</html>
The result; [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error What can I do? |
Sinbad
ECT Moderator
USA
65937 Posts |
Posted - 03/20/2018 : 13:00:44
Hi can you show that to your host and ask them to check that the correct driver is installed and functioning correctly. Also find out if they can setup a test script of their own. quote:
Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
Winners never quit, quitters never win CSS and Responsive DesignsUser Manual for Ecommerce Templates |
a2c
Starting Member
USA
32 Posts |
Posted - 03/20/2018 : 17:56:08
yes they are working.
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/21/2018 : 20:32:44
I don't know what I did but now I can connect to my current(old) database from new VPS server and it's working!
So for security reason, I and the GoDaddy support will keep going to set my database in the same machine,
but so far we can see it's not much to do from software side.
Big MAHALO for all helps above!!
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/24/2018 : 19:07:20
Finally Godaddy support solved ;
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error.
What they did is;
enabling "System cryptography: Use FIPS compliant algorithms for encryption, hashing, and signing" in the Local Security Policy.
I don't know what it is tho...
But it made the system can't import the outside *.js or *.csv files.
So I had to get em all in one file and it's working now.
Thanks for all help!
|
Andy
ECT Moderator
95440 Posts |
Posted - 03/25/2018 : 00:29:04
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/31/2018 : 13:41:31
I didn't wanna come back here... I'm moving from GoDaddy VPS to other VPS for some reasons, I got similar problem above but more weird one. Testing.asp can connect to database with; "Driver={SQL Server}; Server=127.0.0.1; Database=fffdb; Uid=xxxxxxxx; Pwd=xxxxxxxx;" and db_conn_open.asp has same, but all the pages to connect to database giving 500. I understand it is obviously not software problem, it's some server configuration problem but I have no idea where it is. The "System cryptography: Use FIPS compliant algorithms for encryption, hashing, and signing" is enabled. What do anybody here think the difference between testing.asp and db_conn_ open.asp? |
Sinbad
ECT Moderator
USA
65937 Posts |
Posted - 03/31/2018 : 14:39:36
Hi can you ask the host or check in the IIS to disable friendly error messaging and enable detailed errors then you will see the real error that is occurring instead of the generic 500 internal server, and let us know what that is. Winners never quit, quitters never win CSS and Responsive DesignsUser Manual for Ecommerce Templates |
a2c
Starting Member
USA
32 Posts |
Posted - 03/31/2018 : 16:10:01
Thank you for quick res even weekend.
That is ;
The website cannot display the page
HTTP 500
Most likely causes:
•The website is under maintenance.
•The website has a programming error.
What you can try:
Refresh the page.
Go back to the previous page.
More information More information
This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.
For more information about HTTP errors, see Help.
|
Paradise
Ecommerce Template Guru
USA
1602 Posts Pre-sales questions only (More Details...)
|
Posted - 03/31/2018 : 16:15:13
That's the Generic error message .... you need find out what the actual error is.
Responsive Design Deals Ecomm Plus - ASP 6.8
www.paradiseclothingco.com
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/31/2018 : 16:44:09
Will you tell me how?
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/31/2018 : 17:17:41
I got this one;
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.
|
Sinbad
ECT Moderator
USA
65937 Posts |
Posted - 03/31/2018 : 17:38:05
|
a2c
Starting Member
USA
32 Posts |
Posted - 03/31/2018 : 17:47:38
yes
|
Sinbad
ECT Moderator
USA
65937 Posts |
Posted - 03/31/2018 : 18:13:10
Can you show the error to your, also click the link in the message and let them know what it says on that page, I suspect it may have to do with ASP not being installed correctly. quote:
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.
Winners never quit, quitters never win CSS and Responsive DesignsUser Manual for Ecommerce Templates |
Marshall
Ecommerce Template Guru
USA
1916 Posts |
Posted - 03/31/2018 : 18:46:38
I had a similar problem and it was because mod_security did not like the data that was being posted. The server logs said "URL detected as argument, possible RFI attempt detected." The host had to disable rule #340162 to resolve the issue. Not sure if this will help you.
Marshall
CENLYT Productions - ms designs
Affordable Web Design
Custom Ecommerce Designs
Responsive Websites
Cenlyt.com
|
| |
database migration