Wrox Programmer Forums
|
ASP CDO As of Oct 5, 2005, this forum is now locked. No posts have been deleted. Please use "Classic ASP Professional" at: http://p2p.wrox.com/forum.asp?FORUM_ID=56 for discussions similar to the old ASP Pro Code Clinic or one of the other many remaining ASP and ASP.NET forums here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP CDO section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 20th, 2004, 01:56 PM
Authorized User
 
Join Date: Apr 2004
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default Fields update failed

I just setup the default SMTP virtual server on my testing server to test my mail scripts using CDO.

I recieve the following error when testing a mail script:
"Fields update failed. For further information, examine the status property of individual field objects."

Is anyone familiar with this error message? I know the mail script works because tested the script on remote production server and it runs fine. So, my assumption is either I have configured something incorrectly with the SMTP server? I'm not sure what to check?

Here is the code for the script:
<%
sch = "http://schemas.microsoft.com/cdo/configuration/"
mailbody = "" & "<strong>" & Request.Form("name") & " " & " has sent the following request:" & "</strong>" & "" & "<br>" & "<br>"
mailbody = mailbody & "" & "Email: " & Request.Form("email") & "<br>" & "<br>" & "Site URL: " & Request.Form("siteURL") & "<br>" & "<br>" & "Phone Number: " & Request.Form("phone") & "<br>" & "<br>" & "Subject: " & Request.Form("subject") & "<br>" & "<br>" & "Message: " & Replace(Request.Form("message"), VbCrLf, "<br>") & ""

Set cdoConfig = CreateObject("CDO.Configuration")

With cdoConfig.Fields
.Item(sch & "sendusing") = 25 ' cdoSendUsingPort
.Item(sch & "smtpserver") = "dwayne-server"
.update
End With

Set cdoMessage = CreateObject("CDO.Message")

With cdoMessage
Set .Configuration = cdoConfig
.From = "[email protected]"
.To = "[email protected]"
.Subject = "Dwayne-Epps-website-response"
.HTMLBody = mailbody
.Send
End With

Set cdoMessage = Nothing
Set cdoConfig = Nothing
%>

I'm wondering if the problem could be a firmware upgrade needed for the router related to the port forwarding not working properly?

If anyone has encountered the above error ans has any suggestions, it would be appreciated. Thank you.
-Dman100-

 
Old September 20th, 2004, 09:45 PM
Authorized User
 
Join Date: Apr 2004
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This doesn't appear to be a CDO problem. I think this is a SMTP configuration problem or my ISP is blocking port 25.

I am trying to troubleshoot the problem. I was trying to connect to my server via telnet, but I'm not very knowledgeable with telnet.

I was trying: (replacing hostname with dwayne-server) my server name.
telnet hostname 25
it returns "connection lost"

I'm not sure if that means my ISP is blocking port 25 or what?

If anyone knows how I can troubleshoot my SMTP configuration to determine where the problem is, please let me know.

Oh, and I did try dropping a simple text file into the SMTP pickup folder to see if it would deliever to my email, but it immediately went to the badmail folder.

I'm at a loss?

-Dman100-

 
Old September 21st, 2004, 04:43 PM
Authorized User
 
Join Date: Apr 2004
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, it took several days and a bottle of Excedrin, but I finally got it working. Thanks.
-Dman100-

 
Old August 25th, 2005, 12:13 AM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 198
Thanks: 2
Thanked 0 Times in 0 Posts
Send a message via MSN to itHighway
Default

Oh man! how you resolve this problem? I am having same problem with my email script.

Regards
Zeeshan Ahmed






Similar Threads
Thread Thread Starter Forum Replies Last Post
Failed to update database cothedo BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 4 July 29th, 2008 12:14 PM
Wrox Survey Failed to update database beginer_1 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 April 6th, 2007 01:32 PM
Failed to update database edison7 ASP.NET 2.0 Basics 1 June 22nd, 2006 08:54 AM
update a fields value Vince_421 Access VBA 2 May 19th, 2006 06:41 AM
Update Table fields karajian Access VBA 2 December 7th, 2004 03:48 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.