<!--#include file=_ScriptLibrary/ADOJS.INC-->
<%
// ============================================
// database configuration
// ============================================

//Connection and Recordset objects
var oConnection;
var oRecordset;

// OLE DB Provider constants
var sAccess9x = 'Microsoft.Jet.OLEDB.2.5';
var sAccess97 = 'Microsoft.Jet.OLEDB.3.51';
var sAccess2000 = 'Microsoft.Jet.OLEDB.4.0';
var sSQLServer = 'SQLOLEDB.1';

// which am I using?
var sDBDriver = sAccess2000;

var sConnectionString = 'Provider=' + sDBDriver + '; ';

if ( -1 == sDBDriver.indexOf ( 'Jet' ) )
	// SQL Server database
	sConnectionString += 'Server=SQLDB; Trusted_Connection=Yes; Database=DB';
else
	// Access database
	sConnectionString += 'Data Source=' + 'C:\\Websites\\Epicenter\\Database\\jobs.mdb';

	
//open the database connection
function DBConnect()
{
	//if connection is open exit function
	if (oConnection != undefined)
		return;	
		
	//Create connection object
	oConnection = Server.CreateObject ('ADODB.Connection');
	
	//Open Database
	if oConnection.State = 0 then	'only open if the connection is closed
		oConnection.Open (sConnectionString);
	end if
}

//Release the database connection and the recordset
function DBDisconnect()
{
	//Close and release recordset object
	if (oRecordset != undefined && oRecordset.State != adStateClosed)
		{
			oRecordset.Close();
			oRecordset = undefined;
		}
	
	//Close and release recordset object
	if (oConnection != undefined && oConnection.State != adStateClosed)
		{
			oConnection.Close();	
			oConnection = undefined;
		}
}

function DBShowTables()
{
	
	//Create recordset object
	oRecordset = Server.CreateObject('ADODB.Recordset');
	
	//get all tables
	oRecordset = oConnection.OpenSchema (adSchemaTables);
	Response.Write ('<select name="Tables">');
	Response.Write ('<option value="None">Select...</option>');
	while ( !oRecordset.EOF )
		{ 
			if ( oRecordset ( 'TABLE_TYPE' ) == 'TABLE' ) 
				{ 
					var sTableName ="" + oRecordset('TABLE_NAME'); 
					Response.Write ( '<option value="' + sTableName + '">' + sTableName + '</option><br>' );
				} 
		oRecordset.MoveNext();
		}
	Response.Write ('</select>');
	oRecordset.Close;

	oRecordset.Open ('MANAGER', oConnection);
	oRecordset.Sort;
	Response.Write ('<table border=1><tr>');
	
	for (var i=0; i < oRecordset.Fields.Count;i++)
		Response.Write ('<td>' + oRecordset.Fields(i).Name + '</td>');
	
	Response.Write ('</tr><tr>');
	
	while (!oRecordset.EOF)
		{
			for (var i=0; i < oRecordset.Fields.Count;i++)
				Response.Write ('<td>' + oRecordset(i) + '</td>');
				
			Response.Write ('</tr>');
			oRecordset.MoveNext();
		}
	Response.Write ('</table>');
}

%>