Hello there,

I'm having problems with Server.CreateObject on IIS 6.0.

When I start my app everithing works fine. The problem occurs after
using the app for many times.

I tougth that was some kind of problem with ADODB.Connection but I saw
on web many friends having the same problem with different objects server
creations (file system object, adodb connections, cdonts mailer, etc).

It ocurrs exactly in the adodb.connection creation line: Set Connection
= Server.CreateObject("adodb.connection")

It's strange, the server is telling me that there is an instruction to
create a null object in my code.

It seems to be a security limitation of IIS 6.0.

Here is the error return page from the webserver (Brazilian Portuguese):

 ****************************************
***

CreateObject of '(null)' caused exception C0000005.

Server Object error 'ASP 0177 : c0000005'

Falha em Server.CreateObject

/Online/Global/ini_x.asp, line 67

c0000005

 ****************************************
***

Does anybody has an idea about it?

Thanks in advance.

Henrique Piolho

[ Post a follow-up to this message ]

what is line 57 ?  C0000005 = AV (access violation)
you might want to try asp discussion group.

--
Regards,
Bernard Cheah
http://www.tryiis.com/
http://support.microsoft.com/
http://www.msmvps.com/bernard/



"Henrique Soler Albano" <henriquecns@consciencia.com.br> wrote in message
news:#tXbgl9qEHA.708@tk2msftngp13.phx.gbl...
> Hello there,
>
>     I'm having problems with Server.CreateObject on IIS 6.0.
>
>     When I start my app everithing works fine. The problem occurs after
> using the app for many times.
>
>     I tougth that was some kind of problem with ADODB.Connection but I saw
> on web many friends having the same problem with different objects server
> creations (file system object, adodb connections, cdonts mailer, etc).
>
>     It ocurrs exactly in the adodb.connection creation line: Set
Connection
> = Server.CreateObject("adodb.connection")
>
>     It's strange, the server is telling me that there is an instruction to
> create a null object in my code.
>
>     It seems to be a security limitation of IIS 6.0.
>
>     Here is the error return page from the webserver (Brazilian
Portuguese):
>
>  ****************************************
***
>
> CreateObject of '(null)' caused exception C0000005.
>
> Server Object error 'ASP 0177 : c0000005'
>
> Falha em Server.CreateObject
>
> /Online/Global/ini_x.asp, line 67
>
> c0000005
>
>  ****************************************
***
>
>     Does anybody has an idea about it?
>
>     Thanks in advance.
>
> Henrique Piolho
>
>
>
>

[ Post a follow-up to this message ]

Bernard,

This situation is related to IIS 6.0 compatibility problems with earlier
versions of IIS.

I tought you would help-me instead of criticize-me.

Egbert Nierop (MVP for IIS) has posted a great explanation for this.

Egbert's Post
 ****************************************
*******************
First you should understand that server.createobject was meant for IIS 3.0
and 4.0 backward compatibility.
In short, it does a lot more code behind the scene that you don't need.
So change that to Set Connection = CreateObject("ADODB.Connection")
After that you might see other behaviour however, the problem you describe
should not happen.
 ****************************************
*******************

I hope everybody has learned with this thread.

Thanks again.

Ps: Sorry for the poor english.

Henrique Soler Albano

[ Post a follow-up to this message ]

Sorry if you get me wrong. I have no intention of 'criticize'.
and I have IIS 6.0 box with server.createobject.

so the problem solved by Egbert's post ?

--
Regards,
Bernard Cheah
http://www.tryiis.com/
http://support.microsoft.com/
http://www.msmvps.com/bernard/



"Henrique Soler Albano" <henriquecns@consciencia.com.br> wrote in message
news:ecw$nGKrEHA.2732@TK2MSFTNGP09.phx.gbl...
> Bernard,
>
>     This situation is related to IIS 6.0 compatibility problems with
earlier
> versions of IIS.
>
>     I tought you would help-me instead of criticize-me.
>
>     Egbert Nierop (MVP for IIS) has posted a great explanation for this.
>
> Egbert's Post
>  ****************************************
*******************
> First you should understand that server.createobject was meant for IIS 3.0
> and 4.0 backward compatibility.
> In short, it does a lot more code behind the scene that you don't need.
> So change that to Set Connection = CreateObject("ADODB.Connection")
> After that you might see other behaviour however, the problem you describe
> should not happen.
>  ****************************************
*******************
>
>     I hope everybody has learned with this thread.
>
>     Thanks again.
>
>     Ps: Sorry for the poor english.
>
>     Henrique Soler Albano
>
>

[ Post a follow-up to this message ]

Yes,

It seems to be ok right now.

The tool is working for 2 days after the changes, and doesn't stops.

The compatibility problem must realy exists, so I think Egbert was right.

Thanks everybody,

Thanks Bernand,

Henrique Soler Albano


"Bernard" <qbernard@hotmail.com.discuss> escreveu na mensagem
news:u1Pv83OrEHA.736@tk2msftngp13.phx.gbl...
> Sorry if you get me wrong. I have no intention of 'criticize'.
> and I have IIS 6.0 box with server.createobject.
>
> so the problem solved by Egbert's post ?
>
> --
> Regards,
> Bernard Cheah
> http://www.tryiis.com/
> http://support.microsoft.com/
> http://www.msmvps.com/bernard/
>
>
>
> "Henrique Soler Albano" <henriquecns@consciencia.com.br> wrote in message
> news:ecw$nGKrEHA.2732@TK2MSFTNGP09.phx.gbl... 
> earlier 
3.0[vbcol=seagreen] 
describe[vbcol=seagreen] 
>
>

[ Post a follow-up to this message ]

Henrique, have the intermittant error messages returned?  I have the same pr
oblem. A few of my .asp pages that display data from various Access database
s work fine for a few views, then the user gets and error such as this one:

===================================

Active Server Pages error 'ASP 0241' 

CreateObject Exception 

/html/whctools.asp 

The CreateObject of '(null)' caused exception C0000005. 

Active Server Pages error 'ASP 0241' 

CreateObject Exception 

/html/whctools.asp 

The CreateObject of '(null)' caused exception C0000005. 

Server object error 'ASP 0177 : c0000005' 

Server.CreateObject Failed 

/html/whctools.asp, line 71 

================================

I did change my line of code to read:

set conn = CreateObject("ADODB.Recordset") as opposed to Server.CreateObject
. But no change in the spotty behaviour. I'm stumped. I thought if it was a 
permissions problem, but then the error should always occur, right? 

Since the error is intermittant, could there may be a timing thing going on-
-I am clearly out of my depth here.

Restarting the IIS 6 service solves the problem for a while, but that is def
initely not a good solution. Any ideas out there.

[ Post a follow-up to this message ]