As far as I can tell, this driver was never released for Win32 - is there a reason for this?

 

The empty result set bug is impacting Win32, I posted a script to reproduce the problem.

 

Stephen

 

 

 

 

-----Original Message-----

From: Stephen Gutknecht (SAPDB) [mailto:[EMAIL PROTECTED]]

Sent: Wednesday, January 30, 2002 8:33 AM

To: Koetter, Thomas Theodor; [EMAIL PROTECTED]

Subject: RE: New ODBC driver for Linux, Perl DBD::ODBC for SAP DB

 

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 regardsThomas K�tter

 

 

 

Reply via email to