SQL Installation Instructions

Install Database

1. The ROI Wiz™ database is emailed as script file.   Follow these directions to create the database.
2. Now add a user for this new database. 

Install Program

1. Create a Sub Directory off of your main web site.  This directory will house the ROI Wiz™ software so give it a familiar name such as "ROIWiz".  For example, if your domain name is http://www.yourdomain.com, you might create a directory called http://www.yourdomain.com/ROIWiz
   Note: Use a short folder name so that your links remain as short as possible to ensure compatibility with all search engines.
2. Extract ROI Wiz™ into this directory including the images subdirectory. DO NOT PLACE A COPY OF OUR ZIP FILE ANYWHERE ON YOUR WEB SITE.
3. Set the permissions for the newly created ROIWiz directory to allow files to be browsed and allow scripts to be run.  
4. Update the db.asp script to reflect your database connection.   We recommend connecting to the database using OLE DB and avoiding a DSN connection.  OLEDB provides better performance.
5. Run the application in your browser by accessing http://www.yourdomain.com/ROIWiz/, set the preferences and change the administrative name and password.   The username and password are currently set to Admin1/Admin1 and is case sensitive. 

1. To ensure full support with P3P compliant browser, such as IE6, you should implement a P3P privacy policy on your web site.  Click here for instructions on creating a P3P privacy policy.