SAP Reports 2011, WIN, INTL, NUL 7090310 用户手册
产品代码
7090310
25.3.3.2 ODBC translation layer
Crystal Reports uses the Dynamic Link Library crdb_odbc.dll to communicate with ODBC. This file is
unique to Crystal Reports environment and provides your report with access to any ODBC data source.
This is the driver that actually passes data to and from ODBC.
unique to Crystal Reports environment and provides your report with access to any ODBC data source.
This is the driver that actually passes data to and from ODBC.
25.3.3.3 ODBC layer
ODBC is a set of several DLLs and INI files built into the Windows environment that act as a gateway
through which database requests and data can pass. Any database file or format that is to be used via
ODBC must be set up as an ODBC data source.
through which database requests and data can pass. Any database file or format that is to be used via
ODBC must be set up as an ODBC data source.
Although information regarding data sources is recorded in Odbc.ini and Odbcinst.ini, 32-bit ODBC
uses the Windows Registry database to retrieve information about individual data sources.
uses the Windows Registry database to retrieve information about individual data sources.
Note:
For more information on ODBC and the ODBC files, see the Microsoft ODBC documentation.
ODBC uses the SQL language for all transactions between Crystal Reports and ODBC. Even if the
database does not normally use SQL to create and work with tables, the ODBC driver provided by the
database (the DBMS translation layer) must communicate with ODBC using SQL. For most users, this
feature of ODBC is transparent, but more advanced users often take advantage of the features of the
SQL language used by ODBC.
database does not normally use SQL to create and work with tables, the ODBC driver provided by the
database (the DBMS translation layer) must communicate with ODBC using SQL. For most users, this
feature of ODBC is transparent, but more advanced users often take advantage of the features of the
SQL language used by ODBC.
25.3.3.4 DBMS translation (ODBC data source) layer
This layer consists of one or more drivers provided by a DBMS that allow ODBC to communicate with
the database. Crystal Reports ships with several ODBC drivers for many of the most common database
formats. If you are unsure whether you can use an ODBC driver to access the data in your database,
refer to the documentation for your DBMS application. Most DBMS applications that run on a
Windows-based platform offer an ODBC driver.
the database. Crystal Reports ships with several ODBC drivers for many of the most common database
formats. If you are unsure whether you can use an ODBC driver to access the data in your database,
refer to the documentation for your DBMS application. Most DBMS applications that run on a
Windows-based platform offer an ODBC driver.
When a DBMS provides an ODBC driver, it must register the driver with ODBC on the machine on
which it has been installed. It does this by assigning a name to the driver and recording the filename
in the Odbcinst.ini file. Usually, this step is handled automatically when the DBMS application is installed
on the system. However, your network system or DBMS application may require that you register the
ODBC driver manually with the ODBC Setup application. For more information about registering an
ODBC driver with ODBC, refer to the documentation for your DBMS.
which it has been installed. It does this by assigning a name to the driver and recording the filename
in the Odbcinst.ini file. Usually, this step is handled automatically when the DBMS application is installed
on the system. However, your network system or DBMS application may require that you register the
ODBC driver manually with the ODBC Setup application. For more information about registering an
ODBC driver with ODBC, refer to the documentation for your DBMS.
2011-05-16
648
Accessing Data Sources