I have a site with several ASP enabled pages that all access the same SQL Server database. Some of the scripts are writen in JavaScript others are writtend with VBScript.

When the site used all one language I used to have a function definition in an include file that would take a connection object as a parameter and connect it to my database. Then if anything about the server changed, I could change it in one place and be done with it.

Unfortunately now that there is not a consistent language across our site I can't write a function definition that will work for all pages. I've tried doing something like:

<% ...
conn.Open %><%
...%>

but it only works with JavaScript not in VBScript.

I'm fairly new with web programming, does anyone know how I could store my connection string in just 1 file and still access it easily from both languages?

in your include file you could make it a function called maybe GetConnectionString, that returns the connection string. Then in your code you would do:

<%...
conn.Open GetConnectionString()
..%>
that should work from both languages.

The problem is VB and Java define functions differently.

1) Java encloses the body of the function in curly braces while VB uses an End Function keyword.
2) Java uses the return keyword while VB uses [function name] = [return value]

So unfortunately I cannot write 1 function for both languages. What I really need is a way to initialize a variable to the contents of a file. Maybe access the file via the script itself with a file object? Would this be a bad way of going about it?

Thanks,
Mike