[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]
[libirisodbcur6435.so]
Access Denied, SQL state S1000 in SQLConnect
I'm using "ODBC-2022.1.0.209.0-lnxubuntu1804x64.tar.gz" downloaded from
"https://github.com/intersystems-community/iris-driver-distribution/tree/..."
and folowing guide from
https://community.intersystems.com/post/intersystems-iris-laravel-odbc
Here's my odbc.ini
[ODBC Data Sources]
TrakCare= TrakCare
[TrakCare]
Driver = /usr/lib/intersystems/odbc/bin/libirisodbcur6435.so
Description = IRIS ODBC driver
Host = 1.1.1.1
Namespace = 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/localhost.domain.com
And here's error logs from Management Portal
Namespace: %SYS
Process: 3464921
Error:
2023-06-20 13:20:09 [SQLCODE: <-417>:<Security Error>] [Location: <AuthenticationError>] [Client info: <Username: www-data, Node Name: servername, IP Address: 127.0.1.1, Executable Name: libirisodbcur6435.so, Internal Function: CN>] [%protocol: <63>]
I'm using PHP and username & password are valid
Does anyone is familier with this problem?
For those who are getting an "access denied" error, they need to run "odbcinst -i -s -l -f odbc.ini_unixODBCtemplate."