Web Applications

Smart Survey 1.0 - Installation

Installing Smart Survey for MS SQL Server Database

Smart Survey 1.0 - Installation

Installing Smart Survey 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 SmartSurveyAdmin folder :

  1. SQL Scripts file : SmartSurveySQLScripts.sql
  2. 2 Flash Interfaces : survey.swf and survey2.swf
  3. Flash files used in the Admin Panel : admin.swf and addquestion.swf
  4. conn.asp - contains the connection string to your SQL Server Database
  5. Admin Panel Functionality Files : 19 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 : Place the complete SmartSurveyAdmin folder under your web site’s root directory only.
  2. Database : To create the required table and stored procedures run the sql scripts file (SmartSurveySQLScripts.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 Survey 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).
  3. Important : To make your Smart Survey 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 Survey Administration Panel, Please go to http://your_website_url/SmartSurveyAdmin/default.asp and login with the default UserName: administrator and Password : smartsurveyadmin. 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 tblSurveyAdmin to view it.
  5. Displaying the Smart Survey : To place your Smart Survey 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 survey by its name from the list, now click update to see the survey 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 Survey 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.