xfODBC User’s Guide

Version 10.3.3

This guide serves two groups of ODBC users: developers who create Synergy databases and are responsible for making them ODBC‑enabled, and end‑users who use xfODBC as a tool for accessing data. This guide is written for users who are already familiar with database concepts and terminology and with the platforms discussed in this guide.

Contents

Welcome to xfODBC

Using the Sample Database As a Tutorial

Preliminary Steps

Creating a System Catalog

Setting Up a Connect File

Viewing and Customizing the System Catalog

Creating Routines for User-Defined Data Types

Configuring Data Access

Accessing a Synergy Database

Optimizing Data Access

Data Access Errors and Error Logging

Appendix A: Environment Variables

Appendix B: SQL Support