Hi group!
I am getting the following error from my ASP application:
Microsoft VBScript runtime error '800a0007'
Out of memory: 'Server.CreateObject'
It always (as far as i have observed) occurs when i try to create a new
ADODB.connection object in my cCon helper function (opening a connection and
returning it):
Function cCon()
Dim cnRet
set cnRet = server.createobject("ADODB.Connection") 'This is where the
error is thrown
cnRet.connectionstring = GLB_CONSTR_DB
cnRet.open
Set cCon = cnRet
End Function
The page that errors will typically call this function 6- 10times from
different functions which handle their connections in this way:
Function Foo()
dim Con ...
Set con = cCon()
.... function code
con.close
set con = nothing
End Function
All my recordsets are disconnected and also destroyed with .close and Set
rst = nothing.
I have tested the application on two seperate servers with the same result.
Both machines had more than enough memory.
I have also checked the application log to see if anything was logged, but
there wasnt.
Any one got ANY ideas on this one? I'm starting to get desperate!