vsql 5.0 client

[vzingertal]

Where can I find vsql 5.0 client for windows. The latest version of client (6.0) is incompatible with our Vertica server (5.0) :

FATAL : unsupported frontend protocol 3.3: server supports 3.0 to 3.1

[id10t]

Hi vzingertal!

Does exist such creature?

PS [...] protocol 3.3: server supports 3.0 to 3.1 [...] - it's about ODBC "server"

[vzingertal]

Which means that ODBC is being used when we use vsql on Windows (Cygwin) connecting to the remote Server. Nevertheless, how can I get around this problem? Help would be greatly appreciated!

[id10t]

Hi!

>> Which means that ODBC is being used when we use vsql on Windows (Cygwin) connecting to the remote Server.
Yeap, looks like ODBC is being used.
About your problem: try to "downgrade" ODBC drivers. How to do it I don't know sorry, I don't use Windows, but it should be a dll file.

[vzingertal]

You are right - downgrade is a ticket. The question is where to get Vertica ODBC drivers of a lower level. Or this is generic Windows ODBC drivers that are problematic? Man, what a hassle

[JimKnicely]

vzingertal,

You can download the Vertica 5.0 Database Windows ODBC drivers (version 4.19) from Vertica's site:

32-bit:

• http://my.vertica.com/software-license- ... 4.1.19.exe

64-bit:

• http://my.vertica.com/software-license- ... .19_64.exe

[vzingertal]

Thank you for your help, but I still get the same error message. The Vertica 5.0 ODBC drivers are still ODBC 3.5 according to the DLL names:
vertica_4.1_odbc_3.5_64.dll
vertica_4.1_odbc_3.5_64.lib

For some reason our server doesn't support anything above 3.1 Bummer...