· Jun 20, 2023

[unixODBC][Iris ODBC][State : S1000][Native Code 417]

When connectiong to IRIS from UBUNTU LTS 18.04, I  got this error message:

ErrorException: odbc_connect(): SQL error: [unixODBC][Iris ODBC][State : S1000][Native Code 417]


Access Denied, SQL state S1000 in SQLConnect 


I'm using "ODBC-2022." downloaded from


and folowing guide from


Here's my odbc.ini

[ODBC Data Sources]
TrakCare= TrakCare

Driver          = /usr/lib/intersystems/odbc/bin/
Description     = IRIS ODBC driver
Host            =
Namespace       = TC-TRAK
UID             = USERNAME
Password        = PASSWORD
Port            = 51773
Protocol        = TCP
Query Timeout   = 1
Static Cursors  = 0
Trace           = off
TraceFile       = iodbctrace.log
Authentication Method   = 0
Security Level  = 2
Service Principal Name = iris/

And here's error logs from Management Portal

Namespace: %SYS
Process: 3464921

2023-06-20 13:20:09 [SQLCODE: <-417>:<Security Error>] [Location: <AuthenticationError>] [Client info: <Username: www-data, Node Name: servername, IP Address:, Executable Name:, Internal Function: CN>] [%protocol: <63>]


I'm using PHP and username & password are valid

Does anyone is familier with this problem?

Product version: IRIS 2021.1
$ZV: IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2021.1 (Build 215_0_21953U)
Discussion (0)1
Log in or sign up to continue