...
- 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.
- Ask Amy Blumenthal or Chris Manly for the database password.
- 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.)
...
NOTE: Please note that staff members have been entered into this database under the unit of their administrative supervisor. For example, while Betty Spreadsheet Datacruncher does some copy cataloging, she is a direct report of the Batch Processing Unit Supervisor and is therefore entered under Batch Processing. If you have a staff member who does some work for you but who reports to another manager, you can run your unit report and then run the “Individual Report” for any such staff member(s).
When you have new staff, you must notify the TS Stats admin Database Admin (currently Nancy Solla) 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.
...