View source for Easysoft ODBC-ODBC Bridge Installation

== Overview ==


== Requirements ==
This requires that legacy machine has the Easysoft ODBC-ODBC Bridge Server component installed, with the required tables configured in the catalogue. The IP address and port number of the Server will be required, along with logon details, plus the catalogue's database name, user and password.


== Software ==
The Client software required will need to be compatible with the host version of Windows and with the Server Bridge Version. Consult Easysoft support if there are issues (support@easysoft.com).

Previously used version are stored in P:\271321 - Vision\_Development\Development Tools\ and are shown below:
*	odbc-odbc-bridge-2_1_0-windows-x86.msi
*	odbc-odbc-bridge-2_3_0-windows64.exe
*	odbc-odbc-bridge-2_4_2-windows.exe (Recommended version)

{{Note|Client version 2.04.00.02 is confirmed as working with Server version 1.4.37 running on AIX 5.}} 


== Installation ==
{{Note}} This guide is based on version 2.03.00.00 of the Easysoft ODBC-ODBC Bridge installer on Windows 7. This has been confirmed identical to version 2.04.00.02 installation on Windows 7 and Windows Server 2008.


Run the recommended Easysoft installer on the machine

Click '''Next'''.

[[File:VIS_Easysoft_1.png]]
 

Accept the license agreement and click '''Next'''.

[[File:VIS_Easysoft_2.png]]
 

Click '''Custom'''.

[[File:VIS_Easysoft_3.png]]

 
When prompted, deselect Server components and select Documentation components, so as to match the screenshot.
Click '''Next'''.

[[File:VIS_Easysoft_4.png]]


Click '''Install'''.

[[File:VIS_Easysoft_5.png]]

 
Deselect ''Launch Easysoft License Manager'' and click '''Finish'''.

[[File:VIS_Easysoft_6.png]]


== Testing Configurations ==
Testing of the software connections should be performed using ODBC connections on the Vision (Client) host machine.

For 64-bit ODBC connections on 64-bit machines, or 32-bit ODBC connections on 32-bit machines:
*	Click ''Start/Control Panel/Administrative Tools/Data Sources (ODBC)''
For 32-bit ODBC connections on 64-bit machines:
*	Click ''Start/Run''
*	Enter "c:\windows\syswow64\odbcad32.exe" and click '''OK'''.

[[File:VIS_Easysoft_Test_1.png]]
 

When ODBC configuration has started:
*	Click ''System DSN'' tab
*	Click '''Add''' button
*	Click ''Easysoft ODBC-ODBC Bridge''
*	Enter a unique ''Name'' and a ''Description'' in the ''DSN'' tab
*	Enter your database ''Servers'' and port, ''Username'' and ''Password'' in the ''Server'' tab. This will be the machine hosting the CISAM data and Easysoft server.
*	Enter ''Target DSN'', ''Target User'' and ''Target Auth'' in the ''Target DSN'' tab. This is the catalogue name in Easysoft server, with the user and password as configured through the administrator.
*	Click '''Test'''. If there are no issues a screen will be displayed as below.

*	Click '''OK''' to save the ODBC connection if required.


== Configuring the datamine ==
Use the setting for the WMS414 data mine, with a connection string as follows, replacing the square brackets with the correct parameters as used when configuring the ODBC connection:

 SERVERPORT=[x:y];TARGETDSN=[];UID=[];PWD=[];LogonUser=[];LogonAuth=[];


[[Category:Vision Overview]]
[[Category:Vision Coding and Release Doc|021]]
[[Category:Vision Coding and Release]]