VB AcX dll and ASP - inconsistent errors...
Sorry for the double post, folks, but I'm still struggling w/ this problem!!
I'm baffled!! I've got no exp. in win2000/COM+, and am relying on our hardware group to set up the server......
I'm using an activex dll that's loaded on a win2000 server, and generally works fine. However, when testing out the page with the script below, it generates the expected results only every "9th" time - in other words, after hitting refresh 9 times....or, opening a new browser window 9 times.... and this whole "9" thing is really consistent...
What should happen is I should get an error each time this page is run, b/c I'm passing a bogus username and password to the
ACAPI.ACOpenConnection method.
I've tried clearing the buffer, etc. I know that the object gets created each time, and I know the methods work fine, b/c I've used the same dll in a VB program w/o a problem (even running multiple copies of the VB program), and get the expected results each time.
On the dll side, I've set project properties to Retain in Memory and Unattended Execution....
Any ideas??
Thoughts greatly appreciated, this one has me stumped, and it's most likely something simple!
Thanks in advance!
<%
On Error Resume Next
Dim ACAPI, hConnection, lErr, strErrMsg
Set ACAPI = Server.CreateObject("ACAPI.ACAPIWrapper")
ACAPI.ACStartup
hConnection = ACAPI.ACOpenConnection("D_ATSDB1", "sdfasdf", "asdfwe")
lErr = ACAPI.ACLastError(hConnection)
strErrMsg = ACAPI.ACLastErrorMsg(hConnection)
lErr = ACAPI.ACClearLastError(hConnection)
ACAPI.ACCloseConnection hconnection
ACAPI.ACCleanup
Set ACAPI = Nothing
hConnection=0
lErr=0
strErrMsg=""
%>
Sorin - thx, I've done that and...
There isn't any change - I don't get any errors, but I don't get the expected results until the 9th refresh either...
Still has me stymied!!
Cindy