Hi
I m getting the following error message:

Error Type:
Microsoft JET Database Engine (0x80040E0C)
Command text was not set for the command object.
/dbdisplay.asp, line 18

Will b great if someone help me out.

Cheers

------------------------------------------



<% @LANGUAGE = VBSCRIPT %>


option Explicit
<%
set con=server.CreateObject ("ADODB.Connection")
set rs=server.CreateObject ("ADODB.Recordset")

  DBStr="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &_
        "C:\Inetpub\wwwroot\admin\webdb.mdb" & ";"


   sql = "select * from menu"

  con.Open DBStr

  set rs = con.Execute (str)
 Response.Write "connection established"

 %>

__________________
Cheers
Sheraz

if that exactly your code then i suppose ur error is at this line
set rs = con.Execute (str)
i think it should be
set rs = con.Execute (sql)
:)



Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"

Also, try wrapping Option Explicit in a server side block:

<% Option Explicit %>

With that setting on, you would have caught and fixed the error much earlier...

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.