ASP ADO Problem - TechRepublic
General discussion
December 8, 2000 at 06:03 AM
sean s.

ASP ADO Problem

by sean s. . Updated 25 years, 5 months ago

Here’s something that I’m not even sure if its a programming problem or an NT/IIS problem: I’ve created with Interdev an ASP script what uses ADO for an Access database from on my NT 4.0 Workstation and it works perfectly there and on other NT workstations & servers. But when I tranfer it to a specific NT Server, it doesn’t work. But it doesn’t give me an error; it just sits there until it times out. I know its the ADO connection because the server can run an ASP script fine without the database stuff. I checked and double checked the system DSN that I made for the database and it seems to be right. I created a Visual Basic program that opens the database w/ ADO just to see if there is some sort of problem with the database itself and that works perfectly. I even put some of the database stuff into a COM and an ASP script can run that. It just seems to be a problem when an ASP script tries to use the database directly. Is there something special that I have to put into the script?Or is there something on the server I have to change? I’ve been working on this problem for about 2 months now so any suggestions would be helpful…

This discussion is locked

All Comments