Small IIS problem

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Small IIS problem

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> Server Issues >> Small IIS problem

Page: [1]


Giomanach Posts: 6091 Joined: 11/19/2003 From: England Status: offline	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 Posts: 668 Joined: 8/22/2002 From: Butler, PA Status: offline	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? _____________________________ I need to change my avatar--the puppy is full grown now! (in reply to Giomanach)


Giomanach Posts: 6091 Joined: 11/19/2003 From: England Status: offline	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 _____________________________ (in reply to Richard Dudley)


ellipisces Posts: 849 Joined: 12/14/2003 Status: offline	RE: Small IIS problem - 4/24/2004 5:43:11 can we see 11? _____________________________ one step at a time, just replace 4 bulbs with CFL bulbs http://www.climatecrisis.net/ (in reply to Giomanach)


Giomanach Posts: 6091 Joined: 11/19/2003 From: England Status: offline	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 _____________________________ (in reply to ellipisces)

ellipisces

Posts: 849
Joined: 12/14/2003
Status: offline

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...

_____________________________

one step at a time, just replace 4 bulbs with CFL bulbs
http://www.climatecrisis.net/

(in reply to Giomanach)


Giomanach Posts: 6091 Joined: 11/19/2003 From: England Status: offline	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 _____________________________ (in reply to ellipisces)


ellipisces Posts: 849 Joined: 12/14/2003 Status: offline	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? _____________________________ one step at a time, just replace 4 bulbs with CFL bulbs http://www.climatecrisis.net/ (in reply to Giomanach)


Giomanach Posts: 6091 Joined: 11/19/2003 From: England Status: offline	RE: Small IIS problem - 4/26/2004 3:02:32 Yeah..... _____________________________ (in reply to ellipisces)


bickliegh Posts: 4 Joined: 4/29/2004 Status: offline	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 (in reply to Giomanach)


Giomanach Posts: 6091 Joined: 11/19/2003 From: England Status: offline	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 _____________________________ (in reply to bickliegh)