Vertica ODBC DSN error

mpedroso

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?

Jim_Knicely

Hi,

Are you using Vertica's ODBC driver?

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

mpedroso

Yes, I am using Vertica Driver for Windows 9.1.x

Jim_Knicely

What is the Vertica database version?

mpedroso

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

Jim_Knicely

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