Skip to main content

Vertica ODBC DSN error

  • September 21, 2018
  • 5 replies
  • 5 views
mpedroso
Forum|alt.badge.img+1

Hi guys

I'm trying to create an odbc connection with Vertical and I'm getting the following error:

"""
Connection Failed
SQLState: IM003
Native Error: 160
Error Message: Specified driver could be not be loaded due to system error 127 (Verica).
"""

Can anybody help me?

    5 replies

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • September 22, 2018

    Hi,

    Are you using Vertica's ODBC driver?

    See:
    https://www.vertica.com/client-drivers/

    mpedroso
    Forum|alt.badge.img+1
    • mpedroso
    • Author
    • Participating Frequently
    • September 24, 2018
    Yes, I am using Vertica Driver for Windows 9.1.x
    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • September 24, 2018

    What is the Vertica database version?

    mpedroso
    Forum|alt.badge.img+1
    • mpedroso
    • Author
    • Participating Frequently
    • September 25, 2018

    Community Edition 9.1.1, the driver is being installed on a server running windows 2003. The version is probably not supported.

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • September 25, 2018

    Correct. Windows Server 2003 is not supported.

    You can check which platforms for the "Vertica 9.1.x Client Drivers" are supported here:

    https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SupportedPlatforms/ClientDrivers.htm

    Note: Not even Microsoft supports Windows Server 2003!

    See:
    https://www.microsoft.com/en-us/cloud-platform/windows-server-2003

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement