The Vertica Database Forums

hi, I'm doing SELECT operation with ODBC, before I send SELECT request, I would begin a transaction to SET TIMEZONE, when start the transaction I encountered this error: begin tx failed, SQLSetConnectUIntPtrAttr: {HY000} [DSI] The error message VPropertySetFailed could not be found in the en-US locale. Check that /en-US/VerticaMessages.xml exists

I've googled for a long time and couldn't find the answer, any idea?

BTW, there are no ERROR logs in vertica.log

Have you tried using the ConnSettings property of the connect string?

See:
viewtopic.php?f=21&t=98