p2p.wrox.com: Archives - asp

asp_databases thread: Visual Interdev SQL

Message #1 by "Steven Anicas" <anicas@r...> on Fri, 7 Jul 2000 21:47:44

I'm going through the Beginning web development with Visual Interdev book 

and I'm in Chap 8 using DTCs  RECORDSET and Data Bindings page 245.  When I 

view the page with the browser, I get a error message:





Server object error 'ASP 0177 : 800401f3' 



Server.CreateObject Failed 



/WroxCameras/global.asa, line 32 



Invalid class string 





I am using SQL 7.0 on a NT 4 box w/ IIS 4.



I tried the same thing but connected to a MSDE Database on my win98 PC and 

the example works.   In my searching I've found info that my problem stems 

from some type of security problem on the IIS server.  I really don't have 

a clue where to begin.



Steven

Message #2 by "Patrick" <patrick007@h...> on Mon, 10 Jul 2000 12:48:12 -0400

Hi Steven,

I ran into the same problem and this article helped out.

http://support.microsoft.com/support/kb/articles/Q197/9/66.ASP



After I followed the instructions I get a new error message.

error '80020009'

Exception occurred.



/miss3397a/ASPPage1.asp, line 41



This is the offending line

var rsTmp = DE.Recordsets('Command1');

Also there is very sketchy references to the error.  Just that it is a

generic error.



This is happening when moving from the development server to the production

server, and I have checked this on two production servers, same result.  The

only difference is the development box software was installed from visual

studio cd's, and the production server was installed from nt option pack.

Does anyone know of a readme for getting a production server ready?



Thanks

Patrick







----- Original Message -----

From: Steven Anicas 

To: ASP Databases <asp_databases@p...>

Sent: Friday, July 07, 2000 9:47 PM

Subject: [asp_databases] Visual Interdev SQL





> I'm going through the Beginning web development with Visual Interdev book

> and I'm in Chap 8 using DTCs  RECORDSET and Data Bindings page 245.  When

I

> view the page with the browser, I get a error message:

>

>

> Server object error 'ASP 0177 : 800401f3'

>

> Server.CreateObject Failed

>

> /WroxCameras/global.asa, line 32

>

> Invalid class string

>

>

> I am using SQL 7.0 on a NT 4 box w/ IIS 4.

>

> I tried the same thing but connected to a MSDE Database on my win98 PC and

> the example works.   In my searching I've found info that my problem stems

> from some type of security problem on the IIS server.  I really don't have

> a clue where to begin.

>

> Steven

>

Message #3 by "Steven Anicas" <anicas@r...> on Mon, 10 Jul 2000 10:11:20 -1000

Hey thanks for the response Pat!

So you were able to get the Development server to work w/ the advice of the

article? The development server is running IIS4 I assume?

Steven

-----Original Message-----

From: Patrick []

Sent: Monday, July 10, 2000 6:48 AM

To: ASP Databases

Subject: [asp_databases] Re: Visual Interdev SQL





Hi Steven,

I ran into the same problem and this article helped out.

http://support.microsoft.com/support/kb/articles/Q197/9/66.ASP



After I followed the instructions I get a new error message.

error '80020009'

Exception occurred.



/miss3397a/ASPPage1.asp, line 41



This is the offending line

var rsTmp = DE.Recordsets('Command1');

Also there is very sketchy references to the error.  Just that it is a

generic error.



This is happening when moving from the development server to the production

server, and I have checked this on two production servers, same result.  The

only difference is the development box software was installed from visual

studio cd's, and the production server was installed from nt option pack.

Does anyone know of a readme for getting a production server ready?



Thanks

Patrick







----- Original Message -----

From: Steven Anicas

To: ASP Databases <asp_databases@p...>

Sent: Friday, July 07, 2000 9:47 PM

Subject: [asp_databases] Visual Interdev SQL





> I'm going through the Beginning web development with Visual Interdev book

> and I'm in Chap 8 using DTCs  RECORDSET and Data Bindings page 245.  When

I

> view the page with the browser, I get a error message:

>

>

> Server object error 'ASP 0177 : 800401f3'

>

> Server.CreateObject Failed

>

> /WroxCameras/global.asa, line 32

>

> Invalid class string

>

>

> I am using SQL 7.0 on a NT 4 box w/ IIS 4.

>

> I tried the same thing but connected to a MSDE Database on my win98 PC and

> the example works.   In my searching I've found info that my problem stems

> from some type of security problem on the IIS server.  I really don't have

> a clue where to begin.

>

> Steven

>

Message #4 by "Patrick" <patrick007@h...> on Tue, 11 Jul 2000 10:24:56 -0400

Yep, IIS4.  But after fixing it now I get error '80020009', this is a real

strange one, if you get as well check out

http://support.microsoft.com/support/kb/articles/Q234/2/05.ASP  , not that

it helped very much.



----- Original Message -----

From: Steven Anicas 

To: ASP Databases <asp_databases@p...>

Sent: Monday, July 10, 2000 4:11 PM

Subject: [asp_databases] Re: Visual Interdev SQL





> Hey thanks for the response Pat!

> So you were able to get the Development server to work w/ the advice of

the

> article? The development server is running IIS4 I assume?

> Steven

> -----Original Message-----

> From: Patrick []

> Sent: Monday, July 10, 2000 6:48 AM

> To: ASP Databases

> Subject: [asp_databases] Re: Visual Interdev SQL

>

>

> Hi Steven,

> I ran into the same problem and this article helped out.

> http://support.microsoft.com/support/kb/articles/Q197/9/66.ASP

>

> After I followed the instructions I get a new error message.

> error '80020009'

> Exception occurred.

>

> /miss3397a/ASPPage1.asp, line 41

>

> This is the offending line

> var rsTmp = DE.Recordsets('Command1');

> Also there is very sketchy references to the error.  Just that it is a

> generic error.

>

> This is happening when moving from the development server to the

production

> server, and I have checked this on two production servers, same result.

The

> only difference is the development box software was installed from visual

> studio cd's, and the production server was installed from nt option pack.

> Does anyone know of a readme for getting a production server ready?

>

> Thanks

> Patrick

>

>

>

> ----- Original Message -----

> From: Steven Anicas

> To: ASP Databases <asp_databases@p...>

> Sent: Friday, July 07, 2000 9:47 PM

> Subject: [asp_databases] Visual Interdev SQL

>

>

> > I'm going through the Beginning web development with Visual Interdev

book

> > and I'm in Chap 8 using DTCs  RECORDSET and Data Bindings page 245.

When

> I

> > view the page with the browser, I get a error message:

> >

> >

> > Server object error 'ASP 0177 : 800401f3'

> >

> > Server.CreateObject Failed

> >

> > /WroxCameras/global.asa, line 32

> >

> > Invalid class string

> >

> >

> > I am using SQL 7.0 on a NT 4 box w/ IIS 4.

> >

> > I tried the same thing but connected to a MSDE Database on my win98 PC

and

> > the example works.   In my searching I've found info that my problem

stems

> > from some type of security problem on the IIS server.  I really don't

have

> > a clue where to begin.

> >

> > Steven

> >

Return to Index

P2P Archives