Progress
ODBC Driver Guide


Preface

Purpose

This manual describes how to configure the Progress SQL-92 ODBC driver to provide access to the Progress database from desktop tools and applications that support the ODBC (Open Database Connectivity) interface. This manual also provides details about the information returned to your application by the driver. The Progress SQL-92 ODBC driver is supplied by MERANT Inc. In this manual, the driver will be referred to generically as the Progress SQL-92 ODBC driver.

Audience

This book is designed as a guide for anyone who wants to use the Progress SQL-92 ODBC driver to access a Progress Version 9 database.

Organization of This Manual

"Introduction"

Introduces the Progress SQL-92 ODBC driver and describes how it works.

"Configuring Progress Data Sources"

Describes how to add and modify, Progress data sources that use the Progress SQL-92 ODBC driver on Windows.

"ODBC API and Scalar Functions"

This chapter lists the ODBC API functions that the Progress SQL-92 ODBC driver supports. It also lists the scalar functions used in SQL-92 statements

"The UNIX Environment"

This chapter describes how to configure the Progress SQL-92 ODBC Driver in the UNIX environment.

"SQLGetInfo"

This appendix shows information the Progress SQL-92 ODBC driver Returns to SQLGetInfo.

"Progress and ODBC Data Types"

This appendix shows how the Progress data types are mapped to the standard ODBC data types.

"Glossary"

Defines terms introduced in this guide.

Index

How to Use This Manual

This book assumes that you have successfully installed the Progress database as described in the Progress Installation and Configuration Guide Version 9 for Windows , or the Progress Installation and Configuration Guide Version 9 for UNIX .

Typographical Conventions

This manual uses the following typographical conventions:

The following typographical conventions are used to represent keystrokes:

Syntax Notation

The syntax for each SQL-92 component follows a set of conventions:

Other Useful Documentation

This section lists Progress Software Corporation documentation that you might find useful. Unless otherwise specified, these manuals support both Windows and Character platforms and are provided in electronic documentation format on CD-ROM.

Getting Started

Progress Electronic Documentation Installation and Configuration Guide (Hard copy only)

A booklet that describes how to install the Progress EDOC viewer and collection on UNIX and Windows.

Progress Installation and Configuration Guide Version 9 for UNIX

A manual that describes how to install and set up Progress Version 9.1 for the UNIX operating system.

Progress Installation and Configuration Guide Version 9 for Windows

A manual that describes how to install and set up Progress Version 9.1 for all supported Windows and Citrix MetaFrame operating systems.

Progress Version 9 Product Update Bulletin

A guide that provides a brief description of each new feature of the release. The booklet also explains where to find more detailed information in the documentation set about each new feature.

Progress Master Glossary for Windows and Progress Master Glossary for Character (EDOC only)

Platform-specific master glossaries for the Progress documentation set. These books are in electronic format only.

Progress Master Index and Glossary for Windows and Progress Master Index and Glossary for Character (Hard copy only)

Platform-specific master indexes and glossaries for the Progress hard-copy documentation set.

Progress Startup Command and Parameter Reference

A reference manual that describes the Progress startup commands and parameters in alphabetical order.

Welcome to Progress (Hard copy only)

A booklet that explains how Progress software and media are packaged. An icon-based map groups the documentation by functionality, providing an overall view of the documentation set. Welcome to Progress also provides descriptions of the various services Progress Software Corporation offers.

4GL

Progress Internationalization Guide

A guide to developing Progress applications for markets worldwide. The guide covers both internationalization—writing an application so that it adapts readily to different locales (languages, cultures, or regions)—and localization—adapting an application to different locales.

Database

Progress Database Design Guide

A guide that uses a sample database and the Progress Data Dictionary to illustrate the fundamental principles of relational database design. Topics include relationships, normalization, indexing, and database triggers.

Progress Database Administration Guide and Reference

This guide describes Progress database administration concepts and procedures. The procedures allow you to create and maintain your Progress databases and manage their performance.

DataServers

Progress DataServer Guides

These guides describe how to use the DataServers to access non-Progress databases. They provide instructions for building the DataServer modules, a discussion of programming considerations, and a tutorial. Each DataServer has its own guide, such as: the Progress DataServer for Microsoft SQL Server Guide , the Progress DataServer for ODBC Guide , the Progress DataServer for ORACLE Guide , or the Progress/400 Product Guide

SQL-92

Progress Embedded SQL-92 Guide and Reference

A guide to Progress Embedded SQL-92 for C, including step-by-step instructions for building ESQL-92 applications and reference information about all Embedded SQL-92 Preprocessor statements and supporting function calls. This guide also describes the relationship between ESQL-92 and the ANSI standards upon which it is based.

Progress JDBC Driver Guide

A guide to the Java Database Connectivity (JDBC) interface and the Progress SQL-92 JDBC driver. It describes how to set up and use the driver and details the driver’s support for the JDBC interface.

Progress SQL-92 Guide and Reference

A user guide and reference for programmers who use Progress SQL-92. It includes information on all supported SQL-92 statements, SQL-92 Data Manipulation Language components, SQL-92 Data Definition Language components, and Progress functions. The guide describes how to use the Progress SQL-92 Java classes and how to create and use Java stored procedures and triggers.

SQL-92 Reference

(These are non-Progress resources available from your technical bookseller.)

A Guide to the SQL Standard

Date, C.J., with Hugh Darwen. 1997. Reading, MA: Addison Wesley.

Understanding the New SQL: A Complete Guide

Melton, Jim (Digital Equipment Corporation) and Alan R. Simon. 1993. San Francisco: Morgan Kaufmann Publishers.

ODBC Reference

Microsoft ODBC 3.0 Programmer’s Reference

Microsoft Press
A Division of Microsoft Corporation
One Microsoft Way
Redmond, Washington, 1997


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095