Public Function OpenDB()\r
try\r
select case dbDialect\r
+ ' 32-bit\r
case dbDialects.Access: dbConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("../data/" & defaultDB & ".mdb") & ";User ID=;Password=;")\r
+ \r
+ ' 64-bit\r
+ 'case dbDialects.Access: dbConnection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & server.mappath("../data/" & defaultDB & ".mdb") & ";User ID=;Password=;")\r
+\r
case dbDialects.TSQL: dbConnection = new SqlConnection("Data Source=MATTSPROBOOK\SQLEXPRESS;User ID=userid;Password=password;Initial Catalog=" & defaultDB & ";")\r
case dbDialects.Oracle: dbConnection = new OleDbConnection("Provider=OraOLEDB.Oracle;Data Source=XE;User ID=" & defaultDB & ";Password=Password;")\r
case dbDialects.MySQL: dbConnection = new OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=" & defaultDB & ";USER=userid;PASSWORD=password;")\r
'-------------------------------\r
' set application-wide defaults\r
'-------------------------------\r
- oLiveGrid.highlightElem="menuRow"\r
oLiveGrid.menuEvent=menuevent\r
'Session.Timeout=60\r
end sub\r