March 12, 2014 at 7:29 am
Some improvement, but still got one 3709.
I'd *love* to understand what's causing the error.
March 13, 2014 at 5:27 am
My 2 penn'orth; I think the error you're getting is from an attempt to execute the stored proc with a connection that isn't open so you're not seeing the message associated with failing to open the connection in the first place. You need to replace "On Error Resume Next" with "On Error GoTo <some local error handler>. In the error handler, you can check the actual connection failure message which may give you a clue as to what's going on. You could still allow a certain number of failure iterations before giving up entirely.
February 8, 2015 at 10:12 pm
Using those code will help you.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply