https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 13:41:03 +0000 Thu, 27 Sep 2007 15:49:14 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24519 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/changed-sql-server-ip-now-forum-doesnt-work_topic24519_post128086.html#128086 Author: garp2100
Subject: 24519
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!]]> Thu, 27 Sep 2007 15:49:14 +0000 https://forums.webwiz.net/changed-sql-server-ip-now-forum-doesnt-work_topic24519_post128086.html#128086 https://forums.webwiz.net/changed-sql-server-ip-now-forum-doesnt-work_topic24519_post128082.html#128082 Author: WebWiz-Bruce
Subject: 24519
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.
]]> Thu, 27 Sep 2007 08:32:30 +0000 https://forums.webwiz.net/changed-sql-server-ip-now-forum-doesnt-work_topic24519_post128082.html#128082 https://forums.webwiz.net/changed-sql-server-ip-now-forum-doesnt-work_topic24519_post128078.html#128078 Author: garp2100
Subject: 24519
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.
]]> Wed, 26 Sep 2007 21:21:05 +0000 https://forums.webwiz.net/changed-sql-server-ip-now-forum-doesnt-work_topic24519_post128078.html#128078