No records displayed

[Kathy]

We have just purchased ASP-db and I am not able to get it to work properly. I tried the sample code below:


<%
Set MyDb = Server.CreateObject(&#34;ASP.db&#34
MyDb.dbMDB = Server.MapPath(&#34;places.mdb&#34
MyDb.dbColor = &#34;7&#34;
MyDb.dbMode = &#34;dual&#34;
MyDb.dbGridTableTag = &#34;Border=3&#34;
MyDb.dbSQL = &#34;Select * FROM Places&#34;
MyDb.ASPdb
%>

and got the following message when I ran it:

Warning: User supplied query returns no records for display
Select * FROM Places

I know there are records in the table. Any suggestions would be appreciated.

Thanks

[Frank Kwong]

if you purchased ASP-db please use the Designer to get it going to eliminate these simple problems. Designer will read your ODBC, Schemas etc.... and will generate teh ASP-db code for you.


FK


------------
Kathy at 2/22/01 2:06:16 PM

We have just purchased ASP-db and I am not able to get it to work properly. I tried the sample code below:


<%
Set MyDb = Server.CreateObject(&#34;ASP.db&#34
MyDb.dbMDB = Server.MapPath(&#34;places.mdb&#34
MyDb.dbColor = &#34;7&#34;
MyDb.dbMode = &#34;dual&#34;
MyDb.dbGridTableTag = &#34;Border=3&#34;
MyDb.dbSQL = &#34;Select * FROM Places&#34;
MyDb.ASPdb
%>

and got the following message when I ran it:

Warning: User supplied query returns no records for display
Select * FROM Places

I know there are records in the table. Any suggestions would be appreciated.

Thanks