I'm trying to use vertica with Golang over ODBC. I can connect OK and am getting an error of "Syntax error at or near "\" at character 31" for the query "select * from public.value_ref" - character 31 would be after the last letter of the table. No variations to the query have resolved error. This does work through JDBC and isql over ODBC with this same DSN.
syntax error at or near "\" at end of the query
For anyone else who runs into this, the code.google.com/p/odbc driver appends a null termination character to every query. This doesn't play well with vertica.
Did you manage to get the driver working at all? If so, what changes did you make?
I did manage to get it working by a quick hack to https://code.google.com/p/odbc/source/browse/odbcstmt.go - I added this to line 39:
b=b[0:len(b)-1]I didn't look into this further as to which was is per spec so I don't know where this chagne should be implemented.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
