Helpline wrote me:
Judith called back regarding this. Can someone please give her a hand?
Entered on 01/30/2006 at 11:36:00 by Zak Brown:
Client needs to update the Social Work training signup page/database.
http://www.uvm.edu/~socwork/projects/register/login.php
She was told that she needed to download and install MySQL Connector to be able to
accomplish this. That piece of software doesn’t appear to be available from the
University, and is not supported. Not sure where the recommendation for this came
from, or if there is now another program to be used. Laurie, could you look into
I called Judith C. Ingalls-O’Keeffe
The "MySQL Connector " she describes is the mySQL ODBC connector described here:
https://www.uvm.edu/cit/mysql/?Page=mySQLODBC.html
She downloaded and installed that, and was then trying to access her data using MS-Access. Several problems from here:
- She is located in F&A Partnrshp 7 Kilburn St 3 F — that is, off campus. The UVM mySQL database server does not allow connection from off-campus computers. I walked her through downloading and installing the Cisco VPN client, which allows her off campus computer to behave like an on-campus computer
- She was launching MS Access, choose "File==>New==>Blank Data Access Page" . Near as I can tell, the Blank Data Access Page only allows connections to Microsoft SQL servers — not mySQL servers.
So I walked her through the "File==>New==>Blank Database" instructions, again as detailed here
https://www.uvm.edu/cit/mysql/?Page=mySQLODBC.html
This got her to the tables; However, this does not necessarily match the instruction provided by Sarah Gallagher, IV-E Program Coordinator, or Ilan Agwin, who I believe developed the database and wrote the associated php code (http://www.uvm.edu/~socwork/projects/register/login.php )
So, immediate problems perhaps solved, but may require followup with Sarah or Ilan
