The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Microsoft Query error when querying more than one table

edited May 2018 in General Discussion

Using Microsoft Query to connect to a HP Vertica database, I cannot add more than one table for visualization in Microsoft Query but I am able to in Microsoft Excel using the Data ODBC connection. I am also able to view any table content in the Linux server or in DBVisualizer (database management tool)

The error in Microsoft Query says:
[20] An error occurred during query execution: Multiple commands cannot be active on the same connection. Consider increasing ResultBufferSize or fetching all results before initiating another command.

**Specs: **
Microsoft Query in Microsoft Excel 2010; also in 2016
HP Vertica 8.1.0
Driver Client 9.1.0

Leave a Comment

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