Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

Comments

  • 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 

     

    resultbuffersize=0

     

    Please check you spelling.

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

     

     

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.