ODBC explained and Demonstrated

    Maggie Shapland, Computing Service, Nov 1998

      Table of Contents

  • Agenda
  • ODBC
  • Reasons for and against using ODBC
  • Setting up ODBC data source
  • Using Microsoft Access97 with Oracle data.
  • Reattaching
  • Sending Access data to ORACLE
  • Points to note: Data Definition
  • Points to note: Data Entry
  • Points to note: Queries
  • Security
  • Sharing data
  • Locking data
  • Optimising performance
  • Optimising queries
  • Optimising queries - avoid:
  • Optimising forms
  • Timing (seconds)
  • Timing comparison of methods