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
Issue:
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
0