<% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# dim strPath, strCustomDatabaseName strCustomDatabaseName = Request.QueryString("dbname") if strCustomDatabaseName <> "" then strPath = Replace(Request.ServerVariables("PATH_TRANSLATED"), "whereami.asp",strCustomDatabaseName) else strPath = Replace(Request.ServerVariables("PATH_TRANSLATED"), "whereami.asp","snitz_forums_2000.mdb") end if Response.Write "" & vbNewLine & vbNewLine & _ "" & vbNewLine & _ "Where Am I?" & vbNewLine & _ "" & vbNewLine & vbNewLine & _ "" & vbNewLine & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
" & vbNewLine & _ " " & vbNewLine & _ "

Where Am I?

" & vbNewLine & _ "

" & vbNewLine if strCustomDatabaseName = "" then Response.Write("

snitz_forums_2000.mdb is used as an example database name.
If you have changed the name of your database, you'll need to change it in the strConnString example shown below, as well.

" & vbNewLine) Response.Write "

Physical Path to Database: " & strPath & "

" & vbNewLine & _ "

Example strConnString:

" & vbNewLine & _ "

This one will work with either Access97, Access2000 or Access2002:

" & vbNewLine & _ "

strConnString = ""Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath & """ '## MS Access 2000

" & vbNewLine & _ "

Use the following only if you can't get the first one to work
One reason could be that your host doesn't have the MSJet Drivers installed:

" & vbNewLine & _ "

strConnString = ""DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & strPath & """ '## MS Access 97

" & vbNweLine & _ "

" & vbNewLine & _ " " & vbNewLine & _ "
" & vbNewLine & vbNewLine & _ "" & vbNewLine & vbNewLine & _ "" & vbNewLine %>