|
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 *
|