Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Contact: Jenn Colt

Date last updated: 12 03/2231/20172020

Date of next review: December 2018 2020

...

Introduction

Connecting to the TS Stats Database

...

  1. Download and install the MySQL ODBC 5.1 driver. The installer is available on the LTS share, in "netadmins\Software\MySQL." Also, either create a desktop shortcut to the database, or map drive to it. The database is found at \\files.cornell.edu\lib\ds-deptshares\LTS\tsstats\1New_culv2-2012-2013.accdb.
  2. Ask Amy Blumenthal or Chris Manly for the database password.
  3. Configure the driver, using the 32-bit ODBC Administrator, here: c:\windows\syswow64\odbcad32.exe. (Note: Do not use the ODBC Administrator in Control Panel/Administrative Tools.)

...

When you have new staff, you must notify the TS Stats Database Admin (currently Nancy SollaJenn Colt) in order to have them added to the database. In order for a staff member (including student workers) to be included in your unit report, their name and net id must be in this database, and they must be assigned the proper unit name.

...