Changed SQL server IP, now forum doesn't work
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24519
Printed Date: 06 April 2026 at 1:38pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Changed SQL server IP, now forum doesn't work
Posted By: garp2100
Subject: Changed SQL server IP, now forum doesn't work
Date Posted: 26 September 2007 at 9:21pm
Hello Everyone, recently we switched ISP's and we changed our static IP address, I replaced the new onewith the old one in the "database_connection.asp" file, specifically in the line that goes:
strSQLServerName = "0.0.0.0,port number" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
After doing so, whenever I want to send a private message or whenever I want to post a reply to a forum I get the following error message.
"Server Error in Forum Application
An error has occured while sending an email.
Please contact the forum administrator.
Support Error Code:- err_SQLServer_send_mail_footer
File Name:- functions_send_mail.asp
Error details:-
CDO.Message.1
The transport failed to connect to the server."
The only thing I could find in the "functions_send_mail.asp" related to the error message was on the MS CDOSYS block of code where there's a line that goes:
"If LCase(strMailServer) = "localhost" OR strMailServer = "http://127.0.0.1" OR strMailServer = "127.0.0.1" Then
intSendUsing = 1
Else
intSendUsing = 2
End If"
I've tried changing the strMailServer variable to the new IP address or the actual mail server name with no success. I appreciate any help.
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 27 September 2007 at 8:32am
The problem is that the forum is unable to connect to the mail server to send emails.
Check in the admin area that the settings are correct for sending emails.
You may also want to upgrade to version 9 as it has extra selections for sending email with CDOSYS and also has a test button on the email settings page to check that the email setting have been entered correctly.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: garp2100
Date Posted: 27 September 2007 at 3:49pm
|
Went into the email setting and changed the IP address there, works like a charm...Thank you boRg for your prompt response and help!
|
|