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

Supported versions for 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 JDBC Interface

About the JDBC interface

What is JDBC?

Components of a JDBC connection

JDBC registry entries

Supported versions for JDBC

Supported JDBC datatypes

Preparing to use the JDBC interface

Defining the JDBC interface

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

About ADO.NET

About the InfoMaker ADO.NET database interface

Components of an ADO.NET connection

OLE DB data providers

Preparing to use the ADO.NET interface

Defining the ADO.NET interface