How to do multiple commands on the same connection

Hello everbody,


I'm using Vertica 7.1.1 with SAP Business Objects. Business Objects is connected to Vertica with a generic ODBC connection. 
When i try to launch a query, Business Objects tells me that multiple commands cannot be active on the same connection (I attached the error in this message).

I think that the problem is maybe with the configuration of the ODBC, so i change the ResultBufferSize to 0 in the ODBC but the error is still prompting.


If someone has an idea


Best Regards


Benyamine Samah


  • Options

    Please do the following for the resultbuffersize setting.

    Set it to 0

    If windows make sure you use the right ODBC admin for the DSN.

    You should change it for both 32bit and 64bit since the UD and IDT are 32bit and the server is 64bit.

    For windows

    64bit location is C:\Windows\System32\odbcad32.exe

    32but locaiton is C:\Windows\SysWOW64\odbcad32.exe

    You should then restart the server

    for linux you need to modify the odbc.ini to include the 




    Please check you spelling.

    Please restart the BOBJ Enterprise server to pick up the new settings.



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file