Skip Menu | will be shut down on March 1st, 2021.

This queue is for tickets about the DBD-ODBC CPAN distribution.

Report information
The Basics
Id: 88607
Status: new
Priority: 0/

Owner: Nobody in particular
Requestors: bohica [...]

Bug Information
Severity: (no value)
Broken in: 1.43
Fixed in: (no value)

Subject: Some ODBC drivers don't support SQL_ATTR_PARAMSET_SIZE and it breaks native execute_for_fetch
Download (untitled) / with headers
text/plain 1017b
DBD::ODBC's native execute_for_fetch sets SQL_ATTR_PARAM_BIND_TYPE, SQL_ATTR_PARASET_SIZE etc but some ODBC drivers (MS Access) don't support arrays of parameters. According to the MS site at Before an application uses arrays of parameters, it must be sure that they are supported by the drivers used by the application. There are two ways to do this: Use only drivers known to support arrays of parameters. The application can hard-code the names of these drivers, or the user can be instructed to use only these drivers. Custom applications and vertical applications commonly use a limited set of drivers. Check for support of arrays of parameters at run time. A driver supports arrays of parameters if it is possible to set the SQL_ATTR_PARAMSET_SIZE statement attribute to a value greater than 1. Generic applications and vertical applications commonly check for support of arrays of parameters at run time. Martin -- Martin J. Evans Wetherby, UK

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to