ODBC driver does not support retrieving execution status

Aquilis · Post by **Aquilis** » Fri Sep 06, 2013 6:27 am

Hi,

Hit with below error, as it's working in all environments except production environment.

we are using ODBC connector to connect to SQL Server.
In all environments the array size and record count is - 2000 (default).

Code: Select all

odbc_lccyp,0: This driver does not support retrieving execution status for each row of a batch insert, which is a requirement to set array size greater than 1 for this operation. Please reset array size to 1

can any one point me to the issue.

ArndW · Post by **ArndW** » Fri Sep 06, 2013 7:21 am

Which ODBC driver are you using?

One reason might be that you have the "bulk insert mode" enabled in your Windows ODBC driver definition for this data source. Try changing that setting, or using just updates in your SQL with no inserts to see if the error message remains the same.

chulett · Post by **chulett** » Fri Sep 06, 2013 7:32 am

As noted, it would seem you have different ODBC drivers in production or they are configured differently.

Aquilis · Post by **Aquilis** » Fri Sep 06, 2013 12:00 pm

Compared the Driver versions and ODBC DSN connections, all seems similar.
Anyway we raised a PMR for this IBM. awaiting response.

Didn't able to locate - bulk insert mode" enabled in Windows ODBC driver.
Meanwhile where can we verify it ? Could you suggest or point me there, please?

ArndW · Post by **ArndW** » Sat Sep 07, 2013 6:46 am

Open up your 32-bit ODBC driver window, select your ODBC driver that you are using. Is it the IBM Native SQL-Server wire driver? If yes, then navigate to the "Bulk" tab and is the "Enable Bulk Load" switch active?