Vertica 12.00.01.00

SQL Error. Native Code: -1, SQLState: 08001, Return Code: -1
The RemoteHost address is invalid.

Testing connection to Vertica in CompareData fails if the ODBC data source is a user DSN. Use ODBC Administrator System DSN tab to add the Vertica DSN as a system data source.

SQL Error. Native Code: 4856, SQLState: 42601, Return Code: -1
ERROR 4856:  Syntax error at or near "," at character 239

Attempting to insert into an identity column.