The Chintaro Installation Guide is designed to provide step by step instructions for installation of the Chintaro application (SQL Server database) at your Organisation. The document contains the following: 


1.Requirements for Chintaro

2.Installation Instructions, including how to download Chintaro, installing the database on the Shared Drive, installing the Chintaro Client on a PC and Microsoft Access Trust Center and Trusted Location settings

3.Getting started with Chintaro, including updating System Preferences


Requirements for Chintaro


Microsoft Access

Even though the Chintaro database will be on SQL Server, the Chintaro code (client) requires Microsoft Access 2007 or greater to be installed on each Client PC. If Access is not installed on your Client PC’s, you can use the Microsoft Access Runtime Version’ which is provided free of charge from Microsoft. Using Chintaro with the runtime version of Access limits the functionality of the search screens, and so the full version is recommended.

Click here to download the Microsoft Access Runtime Version.


SQL Server 2012 or greater

You will need to install SQL Server 2012 or greater. We do support SQL Express. 


Installation Instructions

Downloading Chintaro

You can download the ChintaroSQL.mdb client file database from here. Be sure to choose the SQL Server version of ChintaroSQL.mdb.  The file you download will be a zip containing the ChintaroSQL.mdb and some script files.

 

Installing the SQL Server database

1. Using SQL Server Management Studio, create a database called CHINTARO (the default name - you can use another if you wish to have multiple Chintaro environments).

2. Restore the backup provided into the database you just created.  This solution assumes that you know how to do this using SQL Server Management Studio.  Contact support if you need help.  


Installing the shared Chintaro data files

As well as your SQL Server database, Chintaro needs a shared network location to store some files.  These files include all of the templates, inspection files, and mdw files used by Chintaro.


1.Create a shared folder on your Server with a name, such as \\Servername\CHINTARO or z:\CHINTARO.

NOTE: The mapped drive can be any letter.

2.In the zip file you have downloaded, there is a folder named ‘Data’. Copy this folder to your Shared Drive to create \\Servername\CHINTARO\Data.

NOTE: Ensure that all users have FULL permissions to this folder.

3.The contents of the data folder will appear as below:



4. You now need to enter the connection string into the rhp.mdw file.  Double Click on it to open it (with Access) and look for the table UsysConnection.


If you cant see that table, it may be hidden. You can unhide all tables right-clicking the arrow next to "All Access Objects" and selecting Navigation Options

Then tick the Show Hidden Objects and Show System Objects check boxes.


If you still can't see it, don't panic! It may not be in your rhp.mdw. Take a copy of your rhp.mdw and raise a support ticket to Chintaro support who will insert a table for you, and return your file.


If you can see UsysConnection, double-click the table to open it.


Edit the SERVER= parameter to your Server and change the DATABASE= parameter if you need to.  Ensure that the line you edit has "Yes" in the Active column. Then close the rhp.mdw database.

Note the location of the rhp.mdw file - you will need this when creating the shortcut to launch Chintaro (see below).


5.The Chintaro shared files are now installed on the Shared Drive.



Installing the Chintaro Client on a PC

The Chintaro Client (ChintaroSQL.mdb) needs to be installed on the Local Drive (usually C:\) of each PC that will be used to run Chintaro. If you are using a remote desktop environment (E.G Citrix or Terminal Server) please see Appendix A – Setting Up Chintaro for a Remote Desktop.


1.Create a folder named Chintaro on your C:\ Drive (C:\CHINTARO).


2.Copy the following files into the C:\CHINTARO folder:


These are the Icon file, Shortcut File, and the Chintaro SQL code


3.Right click the Shortcut File and choose Properties. You will see the following pop up:


 

4.Ensure that the Target field says “C:\CHINTARO\chintaroSQL.mdb /wrkgrp "Z:\chintaro\data\rhp.mdw", where Z: is the designated letter of your shared drive (where you installed the shared database files earlier).

5.Confirm the shortcut is using the Chintaro icon here, by choosing the Change Icon button and navigating to the C:\CHINTARO\CHINTARO.ico file.

6.You can now copy the Shortcut File to your desktop (by right-clicking on the Shortcut File, selecting ‘Copy’, then going to your desktop, right-clicking and selecting ‘Paste’).


Installing the SQL Server Native Client 11.0  ODBC Drivers on a PC


If you do not have the SQL Server Native Client 11.0 ODBC Drivers installed, you will need to install them on each client PC that is going to run Chintaro SQL.


1. Go to this link at Microsoft

