PWS and multiple connection woes

[AlaskanDad]

I'm running PWS on my Win98 and want to check on my ASP programming. I've put in very simple FrontPage quality hyperlinks to ensure that I don't have faulty or complicated code causing problems.

It seems that everytime I click on a hyperlink on one of my pages, I get another connection. When I get to 10 connections, PWS gives me the "I'm full" message. I'm the only one hitting these pages and only have one browser open.

Why is this happening and will it also happen if I take these pages to a REAL web-server? I want to set up my ASP pages as sessionless if at all possible.

Should I use a Session.Abandon at the end of my code?

I would really like to get these pages to the web and start making money off of them!!!!! Please help.

 

[Bastien]

close your connections when you are finished with them....

conn.close

best to open the connection, execute the sql and then close the connection

don't forget to [red]set conn=nothing[/red] to destory the connection variable

hth Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[AlaskanDad]

Wow! Thanks for your reply.

Even though I fixed this problem a long time ago, I have a follow up question for you.

Do I have to have:

conn.close

if I run a

set conn = nothing

at the end of the page.

Will destroying the variable close the connection as well? I have many pages opening my current connection but I never close the connection. I just set it to nothing each time.

Am I slowly killing myself here with tons of open connections?

BTW, I AM making money off my pages now!! Such a proud statement from a completely self-taught novice.

 

[Bastien]

best to close then destroy...it ensures that all conns are closed

sorry for the late reply..I was doing a search on something else and your post came up and just thouht i's answer it

Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[AlaskanDad]

Assuming by the speed of your reply that you're online now...

In your opinion, would I see a dramatic increase in performance if I change all of my set conn=nothing to conn.close?

I have hundreds of members on my site daily and they're constantly opening up the same connection string.