Debugging problem

[wernerh]

1. When I run Script debugger and I start my ASP app, I put a breakpoint in the global.asa on the Session_OnEnd event.
But I see that this event fires when I start my application!
Why does this happen?

2. Also, On most of my pages I retrive or save data to a SQL database, Currently I have a Connection string in a include file that I include on all my pages. Is it better to just put my Connection string in the Global.asa's Session_OnStart ??

3. Do I need to close my connectionstring in the Session_OnEnd?

4. Can I put Include files in my Global.asa?

5. How do I declare my ADO constants in my global.asa?

[JoshT]

1. When you restart an application, all current sessions end.

2. Yes, as long as it's just the string and not an actual connection object.

3. No, it's just a string. You would open and close the db connection on the individual pages that access the database.

4. I don't think so.

5. I believe you can use a TypeLib to get all constants in the dll. (I keep a printout of ADOVBS.INC by my desk and type the actual values in when I need them rather than using constants).

[monte96]

You can add the ADODB type library but only if you are using IIS 5.0. 4. doesn't support this. (I found out the hard way a while back)

If your using 4.0, you have to either use the literals (Like JoshT does) or include the ADOVBS.INC file on each page that uses ADO constants.