📄 readme.htm
字号:
</center>
<p>Using one of the above connection strings allows you to connect to your database if you are uncertain
of the physical path to your database. It uses the <b>Server.MapPath()</b> method to find
the physical path to your database.<br><br>
The <b>Server.MapPath()</b> method starts from the root of your website, to the path you specify.
For example, if your folders are setup like the following:</p>
<pre>
/Root
/www
/forum
/images
/cgi-bin
</pre>
<p>And you have your database in the cgi-bin folder, then the relative path to your database would be
<font color="#003399">/cgi-bin/snitz_forums_2000.mdb</font>. Using this, your connection string would
look like the following:
<p>strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("<font color="#003399">/cgi-bin/snitz_forums_2000.mdb</font>")
'## MS Access 2000 using virtual path<br><br>
This path should be local on the server, and not a web path. (NOT http://) You can always use the
<b>whereami.asp</b> file to help you determine the relative path to your database. The <b>whereami.asp</b>
file will show you the full physical path to your database. From that path you can determine the relative
path to your database.<br><br>
Make sure to remove the <font color="#FF0000"><b>'</b></font> from the beginning of the connection
string you are going to use.</p><br></td>
</tr>
<tr>
<td>
<b>Option 3: Users on Brinkster's free server</b><br>
<center>
<form>
<textarea cols="70" rows="3" name="ConnString3" wrap="off" readonly>
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
</textarea>
</form>
</center>
<p>We have provided connection strings for users who have their forums hosted on Brinkster's free server.
All that is needed for you to do is to replace the <b><font color="#800080">"USERNAME"</font></b>
with your Brinkster username, that you signed up with and remove the
<font color="#FF0000"><b>'</b></font> from the beginning of the line.<br><br>
For example, if your Brinkster username is <b><font color="#003399">"JohnDoe"</font></b>
then your connection string would look like this:<br><br>
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/<b><font color="#003399">JohnDoe</font></b>/db/snitz_forums_2000.mdb")
'## MS Access 2000 on Brinkster<br><br></p>
<p class="note"><b>NOTE:</b> If you change the name of your database, you will need to make that change in your
connection string too.</p>
</td>
</tr>
</table>
</td>
</tr>
<tr bgcolor="#f5f5f5" valign="top">
<td bgcolor="#000066" align="left"><font color="#FFFFFF"><b>Microsoft SQL and MySQL database</b></font></td>
</tr>
<tr bgcolor="#f5f5f5" valign="top">
<td>
<br>
Before installing on an MS SQL or MySQL database, you need to have a database already created to use.
This can be a new, empty database, or an existing database that you are using for the rest
of your site. If you are unsure which database you can use, please contact your host and
ask them which one they support.
<center>
<form>
<textarea cols="70" rows="5" name="ConnString4" wrap="off" readonly>
strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
strConnString = "driver=MySQL;server=SERVER_NAME;uid=UID;pwd=PWD;database=DBNAME" '## MySQL
</textarea>
</form>
</center>
<p>There are 2 connection strings available to connect to a MS SQL database and 1
connection string to connect to a MySQL database as you can see above. For MS SQL databases
we suggest you use the first MS SQL connection string as it is more efficient.<br><br>
You will need the following information to connect to your database:<br>
<font color="#808000"><b>SERVER_NAME</b></font>: This is usually 'localhost',
an IP address such as '198.0.1.163' or a server address such as 'mysql.server.com', depending
on your host. This is not the url for your website.<br>
<font color="#008080"><b>UID</b></font>: This will be the username that has permission
to connect to the database.<br>
<font color="#FF00FF"><b>PWD</b></font>: This will be the password for the username to
connect to your database.<br>
<font color="#FF6600"><b>DB_NAME</b></font>: This is the name of your
database.<br><br>
Please contact your host if you are uncertain about what to put for each value.<br><br>
Remove the <b><font color="#FF0000">'</font></b>
from the beginning of the connection string you wish to use and
fill in the information you gathered earlier.<br> </p></td>
</tr>
<tr bgcolor="#f5f5f5" valign="top">
<td bgcolor="#000066"><b><font color="#FFFFFF">DSN</font></b></td>
</tr>
<tr bgcolor="#f5f5f5" valign="top">
<td>
<br>
<p>If you would like to use a DSN (Data Source Name) connection, to connect to your database
instead, there is a connection string you can use.
<pre>strConnString = "DSN_NAME" '## DSN</pre>
Remove the <font color="#FF0000"><b>'</b></font> from in front of the strConnString
example marked '## DSN. Replace the <b><font color="#800080">"DSN_NAME"</font></b>
with the name of your DSN connection. If your DSN name is <font color="#003399"><b>"MyDatabase"</b></font>
then your connection string will look like this:
<pre>strConnString =<b><font color="#003399"> "MyDatabase"</font></b> '## DSN</pre></p></td>
</tr>
</table>
</li>
<br><br>
<li><b>Setting the Table Prefixes:</b><br>
<font color="#FF6600"><b>NOTE:</b> Change these settings only if you will be running more than one
forum using the same database.</font>
<p>Each forum that is using the database needs to have a unique string
prefix for its tables. The default prefix is "FORUM_" for both the
members table and the forum tables. You will need to change this from the default value
for each additional forum you have setup, if you want each forum to share the same database.<br>
<br>
If you wish to share members information between multiple forums that uses the
same database, then you need to use the same prefix for the "<font color="#003399">strMemberTablePrefix</font>"
for the other forums you wish to share the members information with. <br></p></li>
<li><p>Upload the files (except the Access database) to a folder on
your server. Usually: <b>/forum/</b><br>
<font color="#008000"><b>TIP: </b>It is recommended that you use an FTP
client in ASCII transfer mode to upload your ASP files.</font></p></li>
<li><b>Uploading & Setting up the database:</b><br>
<table border="0" cellspacing="1" cellpadding="3" bgcolor="#000000" bordercolor="#111111">
<tr bgcolor="slateblue">
<td bgcolor="#000066" width="33%" align="left"><a name="accdbupload"></a><b><font color="#FFFFFF">New Install - ACCESS</font></b></td>
</tr>
<tr bgcolor="#f5f5f5" valign="top">
<td>
<br>
<font color="#FF6600"><b>NOTE:</b> Access databases can only be used on a Windows Server.
You will need to use a MySQL or MS SQL database if you are on a Unix Server.</font>
<p>Upload the Access Database file to a folder that has Read|Write permissions. Common examples
of folders with Read|Write permission are:<br>
Examples: /cgi-bin/
/fpdb/ /database/ /db/<br><br>
<font color="#008000"><b>TIP:</b> It is advisable to make sure this directory is not
accessible by the web to stop people from downloading your database.</font><br><br>
<font color="#FF6600"><b>NOTE:</b> Setting folder permissions on a Windows Server is different from setting permissions
on a Unix Server. On a Unix Server you can change file/folder permissions using your FTP program.
With a Windows Server, you will need to contact your host to change permissions on a file/folder.
Or use the Windows Explorer to change permissions of a file or folder, if you are running your own
server.</font><br><br>
If you are running your own server, you need to make sure that the
"IUSR_YOURMACHINENAME" account (or EVERYONE) has full access
to your database file and folder.<br><br>
Open http://<yourservername>/<forumdirectoryname>/setup.asp in your
browser. Then follow the instructions to setup your database.<br></p></td>
</tr>
<tr bgcolor="#f5f5f5" valign="top">
<td bgcolor="#000066" align="left"><b><font color="#FFFFFF">New Install - MS SQL or MySql</font></b></td>
</tr>
<tr bgcolor="#f5f5f5" valign="top">
<td>
<p><br>Open http://<yourservername>/<forumdirectoryname>/setup.asp in your
browser.<br>
Follow the instructions to create the forum tables in your database.<br><br></p></td>
</tr>
</table>
<br>
</li>
<li><p>After the forum is installed you can log in as the administrator with the username and
password you supplied at setup. Then you will need to click on the "Admin Options"
link at the top right of the page. Then log in again to the Admin Section using the same
admin username and password.<br><br>
You will now be at the Admin Control Panel, where you can configure the forum to match
your site and colors.<br></p></li>
<li><b>Configuring your Email Configuration:</b><br>
<br>
<table border="0" cellpadding="0" cellspacing="0" bordercolor="#111111">
<tr>
<td valign="top">
Configuring the email server is a commonly overlooked part of setting up a forum.
This is very important though because there are several features that will not work without
it. For example: Subscriptions, Email Validation, Forget Password Option, Emailing Members, etc.<br><br>
<center><img border="0" src="readme_admin_email_config.gif" width="456" height="226" alt="Picture of the E-mail Server Configurations"></center><br>
The email component select box will display a list of email components that are installed on your server.
There is no particular 'right choice' as any that are listed will work.<br><br>
<p>NOTE: If the select box says <font COLOR="#800080">"No Compatible
Component Found"</font>, then you will have to either install a component or not use email.<br>
<br>
Email mode should be "on" if you want your forum to send email, or
"off" if you don't want it sending email. This function will be
disabled if no email component is selected.</p>
<p>Email server should point to an outgoing SMTP server that can be
used to send email. If you have POP3 email, then this is the
same as your "outgoing mail server" in your email configuration.</td>
</tr>
</table>
</li>
</ol>
</td>
</tr>
<tr>
<td><a href="#top"><img src="icon_go_up.gif" alt="Go To Top Of Page" align="right" height="15" width="15" border="0"></a></td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td>
<hr size="1"><a name="upgrade"></a>
<h3>Upgrade Instructions</h3>
<p class="note"><b>NOTE:</b> It is recommended that you backup your database before you upgrade.</p>
<ol>
<li><p>To upgrade your forum you will need to modify your connection string to point to your backup
copy of the database you want upgrade.</p></li>
<li><p>Go to the setup.asp file in your forum directory.<br>
Ex.: http://<yourservername>/<forumdirectoryname>/setup.asp<br><br>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -