Welcome to MobyThreads.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in
All support for the MobyThreads Threaded phpBB MOD can now be found on welsolutions at this forum

How to fix ASP error

  
   Web Hosting and Web Master Forums (Home) -> IIS RSS
Next:  Using IIS  
Author Message
BAM

External


Since: Jun 14, 2005
Posts: 9



(Msg. 1) Posted: Tue Jun 14, 2005 10:47 am
Post subject: How to fix ASP error
Archived from groups: microsoft>public>inetserver>iis (more info?)
Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid class string
/myweb/connect.asp, line 13

This is line 13: Set objRS=Server.CreateObject("ADOB.Recordset")

I don't know how to fix this.

 >> Stay informed about: How to fix ASP error 
Back to top
Login to vote
user641

External


Since: Aug 22, 2003
Posts: 1637



(Msg. 2) Posted: Tue Jun 14, 2005 2:10 pm
Post subject: Re: How to fix ASP error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"BAM" <BAM.TakeThisOut@discussions.microsoft.com> wrote in message
news:794EFB3B-2677-43E6-9A6D-AE908CD8B2F2@microsoft.com...
 > Error Type:
 > Server object, ASP 0177 (0x800401F3)
 > Invalid class string
 > /myweb/connect.asp, line 13
 >
 > This is line 13: Set objRS=Server.CreateObject("ADOB.Recordset")
 >
 > I don't know how to fix this.

Try:

Set objRS=Server.CreateObject("ADODB.Recordset")

--
Tom Kaminski IIS MVP
<a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</a>
<a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/" target="_blank">http://mvp.support.microsoft.com/</a>
<a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running IIS<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: How to fix ASP error 
Back to top
Login to vote
Steven Burn

External


Since: Feb 07, 2005
Posts: 106



(Msg. 3) Posted: Tue Jun 14, 2005 7:08 pm
Post subject: Re: How to fix ASP error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Set objRS=Server.CreateObject("ADOB.Recordset")

Change to;

Set objRS=Server.CreateObject("ADODB.Recordset")


--
Regards

Steven Burn
Ur I.T. Mate Group
<a style='text-decoration: underline;' href="http://www.it-mate.co.uk" target="_blank">www.it-mate.co.uk</a>

Keeping it FREE!

"BAM" <BAM.DeleteThis@discussions.microsoft.com> wrote in message news:794EFB3B-2677-43E6-9A6D-AE908CD8B2F2@microsoft.com...
 > Error Type:
 > Server object, ASP 0177 (0x800401F3)
 > Invalid class string
 > /myweb/connect.asp, line 13
 >
 > This is line 13: Set objRS=Server.CreateObject("ADOB.Recordset")
 >
 > I don't know how to fix this.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: How to fix ASP error 
Back to top
Login to vote
BAM

External


Since: Jun 14, 2005
Posts: 9



(Msg. 4) Posted: Tue Jun 14, 2005 7:08 pm
Post subject: Re: How to fix ASP error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thank you very much. That did eliminate that error. But now I'm getting
another one.

Error Type:
Microsoft VBScript runtime (0x800A01F4)
Variable is undefined: 'adCmdTable'
/myweb/connect.asp, line 14

Line 14: objRS.Open "Available Courses", objConn, , , adCmdTable

where "Available Courses" is a table in the MS Acess DB (office 2003).

"Steven Burn" wrote:

 > Set objRS=Server.CreateObject("ADOB.Recordset")
 >
 > Change to;
 >
 > Set objRS=Server.CreateObject("ADODB.Recordset")
 >
 >
 > --
 > Regards
 >
 > Steven Burn
 > Ur I.T. Mate Group
<font color=purple> > <a style='text-decoration: underline;' href="http://www.it-mate.co.uk</font" target="_blank">www.it-mate.co.uk</font</a>>
 >
 > Keeping it FREE!
 >
 > "BAM" <BAM.RemoveThis@discussions.microsoft.com> wrote in message news:794EFB3B-2677-43E6-9A6D-AE908CD8B2F2@microsoft.com...
  > > Error Type:
  > > Server object, ASP 0177 (0x800401F3)
  > > Invalid class string
  > > /myweb/connect.asp, line 13
  > >
  > > This is line 13: Set objRS=Server.CreateObject("ADOB.Recordset")
  > >
  > > I don't know how to fix this.
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: How to fix ASP error 
Back to top
Login to vote
Steven Burn

External


Since: Feb 07, 2005
Posts: 106



(Msg. 5) Posted: Tue Jun 14, 2005 7:44 pm
Post subject: Re: How to fix ASP error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Add this to the top of your script;

Const adCmdTable = &H0002

