Difference between revisions of "ITrack/ODBC"

From ISoft Wiki
Jump to navigationJump to search
(New page: ==Overview== The MySQL ODBC Driver is required to print from ITrack. ==Installation== ===32 bit Windows=== To install: # Download MySQL ODBC Driver 3.51 from [http://dev.mysql.com/downloa...)
 
Line 25: Line 25:
To Install:
To Install:
# Navigate to '''%systemdrive%\Windows\SysWoW64''' and look for '''Odbcad32.exe'''
# Navigate to '''%systemdrive%\Windows\SysWoW64''' and look for '''Odbcad32.exe'''
# [#32 bit Windows See the previous section above] to complete the ODBC setup
# [[http://wiki.isoftdata.com/index.php/ODBC_(ITrack)#32_bit_Windows See the previous section above]] to complete the ODBC setup
# It is recommenced that a shortcut be placed in Administrative Tools and name "Data Sources (ODBC) 32" and the existing one be renamed "Data Sources (ODBC) 64" for future ease.
# It is recommenced that a shortcut be placed in Administrative Tools and name "Data Sources (ODBC) 32" and the existing one be renamed "Data Sources (ODBC) 64" for future ease.

Revision as of 18:43, 13 January 2009

Overview

The MySQL ODBC Driver is required to print from ITrack.

Installation

32 bit Windows

To install:

  1. Download MySQL ODBC Driver 3.51 from here
  2. Run the installer (leave defaults)
  3. After the install is finished, go to Start > Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN (tab)
MySQL ODBC Connection Dialog
  1. Click Add...
  2. Scroll to the bottom of the list, select MySQL ODBC 3.51 Driver, select Finish
  3. Enter in the following Information in the box that appears:
    1. Data Source Name: ITrack Pro or ITrack Enterprise (depending on which version of ITrack is being used)
    2. Description: ITrack
    3. Server: Enter the same server as ITrack uses (Open ITrack > Edit menu > Options > General (tab) > Server IP Address)
    4. Fill in the User and Password fields, then click Test. "Success; connection was made!" will display if the connection is working properly.
  4. Go to the Advanced tab
    1. Make sure the Don't Optimize Column Width and Return Matching Rows boxes are checked, but no others.
  5. Click Ok and OK again to save your changes.

64 bit Windows

Because the version of ODBC that is needed for ITrack to work is an older version of the ODBC driver (still 3.51), using the 32 bit version of the data sources program in Windows is required. The default that windows puts in Administrative Tools is the 64 bit version, and it won't work. For more information, check this Microsoft KB article.

To Install:

  1. Navigate to %systemdrive%\Windows\SysWoW64 and look for Odbcad32.exe
  2. [See the previous section above] to complete the ODBC setup
  3. It is recommenced that a shortcut be placed in Administrative Tools and name "Data Sources (ODBC) 32" and the existing one be renamed "Data Sources (ODBC) 64" for future ease.