Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Changed SQL server IP, now forum doesn't work
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Changed SQL server IP, now forum doesn't work

 Post Reply Post Reply
Author
garp2100 View Drop Down
Newbie
Newbie
Avatar

Joined: 15 August 2006
Location: United States
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote garp2100 Quote  Post ReplyReply Direct Link To This Post Topic: Changed SQL server IP, now forum doesn't work
    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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
garp2100 View Drop Down
Newbie
Newbie
Avatar

Joined: 15 August 2006
Location: United States
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote garp2100 Quote  Post ReplyReply Direct Link To This Post 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!
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.