application object vs includes file

[Luis]

Is it better to :
- use an application object to store my database connection string or
- use an include file on each asp page that needs to connect to the
database?

Example:

Using the application object I could use the following in my global.asa
file:

<SCRIPT LANGUAGE=VBScript RUNAT=Server>
SUB Application_OnStart
Application("ConnString") = "PROVIDER=myprovider; DATA SOURCE=myserver;
USER ID=myid; PASSWORD=mypass"
Application("Server_Name") = "http://mydev/mysystemname/"
END SUB

SUB Application_OnEnd
END SUB

SUB Session_OnStart
startPage = "login.asp"
Session.Timeout = 15
END SUB
</SCRIPT>

Then I just add:
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open Application("connstring")
to each of the asp pages that need to connect to the database.


Alternatively, when using an includes file (eg. dbConnect.inc) I would
put the following in the .inc file:

Dim connStr, conn
connStr = "PROVIDER=myprovider; DATA SOURCE=myserver; USER ID=myid;
PASSWORD=mypass"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Mode = 3
conn.Open connStr

And then include the dbConnect.inc file in each of my pages that need to
connect to the database this way:

<!-- #INCLUDE file = "dbConnect.inc" -->


Which is the better method?
Does one have a performance advantage over the other?


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Jeff Cochran]

On Fri, 13 Aug 2004 04:21:48 -0700, Luis <andyzaNOSPAM@webmail.co.za>
wrote:

>Is it better to :
> - use an application object to store my database connection string or
> - use an include file on each asp page that needs to connect to the
>database?

Absolutely.

>Which is the better method?

Depends on your individual site/application/needs

>Does one have a performance advantage over the other?

See answer to the above question.

Google the groups for many discussions on this. There are pros and
cons on both, and the only place it can be determined is on your
specific system for your specific application in your specific
environment.

Jeff