Subject: Error : Server Object, ASP 0177(0x800401F3)
Posted By: InsouciantCoquette Post Date: 2/15/2006 10:22:09 PM
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.

<% 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 *
Reply By: pgtips Reply Date: 2/18/2006 9:41:29 AM
should be "ADODB.Command"
Reply By: InsouciantCoquette Reply Date: 2/21/2006 8:26:03 PM
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 *

Go to topic 38725

Return to index page 363
Return to index page 362
Return to index page 361
Return to index page 360
Return to index page 359
Return to index page 358
Return to index page 357
Return to index page 356
Return to index page 355
Return to index page 354