Hmm. I tried this too. I copied the windows vsql executable to a new directory and then uninstalled the Vertica 6 drivers (if you don't copy the executable it gets deleted during the uninstall). I then installed the 4.19 drivers but still could not connect to a Vertica 5 database using the Vertica 6 vsql Windows client I copied previously
Code: Select all
C:\Vertica\bin>vsql -h verticatest01 -U dbadmin
vsql: FATAL : unsupported frontend protocol 3.3: server supports 3.0 to 3.1
Note that I could still connect to a Vertica 6.0.0-2 database:
Code: Select all
C:\Vertica\bin>vsql -h verticatest01 -U dbadmin
Welcome to vsql, the Vertica Analytic Database interactive terminal.
Type: \h for help with SQL commands
\? for help with vsql commands
\g or terminate with semicolon to execute query
\q to quit
Warning: Console code page (437) differs from Windows code page (1252)
8-bit characters may not work correctly. See vsql reference
page "Notes for Windows users" for details.
dbadmin=> select version();
version
------------------------------------
Vertica Analytic Database v6.0.0-3
(1 row)