problem driving MS-Access via ASPs
Posted on 1997-12-10
Not exactly a CGI question, but there's no category here for ASPs, so here goes...
I developed an MS Access v7 DB on my laptop (Win 95) and I'm able to access it from PWS with ASP pages generated by the FrontPage98 database wizard (through ODBC). I can also reach it from ASP pages I hand-coded.
When I moved all of this to Windows NT 4.0/IIS 3.0 I got problems. Even though I've added the DSN entry for the database, the ASP is called and never returns (locking-up IIS). Access v7 is installed on the server.
Is there something extra I need to do with security or accounts for this to work?
That's the only thing I can think of which is added/new with NT. I can run other ASPs (non-DB) on both systems. The Web pages haven't changed and the DSN entry is the same.
Any ideas/thoughts would be very much appreciated.