IIS on XP Pro Acting Flakey

[Ken Schaefer]

<What I think the problem is />
You are opening an implicit ADODB.Connection object. Since you have no
handle to this object, you can't dipose of it. Since Access isn't designed
as a multi-user DBMS, you run into problems when you want to access the DB
using another connection.

What you should do:

<%
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DSN=cigars"

Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "qryNumberOfCigarsByCountry", objConn

' Do all your existing stuff here

objRS.Close
Set objRS = Nothing

objConn.Close
Set objConn = Nothing
%>

[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;191572[/url]
191572 - INFO Connection Pool Management by ADO Objects Called From ASP

[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/pooling2.asp[/url]
Pooling in the Microsoft Data Access Components

Also, use the native OLEDB Provider if you can:
[url]www.adopenstatic.com/faq/whyOLEDB.asp[/url]

Cheers
Ken


"Jeff Patton" <jeffpatton@cox.net> wrote in message
news:0b7301c36bd4$95989730$a501280a@phx.gbl...
: i am running XPPro with IIS to develop asp pages. i am
: running into a very unusual problem. firstly i have all
: the latest updates from windowsupdate, are there other
: specifically for IIS that i should be aware of? secondly
: this is a fairly straightforward page that i have tried
: doing about three different ways with the same results
: everytime.
:
: the page loads the data from the database is displayed
: when i hit refresh on the browser i get an error message
: that basically says unspecified error on line 14, which
: is where my DNS connection is.
:
: i have a simple table called tblCigars that has a list of
: cigars that i like, i created a
: query "qryNumberOfCigarsByCountry" that displays the
: number of cigars from each country. this was all done
: within AccessXP the DB is in Access2K format. all queries
: work within access, and like i said they even work on
: occasion on the webpage returning the correct
: information.
:
: sometimes if i hit refresh enough the data comes back.
: but its not consistent, once it was refresh 3 times, then
: 20, then 17.

[Phillip Windell]

Get rid of the DSN. Use a DSN-Less connection.


--

Phillip Windell [CCNA, MVP, MCP]
[email]pwindell@wandtv.com[/email]
WAND-TV (ABC Affiliate)
[url]www.wandtv.com[/url]

"Jeff Patton" <jeffpatton@cox.net> wrote in message
news:0c3c01c36bdc$4321c690$a601280a@phx.gbl...

> ok i tried what you ask and i still get the same problem
> except the error has moved down...i haven't tried the
> native stuff yet i was just headed out when u sent this.
> i will do the native provider when i get back.
>
> thanks!
>

> >-----Original Message-----
> ><What I think the problem is />
> >You are opening an implicit ADODB.Connection object.

> Since you have no

> >handle to this object, you can't dipose of it. Since

> Access isn't designed

> >as a multi-user DBMS, you run into problems when you

> want to access the DB

> >using another connection.
> >
> >What you should do:
> >
> ><%
> >Set objConn = Server.CreateObject("ADODB.Connection")
> >objConn.Open "DSN=cigars"
> >
> >Set objRS = Server.CreateObject("ADODB.Recordset")
> >objRS.Open "qryNumberOfCigarsByCountry", objConn
> >
> >' Do all your existing stuff here
> >
> >objRS.Close
> >Set objRS = Nothing
> >
> >objConn.Close
> >Set objConn = Nothing
> >%>
> >
> >[url]http://support.microsoft.com/default.aspx?scid=kb;EN-[/url]

> US;191572

> >191572 - INFO Connection Pool Management by ADO Objects

> Called From ASP

> >
> >[url]http://msdn.microsoft.com/library/default.asp?[/url]

> url=/library/en-us/dnmdac/html/pooling2.asp

> >Pooling in the Microsoft Data Access Components
> >
> >Also, use the native OLEDB Provider if you can:
> >[url]www.adopenstatic.com/faq/whyOLEDB.asp[/url]
> >
> >Cheers
> >Ken
> >
> >
> >"Jeff Patton" <jeffpatton@cox.net> wrote in message
> >news:0b7301c36bd4$95989730$a501280a@phx.gbl...
> >: i am running XPPro with IIS to develop asp pages. i am
> >: running into a very unusual problem. firstly i have all
> >: the latest updates from windowsupdate, are there other
> >: specifically for IIS that i should be aware of?

> secondly

> >: this is a fairly straightforward page that i have tried
> >: doing about three different ways with the same results
> >: everytime.
> >:
> >: the page loads the data from the database is displayed
> >: when i hit refresh on the browser i get an error

> message

> >: that basically says unspecified error on line 14, which
> >: is where my DNS connection is.
> >:
> >: i have a simple table called tblCigars that has a list

> of

> >: cigars that i like, i created a
> >: query "qryNumberOfCigarsByCountry" that displays the
> >: number of cigars from each country. this was all done
> >: within AccessXP the DB is in Access2K format. all

> queries

> >: work within access, and like i said they even work on
> >: occasion on the webpage returning the correct
> >: information.
> >:
> >: sometimes if i hit refresh enough the data comes back.
> >: but its not consistent, once it was refresh 3 times,

> then

> >: 20, then 17.
> >
> >
> >.
> >