Smart Poll 1.0 - Installation

Smart Poll 1.0 - Installation

Installing Smart Poll for MS SQL Server Database

A. Contents of the zip file

Unzip the zip file to your root folder. You will find the following files under the SmartPollAdmin folder :

1. SQL Scripts file : SmartPollSQLScripts.sql
2. 4 Flash Interfaces : poll.swf, poll2.swf, poll3.swf and poll4.swf
3. Flash files used in the Admin Panel : adminpoll.swf and addquestion.swf
4. conn.asp - contains the connection string to your SQL Server Database
5. Admin Panel Functionality Files : 16 ASP files, 10 GIF images, 1 TXT file and a CSS styles file
6. Single Website EULA (End User License Agreement) - License.html
7. This Installation Guide - ReadMe.html

B. Installation steps

1. Important : a) Place the complete SmartPollAdmin folder under your web site’s root directory only.
   b) Make a new folder under your site root called FlashFiles and copy the 4 Flash interface files: poll.swf, poll2.swf, poll3.swf and poll4.swf to it. Do not delete the original files under your admin panel.


2. Database : To create the required table and stored procedures run the sql scripts file (SmartPollSQLScripts.sql) from your SQL Server Database Query Analyzer. Alternately you can also simply open the file in Notepad, copy the contents of the file, paste it into your SQL Server Query Analyzer, choose the correct database into which you want the Poll data to go and then run the script. It is better if you first create the table and stored procedures in an offline dummy database, check if everything is working and then export the tables and the stored procedures to the remote database through the Microsoft Transaction Server(MTS). Make sure that the table identities, keys and default values are transferred properly.


3. Important : To make your Smart Poll work you need to give the connection string to your SQL Server Database in the conn.asp page. Open the code view of this page and you will immediately find the following lines clearly marked out for your convenience.
   

   '-----------Place your Database connection string here in place of the existing dummy one----------

   strDB="Driver={SQL Server};Server=yourServerIPAddressOrName;UID=yourUserID;PWD=yourPassword; DATABASE=yourDatabaseName"

   '-----------Place your Database connection string here in place of the existing dummy one----------

   Substitute the following with your SQL Server database details, that would have been assigned to you when you bought the database space, as listed below:

   a. yourServerIPAddressOrName - this is your SQL Server database IPAddress or Name.
   b. yourUserID - your SQL Server database's User Name.
   c. yourPassword - your SQL Server database's Password.
   d. yourDatabaseName - your SQL Server database Name.
   
   If your database connection needs to be a DSN type then give your DSN name as an additional clause in the above connection string. Just replace 'yourSystemDSNName' or 'yourFileDSNName' according to your DSN type with your assigned DSN Name like in the example string below and place it in the code.

   For a System DSN the connection string will be:
   strDB="Driver={SQL Server};Server=yourServerIPAddressOrName;UID=yourUserID;PWD=yourPassword; DATABASE=yourDatabaseName;DSN=yourSystemDSNName"

   For a File DSN the connection string will be:
   strDB="Driver={SQL Server};Server=yourServerIPAddressOrName;UID=yourUserID;PWD=yourPassword; DATABASE=yourDatabaseName; FILEDSN=yourFileDSNName"
   

   
   
4. Accessing the Administration Panel : To access your Smart Poll Administration Panel, Please go to http://your_website_url/SmartPollAdmin/default.asp and login with the default UserName: administrator and Password : smartpolladmin. Please make sure that you change the user name & password immediately (using the change login data facility) to prevent unauthorized entry. If you forget your user name & password, you will need to get into your database and view the table tblPollAdmin to view it.
   
   
5. Displaying the Smart Poll : To place your Smart Poll inside one of your site pages, log into the administration panel using the username and password, now click on the Interface Options link in the left menu, choose an appropriate interface and select the corresponding code displayed in a text box. Copy and paste it into your page. Please go to our online page Tips for Using Smart Poll to learn more about using these interfaces.
   

Good Luck and Best Wishes from the Smart Webby Team! If you have any problems or suggestions please contact us at admin@smartwebby.com.