<%@ LANGUAGE="VBSCRIPT" %>
<%
Application("Banner_Config_Updated") = "False"
FileUploadURL = "http://" & Request.ServerVariables("HTTP_HOST") & Replace(Request.ServerVariables("URL"),"show_path_info.asp","/banimages")
%>
<HTML>
<HEAD>
<TITLE>Show Path Info</TITLE>
</HEAD>
<BODY bgcolor="#FFFFFF">
<font face="Arial" color="#000000" size ="2">
If Parent Paths are disabled on your web server the section of code below needs<br>
to be put in the "aspbanner/config_inc.asp" file. There is already a section there<br>
like this. You just paste this code over the code that is there.<br>
The paths generated below should be valid if the folder structure of the app has not changed.
<br>
<textarea rows="26" cols="150" STYLE="font-family: Arial; font-size: 12px; background-color: #E8E8E8; word-wrap: normal; overflow: auto;">
<%
'**********************************************
'Beginning of Advanced settings
'Intended for complicated installations where you cant get permissions set
'on the "data" folder and/or Parent Paths are not enabled on the server.
'All paths must be full paths like in the examples and can not end with any slashes
'**********************************************
'Lets you manually set the config file location if parent paths are disabled on the web server
'or if you just want to keep it somewhere that has permissions already
ConfigFileLocation = "<% =Server.MapPath("config")%>\aspbanner_unlimited_config.asp"
'**********************************************
'Lets you manually set the file upload location and url if parent paths are disabled on the web server
'or if you just want to have the file upload location and url somewhere that has permissions already
FileUploadLocation = "<% =Server.MapPath("banimages")%>"
FileUploadURL = "<% =FileUploadURL %>"
'**********************************************
'Lets you manually set the Temp Stats folder location if parent paths are disabled on the web server
'or if you just want to have Temp Stats folder location somewhere that has permissions already
TempStatsLocation = "<% =Server.MapPath("tempstats")%>"
'End of Advanced Settings
'**********************************************
%></textarea>
<hr>
<br><br>
You will also need to manually edit the "data/config/aspbanner_unlimited_config.asp" file<br>
You need to edit two settings in it. The "BannerConnectionString" and the "BannerDatabaseType"<br>
Possible "BannerConnectionString" values are generated below on this page.<br>
The "BannerDatabaseType" value will be "MSACCESS", "MSSQL", or "MYSQL"<br>
When you save these values to the "data/config/aspbanner_unlimited_config.asp" file DO NOT<br>
surround the values with quotes. Put the values directly after the equals sign for each line.<br>
<br>
Here is an example of correct BannerDatabaseType setting:<br><br>
BannerDatabaseType=MSACCESS<br><br>
Also, be sure not to add any line breaks or spaces after the values or you will mess that file up.<br><br>
Here is a screenshot of a correctly edited file.
<a href="../aspbanner2/images/config_example.gif" Target="_Blank">Example Config</a><br>
The parts you need to edit are highlighted.
<br>
<br>
<hr>
<br>
This is a dsn-less connection to an access 2002 database.<br><br>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" bgcolor="#FFFFFF">
<tr>
<td><font size="1" color = "#000000">
<textarea rows="1" cols="160" STYLE="font-family: Arial; font-size: 12px; background-color: #E8E8E8; word-wrap: normal; overflow: auto;">DBQ=<% =Server.MapPath("database/aspbanner_access2002.mdb")%>;Driver={Microsoft Access Driver (*.mdb)}</textarea>
</font></td>
</tr>
</table>
<br><hr>
This is a dsn-less connection to an access 2000 database.<br><br>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" bgcolor="#FFFFFF">
<tr>
<td><font size="1" color = "#000000">
<textarea rows="1" cols="160" STYLE="font-family: Arial; font-size: 12px; background-color: #E8E8E8; word-wrap: normal; overflow: auto;">DBQ=<% =Server.MapPath("database/aspbanner_access2000.mdb")%>;Driver={Microsoft Access Driver (*.mdb)}</textarea>
</font></td>
</tr>
</table>
<br><hr>
This is a dsn-less connection to an access 97 database.<br><br>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" bgcolor="#FFFFFF">
<tr>
<td><font size="1" color = "#000000">
<textarea rows="1" cols="160" STYLE="font-family: Arial; font-size: 12px; background-color: #E8E8E8; word-wrap: normal; overflow: auto;">DBQ=<% =Server.MapPath("database/aspbanner_access97.mdb")%>;Driver={Microsoft Access Driver (*.mdb)}</textarea>
</font></td>
</tr>
</table>
<br><hr>
This is a system dsn connection to any version of access or a sql database.<br>
This requires that a system dsn be set up on the web server.<br><br>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" bgcolor="#FFFFFF">
<tr>
<td><font size="1" color = "#000000">
<textarea rows="1" cols="160" STYLE="font-family: Arial; font-size: 12px; background-color: #E8E8E8; word-wrap: normal; overflow: auto;">DSN=aspbanner</textarea>
</font></td>
</tr>
</table>
<br><hr>
This is a dsn-less connection to a Microsoft SQL database.<br><br>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" bgcolor="#FFFFFF">
<tr>
<td><font size="1" color = "#000000">
<textarea rows="1" cols="160" STYLE="font-family: Arial; font-size: 12px; background-color: #E8E8E8; word-wrap: normal; overflow: auto;">Provider=sqloledb;Data Source=127.0.0.1;Initial Catalog=aspbanner;User Id=aspbanneruser;Password=temp;</textarea>
</font></td>
</tr>
</table>
<br><hr>
This is another dsn-less connection to a Microsoft SQL database.<br><br>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" bgcolor="#FFFFFF">
<tr>
<td><font size="1" color = "#000000">
<textarea rows="1" cols="160" STYLE="font-family: Arial; font-size: 12px; background-color: #E8E8E8; word-wrap: normal; overflow: auto;">Driver={SQL Server};UID=aspbanneruser;password=temp;DATABASE=aspbanner;SERVER=127.0.0.1</textarea>
</font></td>
</tr>
</table>
<br><hr>
This is a MYODBC connection to a MySQL database.<br><br>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" bgcolor="#FFFFFF">
<tr>
<td><font size="1" color = "#000000">
<textarea rows="1" cols="160" STYLE="font-family: Arial; font-size: 12px; background-color: #E8E8E8; word-wrap: normal; overflow: auto;">driver={MySQL ODBC 3.51 Driver};server=127.0.0.1;port=3306;uid=root;pwd=;database=aspbanner;option=16386</textarea>
</font></td>
</tr>
</table>
<br>
<hr>
After you do all of this try to run the application<br>
<a href="../aspbanner2/default.asp" Target="_Blank">aspbanner/default.asp</a> run through the web server is the page you want to start on.<br><br>
One other thing.. anytime you edit the "data/config/aspbanner_unlimited_config.asp" manually<br>
You will need to run this page "show_path_info.asp" through the web browser once.<br>
It has special code in it that will tell the application to reload the edited config file.<br><br>
And like we said if ya get stuck contact us or check out the support forums.<br>
Were here to help.
</font>
</BODY>
</HTML>