Solved

problem driving MS-Access via ASPs

Posted on 1997-12-10
1
160 Views
Last Modified: 2013-12-25
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.
0
Comment
Question by:klamerus
1 Comment
 
LVL 1

Accepted Solution

by:
nanullnet earned 100 total points
ID: 1831617
I believe that your access DB must be accessible by the Web Server, or at least the DSN.  Did you set up the DSN as a "System DSN"?  It must be for the web server to access it.  Did you test the access when you created the DSN?  Also make sure that you supply the correct Username and Password info in you connect info ""DSN=xxxx;UID=xxxx;PWD=xxxx;DATABASE=xxxx;"
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

The following is a collection of cases for strange behaviour when using advanced techniques in DOS batch files. You should have some basic experience in batch "programming", as I'm assuming some knowledge and not further explain the basics. For some…
This tutorial will discuss fancy secure registration forms, with AJAX technology support. In this article I assume you already know HTML and some JS. I will write the code using WhizBase Server Pages, so you need to know some basics in WBSP (you mig…
Learn the basics of lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now