<%
	'This file sets up the database connection and "sql" variable for all the files in which
	'it is contained.  The currently selected connection string assumes that there is a DSN
	'(Data Source Name - i.e. an alias for a database) set up on the system named "tcwinds"
	'To set up/edit this DSN, go to Start->Settings->Control Panel-> Administrative Tools->
	'Data Sources (ODBC) and select the "System DNS" tab at the top.
	Dim recordset
	Dim sql
	Dim connobj
	Set connobj = Server.CreateObject("ADODB.Connection")
	'connobj.Open ("DSN=tcwinds;")

	'This connection string can be used if the DSN is giving you an "Unspecified Error" error.
	'The only difference is that this one specifies an empty string for both the User ID and
	'password, which can sometimes help aleviate the problem
	'connobj.Open "DSN=tcwinds;UID=;PWD=;"

	'This connection string can be used to point directly to the database
	connobj.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\wwwroot\corp\Symposium\symposium_registration.mdb")
%>