2. Do NOT hit the Download button
3. Expand the "Install Instructions" section
4. Scroll down to the "MICROSOFT SQL SERVER CONNECTIVITY FEATURE PACK COMPONENTS" section (it's far down)

5. Pick which version you prefer

6. Install and follow the Microsoft directions


Trust Center Settings

Before running Chintaro, the Microsoft Access Trust Center Settings on each PC have to be adjusted in order to allow Chintaro to run properly.

NOTE: If you are using Access Runtime, you do not need to change the Trust Center Settings.

1.Open Microsoft Access

2.Select ‘Open Other Files’


3.Select ‘Options’ from the menu on the left hand side:


4.Select ‘Trust Center’ at the bottom of the left-hand menu on the ‘Options’ page. Then select ’Trust Center Settings’ on the right hand side of the pop up.

 

 

5.Select ‘Macro Settings” from the left hand menu on the ‘Trust Center’ page.

 


6.Select ‘Enable all macros (not recommended; potentially dangerous code can run)’. Click OK.

Trusted Locations

After you have adjusted the Trust Center Settings in Microsoft Access, you will also need to turn on Trusted Locations and set the Chintaro Data folder and the local Chintaro folder as Trusted Locations.


1.From the Microsoft Access Options page, select ‘Trust Center’ at the bottom of the left-hand menu on the ‘Options’ page. Then select ’Trust Center Settings’ on the right hand side of the pop up.


2.Select Trusted Locations from the menu on the left, and then tick the ‘Allow Trusted Locations on my network’ box.


3.Then, click the Add New Location button, and add the Chintaro Data folder and the local Chintaro folder.

4.Once the folders have been added, click OK and close Microsoft Access.



Getting Started with Chintaro
To start Chintaro, simply double click on the house shortcut on your desktop.


If you have set up the system correctly, you will see the following log on prompt:


If you are the first person to use Chintaro, you can use the username of sa with a password of sa (without the italics, of course!).


Note! If you get any form of ODBC Error after about one minute of waiting, Chintaro has failed to make contact with the database.

Click OK and the following will pop up....

Click Cancel and Access will close.


Check the following:

1. Do you have the Native Client 11.0 Drivers installed?

2. Is the connection string correct in the rhp.mdw?

3. Does this Windows user have appropriate rights in the SQL Server? (they must be set to dbOwner)


If you find the issue and want to try again, just log back in to Chintaro.


You have now logged in as the System Administrator, which means that you will be required to set up each user with a unique login name, and change the System Administrator password.


NOTE: All usernames and passwords are case sensitive so be sure that you don’t have ‘Caps Lock’ on or you may receive an error.


You will now see the Chintaro Home Screen:




Updating System Preferences

This section will guide you through the process of updating the system preferences associated with changing your Organisation’s details, but the same instructions can be used to update other system preferences as well.


1.From the Chintaro Home Screen, single click on System Maintenance

2.From the System Maintenance Menu, single click on Preferences, and the following screen will appear:



NOTE: As you click your cursor in any field, you will get a clue as to what effect this has on the behaviour of the system. EG:



3.Enter the following information in the appropriate field:



NOTE: The State/Country field is very important – this field will determine how some screens look and which screens you have available

 

4.Press the Home button to go back to the Home Screen.



Appendix A: Installation Instructions for a Citrix (or Virtual Desktop Environment)

A Chintaro installation will consist of a database on a shared drive, with multiple virtual desktop Client versions connecting to it. Chintaro requires Microsoft Access 2007 or greater to be installed on each virtual session.

If these versions of Access are not installed on your virtual sessions, you can use the Access 2013 ‘runtime version’ which is provided free of charge from Microsoft. Click here to download the Microsoft Access Runtime Version.


There are 4 things to do to install Chintaro in a virtual desktop environment:

1.Install the database

2.Install the Client in the ‘users’ folder structure

3.Configure the shortcut on the Client’s desktop

4.Enable macro settings in Microsoft Access



Installing the Database on the Shared Drive

MDB Consulting will have provided you with data files loaded with legacy data. Those files should be copied to a folder called ‘CHINTARO’ to create z:\CHINTARO. (where z: is the mapped drive letter – UNCs like \\server\chintaro will also work).


The contents of the new Z:\CHINTARO folder will contain another folder called ‘Data’. The Data folder contains all the data that Chintaro uses. The other three files will be used later to set up the Client machines. The contents of the Data folder will look like this:


The Chintaro database is now installed on the Shared Drive.



Installing the Client on the Virtual PC

You will be given a download link by MDB Consulting to the latest version of the Chintaro Client.

It is important that each instance of your virtual desktops run their own copy of the Chintaro Client. It is recommended that you install the client in the \Users\%username% structure. Create a folder called CHINTARO beneath the %username%\documents folder (\users\%username%\documents\CHINTARO).

This folder you download will have 3 files in it:



Configuring the Chintaro Shortcut

You will need to configure the shortcut to reflect your setup.


1.Right-click on the Shortcut File and choose Properties. You will see the following pop up:


2.Ensure that the “Target: field” references “\users\%username%\CHINTARO\chintaro.mdb /wrkgrp "Z:\chintaro\data\rhp.mdw", where the users structure matches yours, and Z: is the designated letter of your shared drive (where you installed the Database files earlier).

3.You can also make sure the shortcut is using the Chintaro icon here, by selecting the Change Icon button and navigating to the C:\CHINTARO\CHINTARO.ico file.

4.You can now copy the Shortcut File to the desktop folder so that the Chintaro shortcut is visible to the user on their desktop.


Trust Center Settings

Before running Chintaro, the Microsoft Access Trust Center Settings on each PC have to be adjusted in order to allow Chintaro to run properly.

NOTE: If you are using Access Runtime, you do not need to change the Trust Center Settings.


1.Open Microsoft Access

2.Select ‘Open Other Files’


3.Select ‘Options’ from the menu on the left hand side:


4.Select ‘Trust Center’ at the bottom of the left-hand menu on the ‘Options’ page. Then select ’Trust Center Settings’ on the right hand side of the pop up.


5.Select ‘Macro Settings” from the left hand menu on the ‘Trust Center’ page.

6.Select ‘Enable all macros (not recommended; potentially dangerous code can run)’. Click OK.