--
Regards

Steven Burn
Ur I.T. Mate Group
<a style='text-decoration: underline;' href="http://www.it-mate.co.uk" target="_blank">www.it-mate.co.uk</a>

Keeping it FREE!

"BAM" <BAM.TakeThisOut@discussions.microsoft.com> wrote in message news:32ADF834-C839-4FE3-A51C-37BE6B7751EA@microsoft.com...
 > Thank you very much. That did eliminate that error. But now I'm getting
 > another one.
 >
 > Error Type:
 > Microsoft VBScript runtime (0x800A01F4)
 > Variable is undefined: 'adCmdTable'
 > /myweb/connect.asp, line 14
 >
 > Line 14: objRS.Open "Available Courses", objConn, , , adCmdTable
 >
 > where "Available Courses" is a table in the MS Acess DB (office 2003).
 >
 > "Steven Burn" wrote:
 >
  > > Set objRS=Server.CreateObject("ADOB.Recordset")
  > >
  > > Change to;
  > >
  > > Set objRS=Server.CreateObject("ADODB.Recordset")
  > >
  > >
  > > --
  > > Regards
  > >
  > > Steven Burn
  > > Ur I.T. Mate Group
<font color=green>  > > <a style='text-decoration: underline;' href="http://www.it-mate.co.uk</font" target="_blank">www.it-mate.co.uk</font</a>>
  > >
  > > Keeping it FREE!
  > >
  > > "BAM" <BAM.TakeThisOut@discussions.microsoft.com> wrote in message news:794EFB3B-2677-43E6-9A6D-AE908CD8B2F2@microsoft.com...
   > > > Error Type:
   > > > Server object, ASP 0177 (0x800401F3)
   > > > Invalid class string
   > > > /myweb/connect.asp, line 13
   > > >
   > > > This is line 13: Set objRS=Server.CreateObject("ADOB.Recordset")
   > > >
   > > > I don't know how to fix this.
  > >
  > ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: How to fix ASP error 
Back to top
Login to vote
BAM

External


Since: Jun 14, 2005
Posts: 9



(Msg. 6) Posted: Tue Jun 14, 2005 7:44 pm
Post subject: Re: How to fix ASP error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I inserted that line right before: Dim objConn.

Now I get the following:

Error Type:
Microsoft VBScript compilation (0x800A0411)
Name redefined
/myweb/connect.asp, line 7, column 6
Const adCmdTable=&H0002

As I'm sure you can tell, I'm new at this.

"Steven Burn" wrote:

 > Add this to the top of your script;
 >
 > Const adCmdTable = &H0002
 >
 > --
 > Regards
 >
 > Steven Burn
 > Ur I.T. Mate Group
<font color=purple> > <a style='text-decoration: underline;' href="http://www.it-mate.co.uk</font" target="_blank">www.it-mate.co.uk</font</a>>
 >
 > Keeping it FREE!
 >
 > "BAM" <BAM.TakeThisOut@discussions.microsoft.com> wrote in message news:32ADF834-C839-4FE3-A51C-37BE6B7751EA@microsoft.com...
  > > Thank you very much. That did eliminate that error. But now I'm getting
  > > another one.
  > >
  > > Error Type:
  > > Microsoft VBScript runtime (0x800A01F4)
  > > Variable is undefined: 'adCmdTable'
  > > /myweb/connect.asp, line 14
  > >
  > > Line 14: objRS.Open "Available Courses", objConn, , , adCmdTable
  > >
  > > where "Available Courses" is a table in the MS Acess DB (office 2003).
  > >
  > > "Steven Burn" wrote:
  > >
   > > > Set objRS=Server.CreateObject("ADOB.Recordset")
   > > >
   > > > Change to;
   > > >
   > > > Set objRS=Server.CreateObject("ADODB.Recordset")
   > > >
   > > >
   > > > --
   > > > Regards
   > > >
   > > > Steven Burn
   > > > Ur I.T. Mate Group
<font color=brown>   > > > <a style='text-decoration: underline;' href="http://www.it-mate.co.uk</font" target="_blank">www.it-mate.co.uk</font</a>>
   > > >
   > > > Keeping it FREE!
   > > >
   > > > "BAM" <BAM.TakeThisOut@discussions.microsoft.com> wrote in message news:794EFB3B-2677-43E6-9A6D-AE908CD8B2F2@microsoft.com...
   > > > > Error Type:
   > > > > Server object, ASP 0177 (0x800401F3)
   > > > > Invalid class string
   > > > > /myweb/connect.asp, line 13
   > > > >
   > > > > This is line 13: Set objRS=Server.CreateObject("ADOB.Recordset")
   > > > >
   > > > > I don't know how to fix this.
   > > >
   > > >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: How to fix ASP error 
