| Subject: | Some ODBC drivers don't support SQL_ATTR_PARAMSET_SIZE and it breaks native execute_for_fetch |
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