Includes with DSN info?

[adknbvi]

Hi,
I have a web application with many (JavaScript) ASP pages. Currently, the following lines are in every one:

var adoConnection = Server.CreateObject("ADODB.Connection"
adoConnection.Open("DSN=MY_DSN"

This connection string may have to change in the future - due to configuration changes in the production environment. I would really like to move these lines into an INCLUDE file and just reference them once.

Can anyone give me an idea of how I would do this? I have tried building a function with just these two lines in it, then calling that function, but it hasn't worked for me. It's like I can't successfully pass "adoConnection" back and forth from the function.

Thanks in advance!

 

[adknbvi]

I think I answered my own question. The first line has to stay in every file, but the second line (the one I anticipate changing in the future) can go into a one-line function. I pass adoConnection back and forth to/from the function and it seems to work.