faq.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 faq.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- Frequently Asked Questions 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
* faq: (faq). MyODBC 3.51 FAQs
END-INFO-DIR-ENTRY
@end format
@end ifinfo

@titlepage
@sp 10
@center @titlefont{MyODBC - Frequently Asked Questions for version @value{myodbc3_version}}
@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 @| @| MySQL ODBC 3.51 Driver - Frequently Asked Questions

@end iftex

@node Top, General Information, (dir), (dir)

@ifinfo
This is the MyODBC - Frequently Asked Questions for version @value{myodbc3-version}
@end ifinfo


@menu
* General Information::         General Information about ODBC, MyODBC and MyODBC 3.51       
* Installation Related::        About MyODBC (3.51) Installation
* Connection Related::          About MyODBC (3.51) Connection Related
* MS Access Related::           MS Access Related
* VB Related::                  MyODBC (3.51) with VB, ADO, DAO, RDO and ASP
* tools::                       
* General Functionality::       General Functionality
@end menu

@node General Information, Installation Related, Top, Top
@chapter General Information about ODBC, MyODBC and MyODBC 3.51



@menu
* ODBC::                        What is ODBC and where does it come from ?
* MyODBC 2.50::                 What is MyODBC 2.50 ?               
* MyODBC 3.51::                 What is MyODBC 3.51 ?
* Downloads::                   Where can I download the latest versions of MyODBC (3.51) ?
* Operating Systems::           What Operating systems will MyODBC (3.51) run on ?
* Driver Manager::              What is the ODBC Driver Manager ?
* MyODBC Support::              How do I get the support for MySQL and/or MyODBC ?
* Reporting Problems::          How do I report the problems or bugs with MyODBC (3.51) ?
* Feature Request::             How do I request a feature or a patch to MyODBC (3.51) ?
* Submit a patch::              Can I submit a patch to MyODBC (3.51) ?
* Mailing list::                Does MySQL have any mailing list or newsgroup for ODBC related discussions ?
@end menu


@node ODBC, MyODBC 2.50, General Information, General Information
@section What is ODBC and where does it come from ?

@strong{ODBC} (@code{@strong{Open Database Connectivity}}) provides a way for client programs to 
access a wide range of databases or data sources.

ODBC is a standardized API, developed according to the specifications of
the SQL Access Group, that allows one to connect to SQL databases. It 
defines a set of function calls, error codes and data types that can be
used to develop database independent applications.

ODBC is usually used when database Independence or simultaneous access 
to different data sources is required.

For more information about ODBC, refer to @uref{http://www.microsoft.com/data/odbc/}.



@node MyODBC 2.50, MyODBC 3.51, ODBC, General Information
@section What is MyODBC 2.50 ?


@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 MyODBC 3.51, Downloads, MyODBC 2.50, General Information
@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 Downloads, Operating Systems, MyODBC 3.51, General Information
@section Where can I download the latest versions of MyODBC (3.51) ?


@code{MySQL AB} distributes all its products under @code{General Public License}
(GPL). You can get the latest, free copy of @code{MyODBC} or @code{MyODBC 3.51}
driver binaries and sources from its website @uref{http://www.mysql.com/}.

@code{@strong{MySQL ODBC 3.51 Programmer's Reference Manual}} can be found from 
@uref{http://www.mysql.com/products/myodbc/manual_toc.html}. For more information 
about MySQL ODBC Drivers, visit MySQL ODBC Home Page 
@uref{http://www.mysql.com/products/myodbc/}.


@node Operating Systems, Driver Manager, Downloads, General Information
@section What Operating systems will MyODBC (3.51) run on ?


@code{MySQL ODBC Drivers} can be used on all major platforms supported by
@code{MySQL}, such as:

@itemize @bullet
@item All Windows platforms, 95/98 and NT/ME/2000/XP
@item All Unix Operating Systems
@itemize @bullet
@item AIX
@item Amiga
@item BSDI
@item DEC
@item FreeBSD
@item HP-UX
@item Linux
@item Mac OS X Server
@item NetBSD
@item OpenBSD
@item OS/2
@item SGI Irix
@item Solaris
@item SunOS
@item SCO OpenServer
@item SCO UnixWare
@item Tru64 Unix
@end itemize
@end itemize

In General, MyODBC (3.51) is supported in all the platforms that
MySQL supports.

If the binary distribution is not available for downloading for a
particular platform, then you can build the driver yourself, by
downloading the driver sources and contribute the binaries to MySQL,
by sending a mail to @email{myodbc@@lists.mysql.com}, so that it
becomes easy for other users.



@node Driver Manager, MyODBC Support, Operating Systems, General Information
@section What is the ODBC Driver Manager ?


The ODBC Driver Manager is a library that manages communication 
between the ODBC aware application and driver(s). Its main functionality 
includes: