CyDAS Installation Guide

Get the CyDAS application

Then, open that directory in the Windows Explorer and double-click the file "Register.bat". This will register all CyDAS dll and put all CyDAS executables into the Global Assemby Cache.

There is no need to register the dlls, if you do not plan to use CyDAS libraries in your own programs (e.g. VBA scripts in MS Access).

In any case, make sure that all CyDAS users have sufficient access rights to the files in the CyDAS directory and localizer subdirectory. Strange error messages when starting the application may occur if the user cannot read the localizer files. If a windows standard icon is displayed for the CyDAS.exe file or a link to it, this is an indication of insufficient rights.

Get a Database Engine

• Microsoft Access
• Microsoft SQL Server
• MySQL

If you do not need to store data in CyDAS, e.g. if you want to analyse single ISCN formulae or draw ideograms of derivative chromosomes only, you do not need to set up a database.

The CyDAS.ini file (located in the installation directory) by default is set to the use of CyDAS without a database:.

In the section "[Database]", the following lines are uncommented by default:
"Engine=NONE", and the line immediately beneath it
"ConnectString=NONE"
The can be commented out by adding a semicolon (";") at the beginning of each line.

Nonetheless, the Microsoft ODBC .Net Data Provider (see below) must be installed on your computer.

Microsoft Access

CyDAS was tested with Microsoft Office 2000 Premium version 9.00.2816; later or earlier versions were not tested.

To make this Access DB your database, edit the CyDAS.ini file (located in the installation directory) with a common text editor.

In the section "[Database]" uncomment the lines
"Engine=Access" and the line immediately beneath it
by removing the starting semicolon (";").

In the line starting with "ConnectString", edit the following parameters:

• "Password=Password1;": replace Password1 with your password (in case of an empty password, use quotes ("Password="";").
• "User ID=User1;": replace User1 with your user name; if you do not use a user name, leave the parameter empty ("User ID=;").
• "Data Source=C:\CyDAS\CyDAS.mdb;": if you did not install into C:\CyDAS or renamed the db file, adjust this item.
• "Jet OLEDB:System database=C:\Program Files\Microsoft Office\Office\system.mdw;": if your system.mdw file is located at a different place, adjust this item accordingly.

On a German system, the location is typically C:\Programme\Microsoft Office\Office\system.mdw.
If there is no system.mdw, remove that parameter.

Make sure that the user named in the ini file has full access rights to the database, including: INSERT, UPDATE, DELETE, CREATETABLE, and DROPTABLE. Of course, the user must have write privileges on the CyDAS.mdb file.

Microsoft SQL Server

In the section "[Database]" uncomment the lines
"Engine=MSSQL" and the line immediately beneath it
by removing the starting semicolon (";").

Setup the database contents similar to the procedure described in the MySQL section (specific description will be added later)

MySQL

You may add further utilities for maintenance and use of the MySQL database, but they are not needed for its integration into CyDAS.

CyDAS was developed with version 4.018 of the database engine and version 3.51.07 of the ODBC connector; later versions of the database engine require later versions of the ODBC connector, but else they are expected to work equally well.

The script file for the creation of the database and its primary contents is "MySQL_CyDAS.sql". You can execute it as follows:

• open a DOS box (Start – Execute – cmd)
• change directory to C:\CyDAS
• start a MySQL console application ("mysql –u root –p"; you are prompted for the root password)
• execute the script file ("source MySQL_CyDAS.sql"); you may ignore warnings
• leave the MySQL console application and the DOS box ("quit" and "exit")

To make this MySQL DB your database, edit the CyDAS.ini file (located in the installation directory) with a common text editor.

In the section "[Database]" uncomment the lines
"Engine=MySQL" and the line immediately beneath it
by removing the starting semicolon (";").

In the line starting with "ConnectString", edit the following parameters:

• "PASSWORD=Password1": replace Password1 with your password (in case of an empty password, use quotes ("PASSWORD=""").
• "UID=User1": replace User1 with your user name

You may install the database engine on a different computer, this will enhance performance for all tasks requiring database queries. Still, the MySQL Connector / ODBC must be installed on the computer on which you are running CyDAS.

In the CyDAS.ini file (see above), the server name (or its IP address) must be given in the "ConnectString" line, i.e. you must replace "localhost" with the name of the computer (or its IP address) on which the MySQL database server was installed.

Getting System Files

• The DotNet Framework is required in version 1.0.3705 or later
• Microsoft Data Access Components (MDAC) in version 2.7 or later.
• Microsoft ODBC .Net Data Provider in version 1.0.0.3328 or later.

Integrating CyDAS into your Computer

Icon on the desk top

• open a Microsoft Windows Explorer Window, and therein the directory C:\CyDAS (or your installation directory)
• open another Microsoft Windows Explorer Window, and therein the directory "C:\Documents and Settings\All Users\Desktop"
• in the first window, right click on "CyDAS.exe" and drag the symbol into the second window.
• select "create link" from the menu
• rename the link (in the second window) to "CyDAS"

Start menu

• open a Microsoft Windows Explorer Window, and therein the directory C:\CyDAS (or your installation directory)
• open another Microsoft Windows Explorer Window, and therein the directory "C:\Documents and Settings\All Users\Start Menu\Programs"
• in the first window, right click on "CyDAS.exe" and draw the symbol into the second window.
• select "create link" from the menu
• rename the link (in the second window) to "CyDAS"