Search Google Appliance

Home >> Web >> Comprehensive web hosting >> ODBC Database Access for UAS PHP Web Applications

ODBC Database Access for UAS PHP Web Applications

The following guide details the configuration of a ODBC Data Source configuration to access a database on the UAS PHP web applications.

ODBC Data Source Configuration

  1. Ensure you are using the latest MySQL Connector/ODBC driver. We recommend using at least version 5.3.4.
    • CONNECT PC: If you you are using a CONNECT managed Windows desktop, we are aware of an issue with the deployed outdated version. Please install the latest version 5.3.4 using the 'Oxford Applications Installer'. There is a help page explaining the usage of the Oxford Applications Installer. If you need further help installing the latest ODBC client on CONNECT, please contact the CONNECT Service Desk at (2)81000 for support.
    • Self managed computer: Please download and install both the 32- and 64-bit versions of the connector from https://dev.mysql.com/downloads/connector/odbc/.
  2. Open the 'ODBC Data Source Administrator':
    • Windows 7: Click the Start button then type 'ODBC'; you will then see the option to start the Administrator.
    • Windows 8: Go to the Search (magnifying glass) and type 'ODBC'; you will see the option to start the 32-bit or 64-bit Administrator.
  3. Go to the 'User DSN' tab and take note of the name of the 'User Data Source' that you wish to connect to; in the below screenshot, this would be 'example':
    Screenshot of the ODBC Data Source Administrator
     
  4. Click 'Add' and you will be presented with a window similar to this:
    Screenshot of Selecting Driver for a New DSN in ODBC Administrator
     
  5. Select 'MySQL ODBC 5.3 ANSI Driver' and select 'Finish' and you will be presented with a window like this:
    Screenshot of Entering DSN Details into ODBC Data Source Administrator
     
  6. Enter the new Connection Parameters as follows:
    • 'Data Source Name': The ‘User Data Source’ name you noted earlier with _534 appended to the end; e.g. ‘example_534’
    • 'TCP/IP Server': webapp-db.nsms.ox.ac.uk
    • 'User': Your SSO username
    • 'Password': Provided by NSMS Help Desk - contact on (2)73 209
  7. Click the 'Test' button.
     
  8. Choose the 'Database' in the drop down list.
     
  9. Click 'OK'. 

If you use this ODBC connection to connect to a MS Access database, please contact pcapps@it.ox.ac.uk to have your database re-pointed at the new connection.

Please also see this YouTube Video on configuring an ODBC data source.

Support

Service area: 

Written by IT Services. Latest revision 19 March 2016