Page 1 of 1

SQL Server Linked Server to Vertica varchar(65000) issue

Posted: Thu Feb 13, 2014 3:41 pm
by hannonsb
I am querying Vertica 6.1.3 via SQL Server ODBC linked server. The column on Vertica is varchar(65000) and continues to give a "Requested conversion is not supported." error. Any idea how to make SQL Server think this is a varchar(max) field or other solutions? It appears that any column with a length greater than 4000 is not supported via the ODBC driver.
In my web searching I found a reference to setting collation compatible to true in the linked server properties, but this did not help.
Thanks,
Scott

Re: SQL Server Linked Server to Vertica varchar(65000) issue

Posted: Thu Feb 13, 2014 3:54 pm
by id10t
Hi!

[DELETED]

Re: SQL Server Linked Server to Vertica varchar(65000) issue

Posted: Thu Feb 13, 2014 5:39 pm
by hannonsb
Thanks sKwa.
It's pure ODBC with the MSDASQL driver in SQL server. Since it's in a stored proc on SQL Server, I ended up joining the openquery results with the duplicate table on the SQL Server side.
This was the quickest and easiest solution, even if not the pure Vertica solution.

-Scott

Re: SQL Server Linked Server to Vertica varchar(65000) issue

Posted: Tue Jun 16, 2015 9:40 pm
by sashakla
Hi hannonsb,

I know this is an old thread, but i was looking for the info on how to setup MSSSQL-Vertica connectivity and google offered this link. Would you be able to share some details on how you setup the linked server (where did you get the drivers etc) - I'd greatly appreciate it.

Thank you!

Re: SQL Server Linked Server to Vertica varchar(65000) issue

Posted: Wed Jun 17, 2015 4:19 am
by NorbertKrupa
sashakla wrote:Hi hannonsb,

I know this is an old thread, but i was looking for the info on how to setup MSSSQL-Vertica connectivity and google offered this link. Would you be able to share some details on how you setup the linked server (where did you get the drivers etc) - I'd greatly appreciate it.

Thank you!
Take a look at my blog post on Creating a Linked Server Between SQL Server.