Search results

DBTool is run weekly on an automated schedule

I didn't include the error handling code in what I posted above for the sake of space. I do have error trapping in there, but I haven't yet learned the "Try-Catch-Finally" syntax well enough to fully upgrade, so I still have "On Error GoTo Handler". Each of the routines that are being called...

What appears to be happening is that the initial connection is getting lost and I cannot seem to find a consistent pattern. One time I get through about 90+ records and wind up with a "NO No SQL servers are available" error in the log. It seems like the initial connection is getting lost so...

Tom. Your hunch was correct. I do see in the database log files that somewhere in the execution of the program additional connections are occurring. Haven't traced the cause yet. It does not happen in the VB6 version, only in the .NET version and it only crashes in the virtual...

Thanks, Tom. That doesn't seem to make sense to me though for two reasons. One, it doesn't happen when I run the same code from another machine and two, my code does create a recordset in the module in question, and I do close it, but being new to .NET, I don't know exactly how the garbage...

I have an old small VB6 app that I am trying to update to VB..NET 2010. Still learning the .NET coding changes. I am getting an odd "broker rejects connection" in the middle of a repetitive process. Essentially, it is a small data gathering app. I am collecting data on students to port...