manual.texi

unix上的ODBC实现

\input texinfo  @c -*-texinfo-*-
@c Copyright 1995-2002 MySQL AB
@c
@c This manual is NOT distributed under a GPL style license.
@c Use of the manual is subject to the following terms:
@c - Conversion to other formats is allowed, but the actual
@c   content may not be altered or edited in any way.
@c - You may create a printed copy for your own personal use.
@c - For all other uses, such as selling printed copies or
@c   using (parts of) the manual in another publication,
@c   prior written agreement from MySQL AB is required.
@c
@c Please e-mail [e-mail] for more information or if
@c you are interested in doing a translation.
@c
@c *********************************************************
@c Note that @node names are used on our web site.
@c So do not change node names without checking
@c Makefile.am and SitePages first.
@c *********************************************************
@c
@c %**start of header

@setfilename manual.info

@c We want the types in the same index
@c syncodeindex tp fn

@c Get version information. This file is generated by the Makefile!!
@include include.texi

@ifclear tex-debug
@c This removes the black squares in the right margin
@finalout
@end ifclear

@c Set background for HTML
@set _body_tags BGCOLOR=#FFFFFF TEXT=#000000 LINK=#003366 VLINK=#001933 ALINK=#FF0000
@c Set some style elements for the manual in HTML form. 'suggested'
@c natural language colors: aqua, black, blue, fuchsia, gray, green,
@c lime, maroon, navy, olive, purple, red, silver, teal, white, and
@c yellow. From Steeve Buehler <[e-mail]>
@set _extra_head <style> code {color:purple} tt {color:green} samp {color:navy} pre {color:maroon} </style>

@settitle MyODBC Reference Manual for version @value{myodbc3_version}

@c We want single-sided heading format, with chapters on new pages. To
@c get double-sided format change 'on' below to 'odd'
@setchapternewpage on

@paragraphindent 0

@c %**end of header

@ifinfo
@format
START-INFO-DIR-ENTRY
* manual: (manual).               MyODBC 3 documentation.
END-INFO-DIR-ENTRY
@end format
@end ifinfo

