Linked server from Sql server to Vertica.
Hi Experts,
i have created a linked server from sql 2012 to Vertica.The set up is fine but when i try to exceute a query where the number of rows expected is more in that case i get the below error. Do i need to change some setting to make this working.Also queries where the output rows are very small they are working fine.
Error description:-
LE DB provider "MSDASQL" for linked server "VERTICA" returned message "Unspecified error".
OLE DB provider "MSDASQL" for linked server "VERTICA" returned message "[Vertica][VerticaDSII] (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.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_INDEXES" for OLE DB provider "MSDASQL" for linked server "VERTICA". The provider supports the interface, but returns a failure code when it is used.