www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Overview
Installation Guide
Quick Start & Tours
Sample ODBC & JDBC Applications
Conceptual Overview
Server Administration
Data Access Interfaces
Virtuoso .NET Data Provider
Interactive SQL Utility
Virtuoso Driver for ODBC
Virtuoso Driver for JDBC
OLE DB Provider for Virtuoso
Virtuoso In-Process Client
Unix Domain Socket Connections
SQL Reference
SQL Procedure Language Guide
Database Event Hooks
Data Replication, Synchronization and Transformation Services
Web Application Development
XML Support
RDF Database and SPARQL
Web Services
Runtime Hosting
Internet Services
Free Text Search
TPC C Benchmark Kit
Using Virtuoso with Tuxedo
Appendix
Virtuoso Functions Guide

Abstract

ISQL is an interactive utility to Virtuoso that allows the user to execute queries and scripts from a command line interface.

This chapter provides and explanation of the ODBC, JDBC, OLEDB and .Net driver implementations in Virtuoso.

Table of Contents

7.1. Virtuoso .NET Data Provider
7.1.2. VirtDbType Enumeration
7.1.3. VirtuosoCommand Class
7.1.4. VirtuosoCommandBuilder Class
7.1.5. VirtuosoConnection Class
7.1.6. VirtuosoDataAdapter Class
7.1.7. VirtuosoDataReader Class
7.1.8. VirtuosoError Class
7.1.9. VirtuosoErrorCollection Class
7.1.10. VirtuosoException Class
7.1.11. VirtuosoInfoMessageEventArgs Class
7.1.12. VirtuosoInfoMessageEventHandler Delegate
7.1.13. VirtuosoParameter Class
7.1.14. VirtuosoParameterCollection Class
7.1.15. VirtuosoPermission Class
7.1.16. VirtuosoPermissionAttribute
7.1.17. VirtuosoRowUpdatedEventArgs Class
7.1.18. VirtuosoRowUpdatedEventHandler Delegate
7.1.19. VirtuosoRowUpdatingEventArgs Class
7.1.20. VirtuosoRowUpdatingEventHandler Delegate
7.1.21. VirtuosoTransaction Class
7.2. Interactive SQL Utility
7.2.1. Invoking ISQL
7.2.2. ISQL Commands
7.2.3. ISQL Macro Substitution
7.2.4. ISQL Variables
7.2.5. Using isql as a General Purpose Test Driver
7.3. Virtuoso Driver for ODBC
7.3.1. Windows ODBC Driver Configuration
7.3.2. Using X509 Certificates With ODBC Connection
7.3.3. ODBC Compliance
7.3.4. Virtuoso Scrollable Cursor Engine
7.3.5. Effect of Connection & Statement Options
7.3.6. Efficient Use of API
7.4. Virtuoso Driver for JDBC
7.4.1. Virtuoso Drivers for JDBC Packaging
7.4.2. Virtuoso Driver For JDBC URL Format
7.4.3. Virtuoso Driver JDBC 3.0 features
7.4.4. Installation & Configuration Steps
7.5. OLE DB Provider for Virtuoso
7.5.1. Using the OLE DB Provider for Virtuoso
7.5.2. Known Limitations
7.5.3. Data Types
7.5.4. Metadata
7.5.5. Supported Interfaces
7.5.6. Data Source Objects
7.5.7. Sessions
7.5.8. Rowsets
7.6. Virtuoso In-Process Client
7.7. Unix Domain Socket Connections