DB Connection :: Global.use vs .Inc file?

I am adapting a login script to suite my specific purposes by require
guideance on best practice with regards the following:

Should I be initiating the database connection in the global.asa or via the
existing database include file I have at the moment....

My current database utitliy include allows my to grab the file but I am
wondering if it makes sense to dispense with this segment of the code and
place
it in the global.aso....See below


function GetConnection()
const DSN = "V032U10DUW"
const UID = "V032U10DUW"
const PASSWORD = "cU3QmtgDyzWX"



Dim p_oConn, sDSN
Set p_oConn = server.createObject("ADODB.Connection")
'//sDSN = "DSN=" & DSN & ";uid=" & UID & ";password=" & PASSWORD
'//sDSN.open = "driver={SQL
Server};server=MAXSQL00?.maximumasp.com;DB=yourSQL DBName;UID=yourSQLLogin;PW
D=YourSQLPassword"
p_oConn.open "driver={SQL
Server};server=MAXSQL008.maximumasp.com;DB=V032U10 DUW;UID=V032U10DUW;PWD=cU3
QmtgDyzWX"
Set GetConnection = p_oConn
end function

function GetStoredProcedure(oConnection, sName)
Dim oCmd
Set oCmd = Server.createobject("ADODB.Command")
Set oCmd.ActiveConnection = oConn
oCmd.CommandText = sName
oCmd.CommandType = adCmdStoredProc
Set GetStoredProcedure = oCmd
end function

[Bob Barrows [MVP]]

[email]jason@catamaranco.com[/email] wrote:

> I am adapting a login script to suite my specific purposes by require
> guideance on best practice with regards the following:
>
> Should I be initiating the database connection in the global.asa or
> via the existing database include file I have at the moment....
>
> My current database utitliy include allows my to grab the file but I
> am wondering if it makes sense to dispense with this segment of the
> code and place
> it in the global.aso....See below

[url]http://www.aspfaq.com/show.asp?id=2053[/url]

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"