Published on InterSystems Developer Community (https://community.intersystems.com)

Home > MSSQL ODBC Connection Error (NativeError: [11001] )

Question
Rodolfo Moreira · Jan 10, 2020

MSSQL ODBC Connection Error (NativeError: [11001] )

Hello, I need to use IRIS to connect to an MSSQL base.
It has to be done via ODBC, I can't use JDBC at this time by client option.

I am trying to use Microsoft Driver
libmsodbcsql-13.1.so.9.2

But I can't, my attempts result in:
Connection failed.
SQLState: () NativeError: [11001] Message:

I have done all DSN configuration, and my configuration is listed in SQL Gateway Connections. I know it's working, because when I run a test with isql I have the information that connects to the bank.

This is my IRIS and Server configuration:
IRIS for UNIX (Ubuntu Server LTS for x86-64) 2018.1.1 (Build 643U)

#ODBC #SQL #InterSystems IRIS

Source URL:https://community.intersystems.com/post/mssql-odbc-connection-error-nativeerror-11001