Welcome to HostingForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to fix ASP error

  
   Web Hosting Problem Solving Community! (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 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.

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.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. 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.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. 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.RemoveThis@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.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
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 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
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.TakeThisOut@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:
CERTSRV - error 500 internal server error - Hello, dear all, I have a problem with IIS 6^ On domain server installed Windows Server 2003 R2 SP2. I installed Certification Authority few months ago. After that I installing some web applications (Sharepoint services) - and delete it. After that..

How i can solve the error "Error 1068: The dependency serv.. - When i try to start IIS 5 in my Windows XP sp2 have the error "Error 1068: The dependency service or group failed to start" i have try all (start/stop service, reinstall IIS..) and goggled but not solving some one can help me?

'Error: Connection Error' when connecting to WSUS 3.0 via .. - Hi there, I get the above error message when I try to open the WSUS 3.0 console on the WSUS server (W2K3). It worked fine before. The problem occurred when I was testing on this production server (stupid me, I know, I know). I added tsweb for testing...

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...
   Web Hosting Problem Solving Community! (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 ]