ODBC Connectivity by Brian Ripley Department of Statistics, University of Oxford ripley@stats.ox.ac.uk May 11, 2020 Package RODBC implements ODBC database connectivity. 1.3 Overview Interfaces The interface of the ODBC application is divided into three parts: Functions for starting and stopping ODBC servers. The Basic API which is almost identical to that defined by the ODBC standard. We will talk about how to develop Data Virtualization projects with Denodo Virtual DataPort, how to build data combinations that come from different data sources, how to expose virtualized data as a service, and more. These step-by-step tutorials cover a series of topics about the Denodo Platform. odbc_statistics — Retrieve statistics about a table odbc_tableprivileges — Lists tables and the privileges associated with each table odbc_tables — Get the list of table names stored in a specific data source
MySQL Connector/ODBC provides both driver-manager based and native interfaces to the MySQL database, with full support for MySQL functionality, including stored procedures, transactions and, with Connector/ODBC 5.1 and higher, full Unicode compliance. An ODBC serving process can be compared to an Erlang port. Part 1 Introduction to ODBC, providing conceptual information about the ODBC interface and a brief history of Structured Query Language; Part 2 Developing Applications, containing information for developing applica- TheUtility API which supplies a few easy-to-use functions for database access with little control over details.
It was originally written by Michael Lapsley (St George’s Medical School, University of London) in the early days of R