AdComplete.com, LLC
Celebration, Florida 34747
407-551-0777 Phone
 
 
 
 

>> Ban Man Pro 12 Upgrade from 7.0 for ASP.NET 4/SQL Server

 
 
Please follow directions precisely to ensure un-interrupted ad serving.

Pre-Installation Notes

  • Verify that you are currently using Version 7. 
  • Make a backup copy of the entire /banmanpro/ folder on your web server as well as the SQL database.  This upgrade will alter the database and a backup is required in the event of an error in the upgrade script.
  • This upgrade alters a number of database indices.  If you have a large database this script may take a long time to run, in some cases minutes to an hour.  You may wish to disable ad serving under the Ban Man Pro tools option until the upgrade is completed.
  • This upgrade require .net 4.0 be installed on the server.  Please verify .net 4 has been installed.  If it is not installed it should be installed through the Windows Update utility.

Pre-Installation Instructions

  1. Modify your existing Ban Man Pro IIS Application Folder to use .net 4.0 instead of .net 2.0.  Click here for instructions on doing so.

Installation Instructions

  1. Extract the upgrade files contained in banmanproSQL12upgradeFrom7.zip  to a temporary location on your local computer.  You will now see several folders including RootDirectory, Admin, Images, Advertiser, Bin, and Language.
     
  2. Version 12 includes changes to the Root web.config file for .net 4.0 and the new charting control.  Because this file also holds your custom database connection string, you must first enter your database connection into the web.config file before copying the updated files.  If you don't your database connection will break after the upgrade.  Also, if you added any custom tags to the web.config they should also be transferred. To do so...

    Open the web.config for your EXISTING installation of BanManPro.  Find and copy this line:

    <add key="DBConnectionString" value="server=(LOCAL);UID=youruserid;PWD=yourpass;DATABASE=BanManPro" />

    Now, open the web.config found in the "banmanproSQL12upgradeFrom7\RootDirectory" folder of the upgrade files.  Replace the sample connection string with your full connection string.

    Save the file.

     
  3. From within SQL Query Analyzer, execute the script called banmanproSQL12upgradeFrom7.sql on your existing Ban Man Pro database.  The database is now converted to the new format.  If you are unsure how to do this, please review Steps 5-7 of the original database instructions found at: support/SQLnewdbExpress.asp and noting that in step 5 the SQL script is named banmanproSQL12upgradeFrom7.sql.

    Note
    : If you receive the error below it is not fatal and can be ignored...BMP_proc_ObtainBannerForKeywordCampaignAdvanced4, Line 27
    Cannot use a CONTAINS or FREETEXT predicate on table 'Campaigns' because it is not full-text indexed.

     
  4. Copy the files from the directory called "Root Directory" to the web server directory where Ban Man Pro is installed.  If you installed the software at http://www.yourdomain.com/banmanpro then that is where these files are to be copied.  You will be overwriting the existing files.  
     
  5. Copy the files in the Images directory to the images directory.  This will most likely be... http://www.yourdomain.com/banmanpro/images.  
     
  6. Copy the entire Admin, Advertiser, ChartImages and Language folders into the folder where Ban Man Pro is installed. Be sure to include all subdirectories.
     
  7. Copy the contents of the /bin/ folder to your Ban Man Pro /bin/ folder.  This will most likely be... http://www.yourdomain.com/banmanpro/bin/. 
     
  8. Load the Upgrade.aspx file in your browser. It is located in the root folder and has open access.

    For example: http://www.yourdomain.com/banmanpro/upgrade.aspx

    Click the button to upgrade your existing database.
     
  9. Now delete upgrade.aspx so it cannot be executed a second time. 
     
  10. In order to use the charting tool, you must give the Users account WRITE permissions on the ChartImages folder.  Click here for directions on setting write permissions.
     
  11. Log into the Ban Man Pro admin console and verify everything is working properly.
     
  12. Click Setup and make sure the field called "Physical server path of BanManPro application" is set correctly.  This must be the physical file path to the location where BanManPro is installed.  This is used to find the Language Files.  If not set correctly the web interface will load more slowly.  Once set correctly, click Update Setup.

 

 
 
 
 
 
Copyright 1999-2014 AdComplete.com, LLC All Rights Reserved