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
0
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.