Connection in a function

[sparky68]

It’s been suggested that I put the db connection lines into a function, then include that file on the pages its needed in. has anyone done this? I cant find and code examples on this anywhere.

 

[link9]

put this in a file, and call it conn.asp

include it on any page by putting:

<!-- #include file=&quot;../path/conn.asp&quot; -->

MIGHT look like this (the entire file):

<%
dim con
set con = server.createObject(&quot;ADODB.Connection&quot;)
function openConnection()
  con.open connectionStringHere
end function
function closeConnection()
  con.close
end function
function destroyConnection()
  set con = nothing
end function
%>

then on any page you've included it on, just issue:

openConnection 'to open it
closeConnection 'to close it
destroyConnection 'to get rid of it


paul