Table of Contents

Using the ODBC Interface

Using the ODBC interface

What is ODBC?

Using ODBC in InfoMaker

Components of an ODBC connection

Types of ODBC drivers

Ensuring the proper ODBC driver conformance levels

Obtaining ODBC drivers

Getting help with ODBC drivers

Preparing ODBC data sources

Defining ODBC data sources

How InfoMaker accesses the data source

Defining multiple data sources for the same data

Displaying Help for ODBC drivers

Selecting an ODBC translator

Defining the ODBC interface

SAP SQL Anywhere

Basic software components for SQL Anywhere

Preparing to use the SQL Anywhere data source

Defining the SQL Anywhere data source

Support for Transact-SQL special timestamp columns

What to do next

PostgreSQL

Using the OLE DB interface

About the OLE DB interface

What is OLE DB?

Components of an OLE DB connection

Obtaining OLE DB data providers

Supported versions for OLE DB

Preparing to use the OLE DB interface

Defining the OLE DB interface

Using the ADO.NET interface

Preparing to use the ADO.NET interface

Defining the ADO.NET interface

Required runtime files

ADO.NET custom driver

Introduction

Choosing an appropriate driver

Loading the driver

Obtaining the dependencies

Configuring the connection string

Working with the database painter

Distributing the custom driver

Known issues