SQL Server Linked Server to Vertica varchar(65000) issue

Moderator: NorbertKrupa

Post Reply
hannonsb
Newbie
Newbie
Posts: 2
Joined: Thu Feb 13, 2014 3:28 pm

SQL Server Linked Server to Vertica varchar(65000) issue

Post by hannonsb » Thu Feb 13, 2014 3:41 pm

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

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

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

Post by id10t » Thu Feb 13, 2014 3:54 pm

Hi!

[DELETED]
Last edited by id10t on Fri May 08, 2015 4:41 pm, edited 1 time in total.

hannonsb
Newbie
Newbie
Posts: 2
Joined: Thu Feb 13, 2014 3:28 pm

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

Post by hannonsb » Thu Feb 13, 2014 5:39 pm

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

sashakla
Newbie
Newbie
Posts: 1
Joined: Tue Jun 16, 2015 9:37 pm

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

Post by sashakla » Tue Jun 16, 2015 9:40 pm

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!

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

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

Post by NorbertKrupa » Wed Jun 17, 2015 4:19 am

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.
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “ODBC”