Skip Menu |
 

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

Report information
The Basics
Id: 88607
Status: new
Priority: 0/
Queue: DBD-ODBC

People
Owner: Nobody in particular
Requestors: bohica [...] ntlworld.com
Cc:
AdminCc:

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 http://msdn.microsoft.com/en-us/library/ms711818(v=vs.85).aspx: 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 Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.