Skip to main content

Error connecting to Vertica from Cognos

David_Santos_Va
Hi, I have IBM Cognos BI 10.1.1 64-bit installed in a Windows Server 2008 R2 machine and when trying to connect to the Vertica server by "C:\Windows\SysWOW64\odbcad32.exe", it returns the following error: "The setup routines for the Vertica ODBC Driver could not be loaded due to system error code 14001: The application failed to start because side-by-side configurantion is incorrect. Please see the aplication event log or use the command-line sxstrace.exe tool for more detail.(C:\Program Files\Vertica\Systems\lib\vertica_6.0_odbc_3.5.dll)." When connected by "C:\Windows\System32\odbcad32.exe" operates normally, but, the Cognos uses the driver 64 bits.

    2 replies

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • April 29, 2013
    Hi David Sorry for the trouble. It sounds like the ODBC installer failed to install some 32-bit dependencies on your system. I think you can fix this by installing the Microsoft 32-bit Visual C++ 2008 SP1 redistributable package. You can download it here: http://www.microsoft.com/en-us/download/details.aspx?id=5582 After installing, both the 32-bit and 64-bit versions of the ODBC Administration dialog should work properly. Tom
    David_Santos_Va
    Thank you, Worked properly! Note: “C:\Program Files\Vertica Systems\JDBC\vertica-jdk5-6.0.1-0.jar" to "Program Files\ibm\cognos\c10_64\webapps\p2pd\WEB-INF\lib"
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement