Dear users
1. a new ODBC driver for Linux is available
ftp.sap.com/pub/sapdb/bin/patch/sapdb-odbc-linux-i386-7.3.0.21.tgz
bug fixes: - two problems in conjunction with perl's DBD::ODBC
(SQLError, i/o parameter that is NULL)
- freeing statement handles belonging to empty result sets
Thanks to Flemming Frandsen for bug reporting and the SAP DB patch inside of
DBD::ODBC.
Thanks to Johan Sch�n for accurate information regarding the "empty result
set" bug.
2. Using SAP DB with Perl
As Daniel Dittmar stated on 24. Jan. DBD::SAP_DB will not be developped and
maintained in the future. Instead of this the usage of DBD::ODBC is
recommended.
Since version 0.31 the DBD::ODBC package
(http://search.cpan.org/search?module=DBD::ODBC) contains direct SAP DB ODBC
support.
Please have in mind that there are two ways of using ODBC on Linux:
- install DBD::ODBC directly for SAP DB ODBC
- install DBD::ODBC for a driver manager (iODBC, unixODBC)
The first one gives you exclusive access to SAP DB over DBD and demands
version 0.31 or higher.
Advantage: less components, less installation
Disadvantage: runs with exactly one driver, reinstallation for new
versions of the ODBC driver
The second one allows you to switch between several ODBC drivers or
different versions of a ODBC driver. This one is not specific to SAP DB so
that earlier versions than 0.31 might work.
Advantage: needs to be installed once, runs arbitrary many
drivers
Disadvantage: one more component, one more installation
Notes for building DBD::ODBC for SAP DB:
Set the environment ODBCHOME to the directory where the subdirectory incl
and lib of the tar are installed. Call "perl Makefile.PL" and following
described in the DBD documentation. Instead of defining data source names
(in /var/spool/sql/ini/odbc.ini or ~/.odbc.ini) it is also possible to set
"hostname:dbname" as DNS string in SQLConnect.
With kind regards Thomas K�tter
----------------------------------------------
Dr. Thomas K�tter
SAP DB, SAP Labs Berlin
SAP DB is open source. Get it! www.sapdb.org
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
