Smart Multi Poll 1.0 - Installation
Installing Smart Multi 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 SmartMultiPollAdmin folder :
- SQL Scripts file : SmartMultiPollSQLScripts.sql
- 4 Flash Interfaces : poll.swf, poll2.swf, poll3.swf and poll4.swf
- Flash files used in the Admin Panel : adminpoll.swf and addquestion.swf
- conn.asp - contains the connection string to your SQL Server Database
- Admin Panel Functionality Files : 16 ASP files, 10 GIF images, 1 TXT file and a CSS styles file
- Single Website EULA (End User License Agreement) - License.html
- This Installation Guide - ReadMe.html
B. Installation steps
- Important : a) Place the complete SmartMultiPollAdmin
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.
- Database : To create the required table and stored
procedures run the sql scripts file (SmartMultiPollSQLScripts.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 (After checking
offline, it is recommended to run the script for the online
database, through the query analyzer, to skip this step).
- Important : To make your Smart Multi 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"
- Accessing the Administration Panel : To access
your Smart Multi Poll Administration Panel, Please go
to http://your_website_url/SmartMultiPollAdmin/default.asp
and login with the default UserName: administrator
and Password : smartmultipoll.
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.
- Displaying the Smart Multi Poll : To place your Smart Multi 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, select the desired poll by its name from the list, now click update to see the poll appear in all the interfaces. Now 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 Multi 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.