Back to top
Login to vote
Steven Burn

External


Since: Feb 07, 2005
Posts: 106



(Msg. 7) Posted: Tue Jun 14, 2005 8:47 pm
Post subject: Re: How to fix ASP error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Can you post the code for connect.asp?

--
Regards

Steven Burn
Ur I.T. Mate Group
<a style='text-decoration: underline;' href="http://www.it-mate.co.uk" target="_blank">www.it-mate.co.uk</a>

Keeping it FREE!

"BAM" <BAM.DeleteThis@discussions.microsoft.com> wrote in message news:F75D6520-A4A0-4814-BC08-84D3CF00BF05@microsoft.com...
 > I inserted that line right before: Dim objConn.
 >
 > Now I get the following:
 >
 > Error Type:
 > Microsoft VBScript compilation (0x800A0411)
 > Name redefined
 > /myweb/connect.asp, line 7, column 6
 > Const adCmdTable=&H0002
 >
 > As I'm sure you can tell, I'm new at this.
 >
 > "Steven Burn" wrote:
 >
  > > Add this to the top of your script;
  > >
  > > Const adCmdTable = &H0002
  > >
  > > --
  > > Regards
  > >
  > > Steven Burn
  > > Ur I.T. Mate Group
<font color=green>  > > <a style='text-decoration: underline;' href="http://www.it-mate.co.uk</font" target="_blank">www.it-mate.co.uk</font</a>>
  > >
  > > Keeping it FREE!
  > >
  > > "BAM" <BAM.DeleteThis@discussions.microsoft.com> wrote in message news:32ADF834-C839-4FE3-A51C-37BE6B7751EA@microsoft.com...
   > > > Thank you very much. That did eliminate that error. But now I'm getting
   > > > another one.
   > > >
   > > > Error Type:
   > > > Microsoft VBScript runtime (0x800A01F4)
   > > > Variable is undefined: 'adCmdTable'
   > > > /myweb/connect.asp, line 14
   > > >
   > > > Line 14: objRS.Open "Available Courses", objConn, , , adCmdTable
   > > >
   > > > where "Available Courses" is a table in the MS Acess DB (office 2003).
   > > >
   > > > "Steven Burn" wrote:
   > > >
   > > > > Set objRS=Server.CreateObject("ADOB.Recordset")
   > > > >
   > > > > Change to;
   > > > >
   > > > > Set objRS=Server.CreateObject("ADODB.Recordset")
   > > > >
   > > > >
   > > > > --
   > > > > Regards
   > > > >
   > > > > Steven Burn
   > > > > Ur I.T. Mate Group
<font color=brown>   > > > > <a style='text-decoration: underline;' href="http://www.it-mate.co.uk</font" target="_blank">www.it-mate.co.uk</font</a>>
   > > > >
   > > > > Keeping it FREE!
   > > > >
   > > > > "BAM" <BAM.DeleteThis@discussions.microsoft.com> wrote in message news:794EFB3B-2677-43E6-9A6D-AE908CD8B2F2@microsoft.com...
   > > > > > Error Type:
   > > > > > Server object, ASP 0177 (0x800401F3)
   > > > > > Invalid class string
   > > > > > /myweb/connect.asp, line 13
   > > > > >
   > > > > > This is line 13: Set objRS=Server.CreateObject("ADOB.Recordset")
   > > > > >
   > > > > > I don't know how to fix this.
   > > > >
   > > > >
  > >
  > ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: How to fix ASP error 
Back to top
Login to vote
BAM

External


Since: Jun 14, 2005
Posts: 9



(Msg. 8) Posted: Tue Jun 14, 2005 8:47 pm
Post subject: Re: How to fix ASP error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
The code is between the two lines.
_______________________________________________
<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include virtual="/adovbs.inc"-->
<HTML>
<BODY>
<%

Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & _
    "DBQ=C:\Inetpub\wwwroot\MyWeb\regdb2.mdb"
objConn.Open

Dim objRS
Set objRS=Server.CreateObject("ADODB.Recordset")
objRS.Open "Available Courses", objConn, , , adCmdTable
%>
<TABLE border=1>
<TR>
<TD><B>Course ID</B></TD>
<TD><B>Instructor</B></TD>
<TD><B>Location</B></TD>
<TD><B>Course Name</B></TD>
   <TD><B>Meeting Day</B></TD>
   <TD><B>Meeting Time</B></TD>
