Search results for query: *

django, You are right, I left a critical piece out of the code I wrote here (I didn't copy and paste the actual code, but just wrote psuedo code here that would be simpler and more understandable to someone without knowledge of our real structure). The initial lock update query is actually...

We have about 1000 client machines that need regular processing performed, which is done by a bank of 20 servers. We have a table that lists all the client ids, a flag that indicates whether they need processing, and field indicating which server is currently working with that client. A client...

Does anyone know of any other ways to send email through .Net that doesn't use the built-in System.Web.Mail I was thinking I could try another mailing technique and see if that fixes the problem. Thanks

Well, add to the weirdness... I thought the only thing different between running the code straight through and breaking it between hours was the amount of time. So before the "Next mTemplateHour" line, I put a line to wait for 5 seconds "Sleep (5000)". Ran it straight through and it sent the...

Alright, I stepped through the code, going farther each time. I have reached a point where I can replicate the error, but this makes no sense whatsoever! Look for the For loop at the top of the Template_Picker code: For mTemplateHour = 1 To 3 ..... Next mTemplateHour CType(fMainForm...

Well, here's an interesting test... Leaving my old SMTP code in place, I stepped into the Template_Picker procedure and this time I executed the first opening of a Dataset, then I skipped down to the line where I dispose of the adaptor and set, and then call the email function. It sent the...

To make sure there was not a problem with the server, I replaced your new SMTP code with my old code and then ran the project, skipping the Dataset operations, and it sent the email fine.

I read that message about the default of localhost. Since we are specifying a real SMTP server IP address, that shouldn't apply here. Although I did try replacing the IP address with the localhost of 127.0.0.1 and it still got the same error. I also tried a suggestion from that site of changing...

It worked yesterday with my old code when I would skip the Dataset part. And it is still working with the VB6 project that is running live on all our servers.

Christiaan, I found a really good site with info about System.Web.Mail at http://www.systemwebmail.com They have a section about the "Could not access CDO.Message" error. The first thing they suggest doing is finding the "Inner Exceptions": http://www.systemwebmail.com/faq/4.1.aspx I put the...

Christiaan, First off, thank you for putting so much effort into helping me. :) I implemented the changes that you provided. Unfortunately the mail still fails to send. But the good news is that instead of hanging in oblivion, it actually returns and error message! :) When the following line...

Look like I finally got it all!! Must be a limit to the number of characters you can post! LOL! Anyway, I duplicated the last line of each post in the first line of the next post. If you copy it all out to paste into an editor so it is readable, you can cut out the extra lines. And that "&n" at...

More that got cut of... varFrom = "playlist@clubcom.com" varTo = "brandonmurray@clubcom.com,aljones@clubcom.com" varCC = "blakekercovich@clubcom.com,georgedumaine@clubcom.com,victorwashy@clubcom.com"...

It looks like my post got cut off, here is the rest of it from where it left off... varMessage = varMessage & "Channel ID# " & pChannelID varMessage = varMessage & vbCrLf varMessage = varMessage &...

Chrissie, here is the code that sends the emails... Option Strict Off Option Explicit On Option Compare Text Imports System Imports System.IO Imports System.Text Imports System.Web Friend Class SMTPMailer Public Sub SendMail(ByRef pFromDisplay As String, ByRef pFrom As String, ByRef pTo...

This is really odd, and I'm not how it could even be possible, but here goes... I have a project that was using ADO Recordsets to perform database tasks, and when the procedure completed it would send an email using the built in System.Web.Mail namespace. Now the email does not reference any...

I messed up something in the above post, and don't see a way to edit it, so here is the change... Where it says: ************************************************************ MySQL = "UPDATE tbl_clients SET locked_by_server = " & varServerID WHERE process_flag <> 0 AND locked_by_server Is Null"...

We have a bank of 20 servers that are constantly processing records. Tables that deal with billions of rows. The servers work at the saem time to process batches for hundreds of client machines. One server needs to know if another server has worked on a record while it was processing another...

Sounds good Rick. I saw how to Dispose of individual datatables as well as the whole dataadaptor after you are done with them too. My only other question now, is how do you see if another user has made changes to data, after your initial Fill of the dataset? In old ADO, you would use...

Thanks Rick. I also found something that said it can be done like this: Dim MyDataRow As DataRow For Each MyDataRow In MyDataset.Tables("DataTable").Rows 'Do other code here 'And you can reference fields by their name here using: MyDataRow("field_name") Next MyDataRow That answered both...