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 *