@titlepage
@sp 10
@center @titlefont{MyODBC Programmer's Reference Manual}
@sp 10
@center Copyright @copyright{} 1995-2002 MySQL AB
@center   @uref{http://www.mysql.com}
@c blank page after title page makes page 1 be a page front.
@c also makes the back of the title page blank.
@page
@end titlepage

@c Short contents, blank page, long contents.
@c until i can figure out the blank page, no short contents.
@c @shortcontents
@c @page
@c @page
@contents

@c This should be added. The HTML conversion also needs a MyODBC version
@c number somewhere.

@iftex
@c change this to double if you want formatting for double-sided
@c printing
@headings single

@oddheading @thischapter @| @| @thispage
@evenheading @thispage @| @| MyODBC Programmer's Reference Manual 
for Version @value{myodbc3_version}

@end iftex


@node Top, Introduction, (dir), (dir)

@ifinfo
This is the manual of the MyODBC driver, which provides ODBC 3.51 
compliant access to the MySQL Database System. 
This version is about the @value{myodbc3_version} version of 
MyODBC. You can find a specific manual for any older version of 
MyODBC in the binary or source distribution for that version.
@end ifinfo



@menu
* Introduction::                Introduction
* General Information::         General Information About ODBC and MyODBC 3.51
* Developing Applications Using MyODBC::  Developing Applications Using MyODBC
* MyODBC API Reference::        MyODBC API Reference
* MyODBC Data Types::           MyODBC Data Types
* MyODBC Error Codes::          MyODBC Error Codes
* MyODBC With VB::              MyODBC with ADO, DAO and RDO
* MyODBC With .NET::            
* Credits::                     
* GPL license::                 GNU GENERAL PUBLIC LICENSE
@end menu

@node Introduction, General Information, Top, Top
@chapter Introduction

@menu
* What is MySQL::               What is MySQL
* What is MySQL AB::            What is MySQL AB
* What is MyODBC::              What is MyODBC
* What is MyODBC 3.51::         What is MyODBC 3.51
* About This Manual ::          About This Manual
* Intended Audience ::          Intended Audience
@end menu

@node What is MySQL, What is MySQL AB, Introduction, Introduction
@section What is MySQL
@code{MySQL}, the most popular Open Source SQL database, is developed
and provided by @code{MySQL AB}. @code{MySQL AB} is a commercial company
that builds its business providing services around the @code{MySQL} database.
The @code{MySQL} web site (@uref{http://www.mysql.com/}) provides
the latest information about @code{MySQL} software and @code{MySQL AB}.



@node What is MySQL AB, What is MyODBC, What is MySQL, Introduction
@section What is MySQL AB
@code{MySQL AB} is the Swedish company owned and run by the @code{MySQL}
founders and main developers. We are dedicated to developing @code{MySQL}
and spreading our database to new users. @code{MySQL AB} owns the
copyright to the @code{MySQL} server source code and the @code{MySQL}
trademark. A significant amount of revenues from our services goes to
developing @code{MySQL}.



@node What is MyODBC, What is MyODBC 3.51, What is MySQL AB, Introduction
@section What is MyODBC

@code{@strong{MyODBC 2.50}} is a 32-bit ODBC Driver from @code{@strong{MySQL AB}},
which is based on @strong{ODBC 2.50 specification} Level 0 (with level 1 and 2 
features). This is one of the most popular ODBC Driver in the open source 
market, used by many users to access the MySQL functionality.


@node What is MyODBC 3.51, About This Manual , What is MyODBC, Introduction
@section What is MyODBC 3.51
.
@code{@strong{MyODBC 3.51}} is a 32-bit ODBC Driver, also known as MySQL ODBC 
3.51 Driver. This is a enhanced version to the existing MyODBC 2.50, with 
@strong{ODBC 3.5x specification} level 1(complete core API + level 2 features) 
in order to continue to provide all functionality of ODBC to access MySQL.


@node About This Manual , Intended Audience , What is MyODBC 3.51, Introduction
@section About This Manual
This manual contains information about the usage of MySQL ODBC Drivers,
MyODBC and MyODBC 3.51, in order to explore MySQL capabilities by means
of ODBC API.

Note, as this manual is a reference to the ODBC programming for the
MySQL ODBC Drivers, not all ODBC concepts and practices may be covered
fully.
The manual is currently available in Texinfo, Info, plain text and HTML
formats,
and is being maintained by Monty Widenius, Venu Anuganti and Arjen Lentz.
For any changes or contributions to the manual, please send a mail to
@email{docs@@mysql.com} or to @email{myodbc@@lists.mysql.com}.




@node Intended Audience ,  , About This Manual , Introduction
@section Intended Audience
This manual assumes a good working knowledge of C, general DBMS knowledge,
and finally, but not least, familiarity with MySQL.
For more information about MySQL functionality and its syntax, refer to
@uref{http://www.mysql.com/documentation/index.html}.



@node General Information, Developing Applications Using MyODBC, Introduction, Top
@chapter General Information About ODBC and MyODBC 3.51
This chapter contains the general information about ODBC and MyODBC.

@menu
* Introduction to ODBC::        Introduction to ODBC
* What is ODBC::                What is ODBC
* ODBC Standard::               How Does ODBC Standardize Database Access
* ODBC Architecture::           
* Types of MySQL ODBC Drivers::  Types of MySQL ODBC Drivers
* Where Can I Get MyODBC::      Where Can I Get MyODBC
* How To Install MyODBC::       How To Install MyODBC
* Supported Platforms::         Supported Platforms
* MyODBC Mailing List::         MyODBC Mailing List
* MyODBC Support ::             MyODBC Support
* Reporting Problems::          How to Report MyODBC Problems or Bugs
* Programs Known to Work With MyODBC::  Programs Known to Work With MyODBC
@end menu



@node Introduction to ODBC, What is ODBC, General Information, General Information
@section Introduction to ODBC
Open Database Connectivity (ODBC) is a widely accepted application-programming
interface (API) for database access. It is based on the Call-Level Interface
(CLI) specifications from X/Open and ISO/IEC for database APIs and uses
Structured Query Language (SQL) as its database access language.

ODBC is designed for maximum interoperability, that is, the ability of a
single application to access different database management systems with
the same source code. Database applications call functions in the ODBC
interface, which are implemented in database-specific modules called
drivers. The use of drivers isolates applications from database-specific