We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Linked server from Sql server to Vertica. — Vertica Forum

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.

Leave a Comment

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