Open Database Connectivity

2018 ◽  
pp. 2596-2597
Author(s):  
Changqing Li
2016 ◽  
Vol 13 (2) ◽  
pp. 195-213
Author(s):  
Sherwood Lane Lambert ◽  
Jon Holladay ◽  
Dawna M. Drum

ABSTRACT This education case teaches students Continuous Auditing/Continuous Monitoring (CA/CM) using Open Database Connectivity (ODBC) connections from students' Microsoft Access (Access) to tables in Microsoft SQL Server (SQL Server). First, the institution's database administrator (DBA) imports the student tables provided with the Teaching Notes into the institution's SQL Server with read-only access. In Access, students create ODBC connections to the SQL Server student tables. Then, students create Access queries using the ODBC-linked tables to monitor for anomalies. During a scheduled week, the DBA, in coordination with the faculty member, enters anomalies in the SQL Server student tables at random times, and students run their Access queries to identify the anomalies.


2016 ◽  
Vol 371 (1702) ◽  
pp. 20150328 ◽  
Author(s):  
Christopher C. M. Baker ◽  
Leonora S. Bittleston ◽  
Jon G. Sanders ◽  
Naomi E. Pierce

DNA barcoding and metabarcoding methods have been invaluable in the study of interactions between host organisms and their symbiotic communities. Barcodes can help identify individual symbionts that are difficult to distinguish using morphological characters, and provide a way to classify undescribed species. Entire symbiont communities can be characterized rapidly using barcoding and especially metabarcoding methods, which is often crucial for isolating ecological signal from the substantial variation among individual hosts. Furthermore, barcodes allow the evolutionary histories of symbionts and their hosts to be assessed simultaneously and in reference to one another. Here, we describe three projects illustrating the utility of barcodes for studying symbiotic interactions: first, we consider communities of arthropods found in the ant-occupied domatia of the East African ant-plant Vachellia ( Acacia ) drepanolobium ; second, we examine communities of arthropod and protozoan inquilines in three species of Nepenthes pitcher plant in South East Asia; third, we investigate communities of gut bacteria of South American ants in the genus Cephalotes . Advances in sequencing and computation, and greater database connectivity, will continue to expand the utility of barcoding methods for the study of species interactions, especially if barcoding can be approached flexibly by making use of alternative genetic loci, metagenomes and whole-genome data. This article is part of the themed issue ‘From DNA barcodes to biomes’.


Author(s):  
Shefali Trushit Naik

This chapter describes the method to retrieve data from multiple heterogeneous distributed relational database management systems such as MySQL, PostgreSQL, MS SQL Server, MS Access, etc. into Oracle RDBMS using Oracle's Heterogeneous Gateway Services. The complete process starting from downloading and installation of required software, creation of data source names using open database connectivity, modification of system parameter files, checking connections, creation of synonyms for tables of remote databases into oracle, creation of database links and accessing data from non-oracle databases using database links is explained in great detail. Apart from this, data manipulation in remote databases from Oracle and execution of PL/SQL procedures to manipulate data residing on remote databases is discussed with examples. Troubleshooting common errors during this process is also discussed.


Sign in / Sign up

Export Citation Format

Share Document