Access Data & ASP Page

  • Thread starter Thread starter Earl Partridge
  • Start date Start date
E

Earl Partridge

Using Windows XP Pro SP2, Access 2000, Frontpage 2000

In FP, with an .asp page I retrieve data from the Access database.
The page displays as expected, but with no data displayed. This is
on my local machine, which uses IIS 5. The ODBC is set properly.
Viewing this page live on my host's site, the data is displayed correctly.

This page worked properly in Windows 98, the problem began with
XP, before SP2.
 
The select statement works fine when used in an Access query.
Also, the page and code work perfectly when executed live on my
host's system.
Earl
 
Further testing, it is not just this one page or select statement. I have
other
asp pages with code retrieving data from an Access database and none of
them will work on my local machine, but all work correctly on my host's
site.

So, I guess that widens the possibility of malfunction to XP, FrontPage
2000,
IIS, or what? Since these pages worked fine with Windows 98 and PWS,
I'm thinking the prime source might be IIS... and I'm over my head in
dealing
with that.

Earl
 
In MS FrontPage, all .asp pages MUST be published to work correctly - simply
put: If you run them from your localhost, you will not see any data returned.

Shane
 
Back
Top