ODBC client driver - COPY LOCAL disabled? (ERROR 5873)

tzahpahima123

I have a system running with multiple versions of the ODBC driver for windows.
The version I have deployed on most hosts is the 9.2 ODBC driver.
I need to use the COPY LOCAL command, but for some reason it seems like the clients do not support it (or maybe the problem has to do with my configuration on the client/server).
The error is as following:
ERROR [HY000] [Vertica][VerticaDSII] (210) Data streaming error: ERROR 5783: Client error: Copy local has been disabled on this connection (in function () at Bulkload.cpp:288)

How do I resolve this and allow for COPY LOCAL to be performed? Is it some connection property I am not aware of? Something in the .INI file? Or maybe some configuration on the server.

SruthiA

Please check if you have set DisableCopyLocal to 1 in your properties. if so, error is expected. please unset it and then try copy local

tzahpahima123

@SruthiA said:
Please check if you have set DisableCopyLocal to 1 in your properties. if so, error is expected. please unset it and then try copy local

Thank you, actually I had a "vertica.ini" file previously deployed in the same directory with "DisableCopyLocal=1".
It seems as if the connection string did not help, and the INI file overrided it.
Do you know if there is any solution other than changing the "vertica.ini"?
Either way you answered my question, thank you!

SruthiA

you are welcome. you can either edit the ini file or pass it in connection string as shown in the below link

https://docs.vertica.com/23.3.x/en/connecting-to/client-libraries/client-drivers/install-config/odbc/creating-an-odbc-data-source-name-dsn/setting-dsn-connection-properties/

Sergey_Cherepan_1

You can make ODBC driver to ignore odbc.ini by using SQLDriverConnect and passing all connect info in connection string:

isql -3 -k 'driver=/opt/vertica/lib64/libverticaodbc.so;database=;servername=vdb.vertica.com;uid=dbadmin;pwd=supersecret;label=Vertica example'
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| echo [string]                         |
| quit                                  |
|                                       |
+---------------------------------------+

isql is part of unixODBC rpm.
As you can see, DNS configuration is not required, you can use ODBC in mode similar to JDBC, with passing connection URL.

While you do not need odbc.ini or can make ODBC driver to ignore it, odbcinst.ini is always in force.