ADO Connections and ASP...

[BazR]

What is the preferred method of ADO connection creation?

Should the ADO connection be created within Global.asa file, and stored in application object, for everyone to use, or should connection be created and close, each instance it is required?

 

[mwolf00]

In order to use connection pooling (the most efficient approach), I store my connection string in an application variable (created in the global.asa application_onStart). Then create, open, and close the connection on each page as needed.

set objConn = server.createObject("adodb.connection&quot
objConn.open(application("connStr&quot)
set rs = objConn.execute("select fieldName from TableName&quot
objConn.close
set objConn = nothing

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rich Cook

 

[BazR]

Ok thanks, had been storing the ADO Connection object in the Application object, upon application_onStart, but have read that this is not best.