DSN Hanging up in ASP

tomandsandy · Sep 28, 2001

I created a web sight which handles shipment tracking for a company in New York State. It seems to work okay initially. The database updates fine from the web. When I go back to view a list of shipments it sometims gives me an unspecified error on the line of code which assigns the DSN. If I go back and refresh 2 minutes later it works. It seems as though the table is locking for a short specific amount of time. Is thereany setting I am missing? I have written ASP pages before but never came across this.

I am running:
IIS5
Access 2000 MDB
Front Page 2000

FengShui1998 · Oct 2, 2001

tomandsandy,

On your first web page, make sure you close the connection after retrieving your data.

Also, you might want to use the following so that your data is not cached. Place betwen the <head> and </head> tags.

<META HTTP-EQUIV="Pragma" CONTENT="no-cache">

fengshui1998

tomandsandy · Oct 6, 2001

I closed all of the connections. I'll try the Meta Tag.

Thanks

iracleous · Oct 8, 2001

Unfortunately, Access is not good for proffesional use in the web. It is very good only for standalone use.
Try to upgrade to SQL.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

DSN Hanging up in ASP

tomandsandy

Programmer

FengShui1998

MIS

tomandsandy

Programmer

iracleous

Programmer

Similar threads

Part and Inventory Search

Sponsor