Wrox Programmer Forums
|
Classic ASP Components Discussions specific to components in ASP 3.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Components section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 15th, 2006, 11:22 PM
Authorized User
 
Join Date: Jan 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to InsouciantCoquette Send a message via Yahoo to InsouciantCoquette
Default Error : Server Object, ASP 0177(0x800401F3)

Hola muchachas & muchachos. As stated on my title, I am having a problem with my codes.
I am displaying info from database. And it seems that the error is pointing to my database connections. Hope you people be able to enlighten my mistakes.
Code:
<% Set DB = Server.CreateObject("ADODB.Connection")
   DB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
   & "Data Source=C:\........."
   DB.Open

   Set cmd = Server.CreateObject("ADODB.CommandText")
   Set rs = Server.CreateObject("ADODB.Recordset")
   cmd.CommandText = "SELECT DISTINCT * FROM t_information"
   cmd.ActiveConnection = DB
   Set rs = cmd.Execute
%>
It points to line 6. Set cmd = ......
So what is actually wrong? What did I do wrong here??? Do hope to hear replies here ASAP.:(


* Love me for a reason; Let the reason be love *
__________________
* Love me for a reason; Let the reason be love *
 
Old February 18th, 2006, 10:41 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

should be "ADODB.Command"
 
Old February 21st, 2006, 09:26 PM
Authorized User
 
Join Date: Jan 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to InsouciantCoquette Send a message via Yahoo to InsouciantCoquette
Default

Gosh...Thanks..I've already solved it. I hate when this thing happens..Thanks Senor..

* Love me for a reason; Let the reason be love *





Similar Threads
Thread Thread Starter Forum Replies Last Post
Server object error 'ASP 0177 : 800401f3' lizmorley BOOK: Beginning ASP 3.0 0 February 11th, 2008 07:48 AM
Server Object error 'ASP 0177 : 800401f3' geeta Classic ASP Professional 16 July 23rd, 2007 09:41 AM
Server object, ASP 0177 (0x800401F3) crmpicco Classic ASP Professional 2 May 1st, 2006 02:23 PM
Server Object error 'ASP 0177 : 800401f3' geeta Classic ASP Basics 1 July 10th, 2003 06:00 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.