Access Data & ASP Page

[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.

 

[Arvin Meyer]

Something is possibly wrong with your select statement. Try it with a local
Access query to see if it returns the data properly.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Earl Partridge]

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

 

[Earl Partridge]

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

 

[Guest]

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