ASP createobject statement cause IIS fail

Hi all,

I have an application writen by ASP running on a window2003 + IIS6.0 box.
I will log every page the visitor have visited in my own database using
ODBC, however, I found that sometime the IIS will crash and I alway find the
same error message in the event log when the crash happen, the message is
"Error: File /crm/source/client_profile.asp CreateObject Exception. The
CreateObject of '(null)' caused exception C0000005."

So I search in the ASP page and find that there is only 2 place I use
createobject statement, that is
Set db_conn = Server.CreateObject("ADODB.Connection")
and
Set db_rs = Server.CreateObject("ADODB.recordset")

I don't know why this createobject statement will result an exception.
And this exception will not alway happen, it will happen about 2-3 times a
day.
I have no idea but to restart the IIS to temporary solve the problem.

Anyone encounter the similar problem ?

Can anyone help?

Thanks.

ong

Tom
Mon Jan 03 08:33:51 CST 2005

"ong" <ong@discussions.microsoft.com> wrote in message
news:7E47E17D-E819-47CF-93EF-22D711925390@microsoft.com...
> Hi all,
>
> I have an application writen by ASP running on a window2003 + IIS6.0 box.
> I will log every page the visitor have visited in my own database using
> ODBC, however, I found that sometime the IIS will crash and I alway find
the
> same error message in the event log when the crash happen, the message is
> "Error: File /crm/source/client_profile.asp CreateObject Exception. The
> CreateObject of '(null)' caused exception C0000005."
>
> So I search in the ASP page and find that there is only 2 place I use
> createobject statement, that is
> Set db_conn = Server.CreateObject("ADODB.Connection")
> and
> Set db_rs = Server.CreateObject("ADODB.recordset")
>
> I don't know why this createobject statement will result an exception.
> And this exception will not alway happen, it will happen about 2-3 times a
> day.
> I have no idea but to restart the IIS to temporary solve the problem.
>
> Anyone encounter the similar problem ?

Start here:
http://www.aspfaq.com/show.asp?id=2355

ong
Tue Jan 04 01:59:02 CST 2005

Hi Tom,

Thank you your reply.

I have checked the link you give me below, and those recommendation seems
not related to my problem, besides the permission issue. However, I have set
both read and write permission of my web root folder to the 2 internet users,
the problem still exists.

I nearly get mad as this kind of error happen few tims per day. I would like
to ask in what circumstance the error will occur and what does this error
means ? is it something wrong with IIS or other external DLL I have called in
my application ?
I find difficult to debug my program since the error message is too short
and not meaningful.

Thanks for your help.

ong


"Tom Kaminski [MVP]" wrote:

> "ong" <ong@discussions.microsoft.com> wrote in message
> news:7E47E17D-E819-47CF-93EF-22D711925390@microsoft.com...
> > Hi all,
> >
> > I have an application writen by ASP running on a window2003 + IIS6.0 box.
> > I will log every page the visitor have visited in my own database using
> > ODBC, however, I found that sometime the IIS will crash and I alway find
> the
> > same error message in the event log when the crash happen, the message is
> > "Error: File /crm/source/client_profile.asp CreateObject Exception. The
> > CreateObject of '(null)' caused exception C0000005."
> >
> > So I search in the ASP page and find that there is only 2 place I use
> > createobject statement, that is
> > Set db_conn = Server.CreateObject("ADODB.Connection")
> > and
> > Set db_rs = Server.CreateObject("ADODB.recordset")
> >
> > I don't know why this createobject statement will result an exception.
> > And this exception will not alway happen, it will happen about 2-3 times a
> > day.
> > I have no idea but to restart the IIS to temporary solve the problem.
> >
> > Anyone encounter the similar problem ?
>
> Start here:
> http://www.aspfaq.com/show.asp?id=2355
>
>
>

Tom
Tue Jan 04 07:56:16 CST 2005

"ong" <ong@discussions.microsoft.com> wrote in message
news:1F7195F7-4174-4CA2-9B4B-D4083C52B97F@microsoft.com...
> I have checked the link you give me below, and those recommendation seems
> not related to my problem, besides the permission issue. However, I have
set
> both read and write permission of my web root folder to the 2 internet
users,
> the problem still exists.
>
> I nearly get mad as this kind of error happen few tims per day. I would
like
> to ask in what circumstance the error will occur and what does this error
> means ? is it something wrong with IIS or other external DLL I have called
in
> my application ?
> I find difficult to debug my program since the error message is too short
> and not meaningful.

Did you try a Google search on your error message? I see lot's of hits ...

How about this?
http://support.microsoft.com/kb/262681/en-us?ln=en-us&sd=gn&fr=0

ong
Tue Jan 04 11:21:03 CST 2005

Thanks for the KB acticle, however, it seems apply to IIS5.0, but I am using
IIS6.0

I do search the error message on google, but nothing related acticle
describing the problem found.

Thank for your help

ong

"Tom Kaminski [MVP]" wrote:

> "ong" <ong@discussions.microsoft.com> wrote in message
> news:1F7195F7-4174-4CA2-9B4B-D4083C52B97F@microsoft.com...
> > I have checked the link you give me below, and those recommendation seems
> > not related to my problem, besides the permission issue. However, I have
> set
> > both read and write permission of my web root folder to the 2 internet
> users,
> > the problem still exists.
> >
> > I nearly get mad as this kind of error happen few tims per day. I would
> like
> > to ask in what circumstance the error will occur and what does this error
> > means ? is it something wrong with IIS or other external DLL I have called
> in
> > my application ?
> > I find difficult to debug my program since the error message is too short
> > and not meaningful.
>
> Did you try a Google search on your error message? I see lot's of hits ...
>
> How about this?
> http://support.microsoft.com/kb/262681/en-us?ln=en-us&sd=gn&fr=0
>
>
>

Tom
Tue Jan 04 11:47:48 CST 2005

"ong" <ong@discussions.microsoft.com> wrote in message
news:8F90A4A2-D313-49E9-B6E4-5219451B5739@microsoft.com...
> Thanks for the KB acticle, however, it seems apply to IIS5.0, but I am
using
> IIS6.0

Regardless, are you storing these objects in session or application
variables?

ong
Wed Jan 05 02:23:06 CST 2005

No.
I just store some string and numeric value in session variables.

I search in google and find a suggestion regarding the createobject statement.
Someone suggest simply use createOject instead of Server.Createobject

is this true ?

Thanks in advance.

ong


"Tom Kaminski [MVP]" wrote:

> "ong" <ong@discussions.microsoft.com> wrote in message
> news:8F90A4A2-D313-49E9-B6E4-5219451B5739@microsoft.com...
> > Thanks for the KB acticle, however, it seems apply to IIS5.0, but I am
> using
> > IIS6.0
>
> Regardless, are you storing these objects in session or application
> variables?
>
>
>

Tom
Wed Jan 05 07:26:52 CST 2005

"ong" <ong@discussions.microsoft.com> wrote in message
news:50483452-1FF8-4B21-A4F6-452572F17C4D@microsoft.com...
> No.
> I just store some string and numeric value in session variables.
>
> I search in google and find a suggestion regarding the createobject
statement.
> Someone suggest simply use createOject instead of Server.Createobject
>
> is this true ?

AFAIK, it shouldn't matter and Server.CreateObject would be preferred, but
you could certainly give it a try ...

bakardy
Wed Jan 26 02:53:04 CST 2005

I hope this is the answer. I have the same problem, and the only thing I
found is this.

http://www.issociate.de/board/post/5012/IIS_6.0_-%3E_Server.CreateObject
_of_('null')_!.html

If it works tell us ;D I'll try too.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!