<%

'*** YOUR DATABASE ***
'-- Select the type of Database you are going to use by remove the first sign in front of line 

	 'DATABASE = "MSACCESS"
	 DATABASE = "MySQL"	 
	 'DATABASE = "MSSQL"
	 
' Now, follow the instructions below to setup your selected type of Database


'------------------------------------------------------------------------------------------------------------------------------
'***** SETUP FOR USING >>MS ACCESS<< DATABASE STARTS HERE ***** 
'------------------------------------------------------------------------------------------------------------------------------
'--->    Follow the directions below to set up a password on your MS Access 2000 Database.
'--->    Open Microsoft Access 2000
'--->    On the File menu, click Open.
'--->    Click the arrow to the right of the Open button, and then click Open Exclusive.
'--->    On the Tools menu, point to Security, and then click Set Database Password.
'--->    In the Password box, type your password. Passwords are case-sensitive.
'--->    In the Verify box, confirm your password by typing the password again, and then click OK. 
'--->    The password is now set.
'--->    The next time you open the database in MS ACCESS, a dialog box will be displayed that requests a password.

'--->    Remove the first sign. Add your Database password between the "" in line below (Leave if no password set)
    	 'dbPassword = ""

'--->    Remove the first sign. Add your Database path in line below (only change if required)
	     'PathToDatabase = "/JBSX/JBSX.mdb"

'--->    Remove the first sign. Add your MS Access Connection String in line below (Only change if required)
	     'myDataSourceName = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(PathToDatabase) & ";pwd=" & dbPassword
	     
'------------------------------------------------------------------------------------------------------------------------------
'***** SETUP FOR USING >>MS ACCESS<< DATABASE ENDS HERE *****
'------------------------------------------------------------------------------------------------------------------------------


'------------------------------------------------------------------------------------------------------------------------------
'***** SETUP FOR USING >>My SQL<< DATABASE STARTS HERE *****
'------------------------------------------------------------------------------------------------------------------------------
'--->    Remove the first sign. Add your `MySQL Driver´ between the "" in line below (Only change if required)
    	 myDRIVER = "MySQL ODBC 3.51 Driver"
    	 
'--->    Remove the first sign. Add your `Server between´ the "" in line below
    	 mySERVER = "localhost"
    	 
'--->    Remove the first sign. Add your `Database Name´ between the "" in line below
    	 myDATABASE = "jbsx"
    	 
'--->    Remove the first sign. Add your `Database User Name´ between the "" in line below
    	 myUID = "admin"
    	 
'--->    Remove the first sign. Add your `Database Password´ between the "" in line below
    	 myPWD = "crackerjack69"
    	 
'--->    Remove the first sign in line below 
		 myDataSourceName = "DRIVER={" & myDRIVER & "};SERVER=" & mySERVER & ";DATABASE=" & myDATABASE & ";UID=" & myUID & ";PWD=" & myPWD & ";OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384
'------------------------------------------------------------------------------------------------------------------------------
'***** SETUP FOR USING >>My SQL<< DATABASE ENDS HERE *****
'------------------------------------------------------------------------------------------------------------------------------


'------------------------------------------------------------------------------------------------------------------------------
'***** SETUP FOR USING >>MSSQL<< DATABASE STARTS HERE *****
'------------------------------------------------------------------------------------------------------------------------------
'--->    Remove the first sign. Add your `MSSQL Provider´ between the "" in line below (Only change if required)
    	 'sqlPROVIDER = "SQLOLEDB"

'--->    Remove the first sign. Add your `Initial Catalog/Database Name´ between the "" in line below
    	 'sqlDATABASE = ""
    	 
'--->    Remove the first sign. Add your `Data Source/Host name´ between the "" in line below
    	 'sqlDATASOURCE = ""
    	 
'--->    Remove the first sign. Add your `User Id/Database User Name´ between the "" in line below
    	 'sqlUID = ""
    	 
'--->    Remove the first sign. Add your `Database Password´ between the "" in line below
    	 'sqlPWD = ""
    	 
'--->    Remove the first sign in line below 
		 'myDataSourceName = "Provider=" & sqlPROVIDER & ";Initial Catalog=" & sqlDATABASE & ";Data Source=" & sqlDATASOURCE & ";User Id=" & sqlUID & ";Password=" & sqlPWD & ";"


'------------------------------------------------------------------------------------------------------------------------------
'***** SETUP FOR USING >>MSSQL<< DATABASE ENDS HERE *****
'------------------------------------------------------------------------------------------------------------------------------


'-----------------------------------------------
'CREATE OBJECT (Do NOT change line below)
'-----------------------------------------------
	Set Conn = Server.CreateObject("ADODB.Connection")
	Conn.Open myDataSourceName

%>