The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

Invalid username when using Windows ODBC driver

I installed Vertica on a Linux box, and I'm trying to connect to it from a Windows7 machine (running a 32bits Windows), having Vertica 6 ODBC drivers. I configured the dsn through the ODBC manager and I successfully bound my Vertica database to Excel. However, when I attempt connecting to the Vertica cluster from my custom application (ran from my Windows station), Vertica complains that the username is not valid. It looks like the Vertica ODBC drivers send "O" as a password instead of the one configurer through the Windows ODBC Manager : 2013-05-02 16:55:26.788 Init Session:0x7f6d3400ca70 @v_logs_node0001: 00000/2705: Connection received: host=178.3.3.45 port=54635 (connCnt 1) 2013-05-02 16:55:26.797 Init Session:0x7f6d3400ca70 @v_logs_node0001: 28000/3782: Invalid username: "O" 2013-05-02 16:55:26.798 Init Session:0x7f6d3400ca70 @v_logs_node0001: 00000/4686: sendAuthRequest: user=O database=logs host=178.3.3.45 authType=3 2013-05-02 16:55:26.798 Init Session:0x7f6d3400ca70 @v_logs_node0001: {SessionRun} 28000/3781: Invalid username or password LOCATION: auth_failed, /scratch_a/release/vbuild/vertica/Basics/ClientAuthentication.cpp:740 My C code source connects as follow : ret = SQLConnect ( m_hdlDbc, (SQLCHAR*)m_dsnname.c_str(), SQL_NTS,(SQLCHAR*)"",SQL_NTS, (SQLCHAR*)"", SQL_NTS); if(!SQL_SUCCEEDED(ret)) { Logger::logError ( "DBConnector::connectDB(): Connection problem to dsn:" + m_dsnname ); reportError(SQL_HANDLE_DBC, m_hdlDbc); return ( -1 ); } This works properly with unixODBC, but not with the Windows drivers. Any idea ? Thank you !

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.