DB not showing

[B. Snell]

I have the following code created which should display a database of events when displayed, but whenever I bring the page up, nothing at all is displayed. I don't know what's wrong...

Any ideas? This is on an NT Server.

Here's the code:

<%
Set MyDb = Server.CreateObject(&#34;ASPdb.pro&#34

MyDb.dbmdb=Server.MapPath(&#34;../fpdb/01sched.mdb&#34
MyDb.dbUnit = 1
MyDb.dbColor = &#34;#FFFFFF, Auto, lightblue&#34;
MyDb.dbImageDir=&#34;../asp/aspimg/&#34;
MyDb.dbGridInc = 10
MyDb.dbGridTableTag = &#34;border=3 cellspacing=3 cellpadding=3&#34;
MyDb.dbGridDisplayFlds = &#34;EventDate,Event Name,Location,City,State/Province,TD&#39;s Name,TD&#39;s Phone&#34;
MyDb.dbMode = &#34;Both&#34;
MyDb.dbFormDisplayFlds = &#34;EventDate,Event Name,Location,City,State/Province,TD&#39;s Name,TD&#39;s Phone,Days,PDGA Tier,Series,Register&#34;
MyDb.dbFilterHideFlds = &#34;ID, URL, Lurl, Comments&#34;
MyDb.dbOptions = &#34;HeaderFontTag=Face=Arial Size=3,CellFontTag=Face=Verdana Size=2,DateWrap=#,DateFormat=mmm/dd/yyyy,AutoCleanUp=True&#34;
MyDb.dbSQL = &#34;Select * from [2002] ORDER BY EventDate&#34;
MyDb.dbNavigation=&#34;both&#34;
MyDb.dbNavigationItem=&#34;top,bottom,next,prev,gr idrow,filter,download&#34;
MyDb.dbNavigationIcon=&#34;std&#34;
MyDb.dbMemoTextSize = 0
MyDb.dbFormMemo=&#34;5x50,comments&#34;
MyDb.dbMagicCell = &#34;TD&#39;s Name,,<A HREF=&#34;&#34;mailto:#E-Mail#&#34;&#34;>#TD&#39;s Name#;Event Name,,<A HREF=#URL#>#Event Name#</A>;Location,,<A HREF=#Lurl#>#Location#</A>;Register,,<A HREF=#Active#>#Register#</A>&#34;

Mydb.dbEditParams=&#34;TableName=2002,BookMarkFlds =ID,TableTag=Border=2,RecordScope=single,CriteriaS ize=4x25&#34;

MyDb.ASPdbpro
%>

************************************************** **************************
Any help at all is appreciated!
Thanks,
--Bart Snell

[Frank Kwong]

1. Try to update your veryold version of ASP-db.
2. Cannot see how it break with your own code.
3. Reproduce the problem with Northwind and re-post the code.
4. Send in a small version of your .mdb file 5 records so we can take a quick lookfor you. (do this only if you have a maintenance contract)

FK

------------
B. Snell at 12/31/2001 10:39:50 AM


I have the following code created which should display a database of events when displayed, but whenever I bring the page up, nothing at all is displayed. I don&#39;t know what&#39;s wrong...

Any ideas? This is on an NT Server.

Here&#39;s the code:

<%
Set MyDb = Server.CreateObject(&#34;ASPdb.pro&#34

MyDb.dbmdb=Server.MapPath(&#34;../fpdb/01sched.mdb&#34
MyDb.dbUnit = 1
MyDb.dbColor = &#34;#FFFFFF, Auto, lightblue&#34;
MyDb.dbImageDir=&#34;../asp/aspimg/&#34;
MyDb.dbGridInc = 10
MyDb.dbGridTableTag = &#34;border=3 cellspacing=3 cellpadding=3&#34;
MyDb.dbGridDisplayFlds = &#34;EventDate,Event Name,Location,City,State/Province,TD&#39;s Name,TD&#39;s Phone&#34;
MyDb.dbMode = &#34;Both&#34;
MyDb.dbFormDisplayFlds = &#34;EventDate,Event Name,Location,City,State/Province,TD&#39;s Name,TD&#39;s Phone,Days,PDGA Tier,Series,Register&#34;
MyDb.dbFilterHideFlds = &#34;ID, URL, Lurl, Comments&#34;
MyDb.dbOptions = &#34;HeaderFontTag=Face=Arial Size=3,CellFontTag=Face=Verdana Size=2,DateWrap=#,DateFormat=mmm/dd/yyyy,AutoCleanUp=True&#34;
MyDb.dbSQL = &#34;Select * from [2002] ORDER BY EventDate&#34;
MyDb.dbNavigation=&#34;both&#34;
MyDb.dbNavigationItem=&#34;top,bottom,next,prev,gr idrow,filter,download&#34;
MyDb.dbNavigationIcon=&#34;std&#34;
MyDb.dbMemoTextSize = 0
MyDb.dbFormMemo=&#34;5x50,comments&#34;
MyDb.dbMagicCell = &#34;TD&#39;s Name,,<A HREF=&#34;&#34;mailto:#E-Mail#&#34;&#34;>#TD&#39;s Name#;Event Name,,<A HREF=#URL#>#Event Name#</A>;Location,,<A HREF=#Lurl#>#Location#</A>;Register,,<A HREF=#Active#>#Register#</A>&#34;

Mydb.dbEditParams=&#34;TableName=2002,BookMarkFlds =ID,TableTag=Border=2,RecordScope=single,CriteriaS ize=4x25&#34;

MyDb.ASPdbpro
%>

************************************************** **************************
Any help at all is appreciated!
Thanks,
--Bart Snell