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
SQL Server Linked Server to Vertica varchar(65000) issue
Moderator: NorbertKrupa
Re: SQL Server Linked Server to Vertica varchar(65000) issue
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Fri May 08, 2015 4:41 pm, edited 1 time in total.
Re: SQL Server Linked Server to Vertica varchar(65000) issue
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
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
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!
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!
-
- 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
Take a look at my blog post on Creating a Linked Server Between SQL Server.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!
Checkout vertica.tips for more Vertica resources.