Hi, Will a new ODBC driver for Win32 be delivered soon? We are encountering the "empty result set" bug too (ADO / ODBC on Windows 2000).
Thank you. Stephen Gutknecht -----Original Message----- From: Koetter, Thomas Theodor [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 5:50 AM To: [EMAIL PROTECTED] Subject: New ODBC driver for Linux, Perl DBD::ODBC for SAP DB 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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
