Room Reserve Installation Instructions


Please remember that the Evanced Support Department is always willing to help or even perform the installation for you, so if you have any hesitations about performing the installation yourself please contact us at support@evancedsolutions.com to schedule your installation. If you intend on performing the installation yourself, send us an email requesting the links for the installation programs.

Applies to version 7 and newer of the Room Reserve software

The installation server is the server that the system is being installed on. It must run Windows 2003/2008 Server or newer, and be configured with the "Application Server” role. For Windows 2003 Server or newer, make sure the Internet Information Services (IIS) Manager’s Web Service Extensions are configured to allow Active Server Pages or Classic ASP, as they are prohibited by default.

The installation process includes the following steps:

The following describes how to accomplish the steps required in the installation process. Please read through all of the steps before starting the installation.

Installation of MySQL and ODBC connector on server:

  1. Install MySQL.
  2. Install ODBC Connector.

Installation of the web files and default database:

  1. Locate the default web site location on the server.
  2. Create the Evanced folder.
  3. Install the web pages.
  4. Install the database files.

Configuration of the database connector (ODBC/DSN):

  1. Open the ODBC connection manager on the server. Typically this can be found under 'Start-->Administrative Programs-->Data Sources (ODBC)'.
  2. Select the System DSN tab and click add.
  3. Click on the 'MySQL ODBC 3.51 Driver' and click finish.
  4. Click on the Advanced tab and check the box next to 'Change BIGINT Columns to Int'.
  5. Click on the Connect Options tab and enter the port number used during the installation for the port value.
  6. Click on the Login tab and enter the following values:
    DSN Name --> autoemail
    Username --> root
    Password --> evanced
  7. Click on the Test button. You should receive a "Connection was made" message. If not, review the previous steps and ensure that all settings are correct.
  8. Select the autoemail database from the database droplist.
NOTE: You will not be able to select the database until all other options are defined and are correct, so select it last.

Verify the installation:

  1. Open Internet Explorer/Firefox/Google Chrome and enter "localhost/evanced/lib/about.asp" in the address bar. If the About window does not appear then there are problems with the webfile installation or IIS configuration. Please review the previous steps and/or contact support@evancedsolutions.com.
  2. If the previous test passed then enter "localhost/evanced/lib/roommaintenance.asp" in the address bar. If login screen does not appear then there are problems with the database installation or ODBC configuration. Please review the previous steps and/or contact support@evancedsolutions.com.

Update to the newest minor revision:

  1. Use the links sent from Evanced and save the "Upgrade vXX.zip" file (where XX is the product version) to the evanced folder created above.
  2. Unzip the "Upgrade vXX.zip" file to the evanced\lib folder. Be sure to check the box for "Use folder names and select Yes for "Overwrite all files."
  3. Open Internet Explorer/Firefox/Google Chrome and enter "localhost/evanced/lib/ervXupgrade.asp" in the address bar (X is the product version) and click on Yes to run the upgrade script. When complete click OK.
  4. Test the site by entering "localhost/evanced/lib/roommaintenance.asp" in the address bar. If login screen does not appear then there were problems with the update. Please review the previous steps and/or contact support@evancedsolutions.com.

Now you can test your system. Again please contact support@evancedsolutions.com if you have any questions, problems or just would like us to perform the installation for you.


Custom Fields

Article ID: 12
Created On: Tue, Sep 6, 2011 at 9:30 AM
Last Updated On: Tue, Jan 26, 2016 at 4:57 PM

Online URL: https://kb.demcosoftware.com/article.php?id=12