Search found 2 matches

by hannonsb
Thu Feb 13, 2014 5:39 pm
Forum: ODBC
Topic: SQL Server Linked Server to Vertica varchar(65000) issue
Replies: 4
Views: 7898

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
by hannonsb
Thu Feb 13, 2014 3:41 pm
Forum: ODBC
Topic: SQL Server Linked Server to Vertica varchar(65000) issue
Replies: 4
Views: 7898

SQL Server Linked Server to Vertica varchar(65000) issue

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 leng...

Go to advanced search