That's a bad way of doing things.
You should be:
a) opening an explicit connection object
b) setting the recordset's .ActiveConnecti on property to the connection
object
c) explicitly closing the connection object at the end of the page
<%
Set objConn = Server.CreateOb ject("ADODB.Con nection")
objConn.Open MM_connPPL2_STR ING
Set objRS = Server.CreateOb ject("ADODB.Con nection")
Set objRS.ActiveCon nection = objConn
'
' Rest of the page here
'
objConn.Close
Set objConn = Nothing
%>
At the moment you are implicitly creating a connection to the database, but
you never closing it. It's hanging around until it eventually times out. The
number of open connections is probably building up until you get this error.
Cheers
Ken
"Iona" <io**********@h otmail.com> wrote in message
news:72******** ****@Asp.Forums Zone.com...
: Thanks for the reply it helped me but then I get this
:
: Error Type:
: Provider (0x80004005)
: Unspecified error
: /asp/PPLMain/memberpage.asp, line 10
:
: and my line 10 is still
:
: RsMember.Active Connection = MM_connPPL2_STR ING
:
: I dont understand. Anyone can help me?
:
: -----------------------------
: This message is posted by
http://Asp.ForumsZone.com
: