Small IIS problem

Small IIS problem (Full Version)

All Forums >> [Web Development] >> Server Issues

Message

Giomanach -> Small IIS problem (4/21/2004 16:28:42)
Using IIS to view a site locally, written in ASP, and every now and then, I get unspecified error in line 11 of home.asp I know there's nothing wrong with the ASP, b'cos it works fine, it's after every 5 to 10 refreshes of the page I get the error. Tried - Re-installing IIS, Restarting IIS Any Ideas? Cheers Dan

Richard Dudley -> RE: Small IIS problem (4/21/2004 20:24:14)
What's line 11, and what's the error? What's the page doing? If it's accessing a database, maybe you have too many db connections open with 5-10 refreshes?

Giomanach -> RE: Small IIS problem (4/22/2004 3:35:52)
All the ASP is doing is calling a record from the database to display on the page. I have closed the connection to the database as well. Error is Unspecified Error, everytime. I'm only opening the DB connection once. Might need to re-close to connection. It's also on the Snitz forum as well, evey 5-10 refreshes. Line 11 of default.asp Unspecified error[&:], Only bit I've fiddled with in there is adding a nav bar to the header for site integration Dan

ellipisces -> RE: Small IIS problem (4/24/2004 5:43:11)
can we see 11?

Giomanach -> RE: Small IIS problem (4/24/2004 16:00:10)
Sure adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("DBs/homepage.mdb") I use tehsame line for opening all DB connections. This is the only one in the ASP doc. I close the connection usind End if and/or adoCon.Close depends on what I'm writing the script for, the error happens with both. Might also want to add, I also have Coldfusion and PHP installed on IIS as well Dan

ellipisces -> RE: Small IIS problem (4/25/2004 4:36:06)
quote: DRIVER={Microsoft Access Driver confirm Richards suggestion Access is only available for 10 connections, but here's the kicker, each connection uses two! one up, one down. If the server has not finished releasing a connection then it would throw the error "cannot access the database or something like that...

Giomanach -> RE: Small IIS problem (4/25/2004 10:54:19)
Ok, what connection type should I be using then? I've used it before without a hitch

ellipisces -> RE: Small IIS problem (4/26/2004 2:36:30)
its not the connection type it's a limitation of the back-end database you would want to develop and connect to MSsql. (ASP) right?

Giomanach -> RE: Small IIS problem (4/26/2004 3:02:32)
Yeah.....

bickliegh -> RE: Small IIS problem (4/29/2004 11:40:03)
You may want to have a look at the following links. Might give you some clues. You receive an "unspecified error" error message when you create more than 64 connections to an Access Database in one process. http://support.microsoft.com/default.aspx?scid=kb;en-us;830133 Memory Usage Increases When Querying an Access 97 DB w/ ASP http://support.microsoft.com/default.aspx?scid=kb;en-us;177226 Recommendations for Connecting to Databases Through Internet Information Services. http://support.microsoft.com/default.aspx?scid=kb;en-us;258939 Opening an Access Database by Using ADO. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovropeningaccessdatabasebyusingado.asp Bickleigh

Giomanach -> RE: Small IIS problem (4/29/2004 11:45:57)
I'm re-writing the coding for a Linux server, so I don't really need to solve this problem right now. It's prolly due to me playing with XPs innards[8D]

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

9.570313E-02