</TR>
<%
Do While Not objRS.EOF
  Response.Write "<B>" & objRS("CourseID") & "</B><BR>"
  Response.Write objRS("INSTRLASTNAME") & "<BR>"
  Response.Write objRS("CourseLocation") & "<BR>"
  Response.Write objRS("CourseName") & "<BR>"
  Response.Write objRS("CourseMeetingDay") & "<BR>"
  Response.Write objRS("CourseMeetingTimes") & "<P><HR><P>"


  objRS.MoveNext
Loop

objRS.Close
SET objRS=Nothing

objConn.Close
Set objConn=Nothing
%>
  </BODY>
</HTML>
________________________________________________________


"Steven Burn" wrote:

 > Can you post the code for connect.asp?
 >
 > --
 > Regards
 >
 > Steven Burn
 > Ur I.T. Mate Group
<font color=purple> > <a style='text-decoration: underline;' href="http://www.it-mate.co.uk</font" target="_blank">www.it-mate.co.uk</font</a>>
 >
 > Keeping it FREE!<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: How to fix ASP error 
Back to top
Login to vote
Steven Burn

External


Since: Feb 07, 2005
Posts: 106



(Msg. 9) Posted: Tue Jun 14, 2005 10:19 pm
Post subject: Re: How to fix ASP error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"BAM" <BAM.DeleteThis@discussions.microsoft.com> wrote in message news:58F997C2-6D56-461B-B697-4A750602CD72@microsoft.com...
 > The code is between the two lines.
 > _______________________________________________
 > <%@ Language=VBScript %>
 > <% Option Explicit %>
 > <!--#include virtual="/adovbs.inc"-->
</snip>

Get rid of the adovbs.inc include and just include the commands your going to be using

 > <HTML>
 > <BODY>
 > <%
 >
 > Dim objConn
 > Set objConn = Server.CreateObject("ADODB.Connection")

</snip>

Change;

 > objConn.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & _
 > "DBQ=C:\Inetpub\wwwroot\MyWeb\regdb2.mdb"
 > objConn.Open

To;

objConn.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("regdb2.mdb"))

 >
 > Dim objRS
 > Set objRS=Server.CreateObject("ADODB.Recordset")
 > objRS.Open "Available Courses", objConn, , , adCmdTable
 > %>
 > <TABLE border=1>
 > <TR>
 > <TD><B>Course ID</B></TD>
 > <TD><B>Instructor</B></TD>
 > <TD><B>Location</B></TD>
 > <TD><B>Course Name</B></TD>
 > <TD><B>Meeting Day</B></TD>
 > <TD><B>Meeting Time</B></TD>
 > </TR>
 > <%
 > Do While Not objRS.EOF
 > Response.Write "<B>" & objRS("CourseID") & "</B><BR>"
 > Response.Write objRS("INSTRLASTNAME") & "<BR>"
 > Response.Write objRS("CourseLocation") & "<BR>"
 > Response.Write objRS("CourseName") & "<BR>"
 > Response.Write objRS("CourseMeetingDay") & "<BR>"
 > Response.Write objRS("CourseMeetingTimes") & "<P><HR><P>"
 >
 >
 > objRS.MoveNext
 > Loop
 >
 > objRS.Close
 > SET objRS=Nothing
 >
 > objConn.Close
 > Set objConn=Nothing
 > %>
 > </BODY>
 > </HTML>



--
Regards

Steven Burn
Ur I.T. Mate Group
<a style='text-decoration: underline;' href="http://www.it-mate.co.uk" target="_blank">www.it-mate.co.uk</a>

Keeping it FREE!<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: How to fix ASP error 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
IIS and Com+ error - Hello experts, Accessing http://localhost/, it returned "server application error". Then when I browse the admin tools, component services, computer, MMC closed suddenly. I wondered if IIS error is due to damaged com+. But when following the i...

Need help with ASP Error - I have Windows XP and IIS installed. I am getting the following error on this line of code listed below: Con.Open "accessDSN" HTTP 500.100 - Internal Server Error - ASP error Internet Information Services Error Type: Provider (0x80004005...

CGI error - CGI Error The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: This is an C++ .exe CGI application which is working fine in windows NT 4.0 , IIS 4.0 but not on windows 2000 IIS 5.0,..

iis 6.0 error - i have an app developed in vb 6 and it runs perfectly under iis 4.0 but when i upload it on iis 6 it fails with the folowing error: Server object error 'ASP 0177 : 800401f3' Server.CreateObject Failed /main.asp, line 8 800401f3 This is the most....

error 500.100 - i have an app developed in vb6 and under iis 4 it works ok, but under iis 5.1 or 6.0 it gives the following: ------------------------------------------------------------------------------------------------ The page cannot be displayed There is a proble...
   Web Hosting and Web Master Forums (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]