0
2398

Written by

Zaheer Uddin
Follow
Question Zaheer Uddin · Dec 18, 2018

Unable to connect using InterSystems ODBC in PHP, access denied

#Caché #ODBC

I am unable to connect to InterSystems ODBC client. I am seeing the following error:

[Cache ODBC][State : S1000][Native Code 417] Access denied.

$cnx = new PDO("odbc:Driver={InterSystems ODBC};Server=<IP>;Uid=<id>;Pwd=<password>;");

Am i doing anything wrong?

Although, I can successfully connect and retrieve data in MS Excel using ODBC connection where I have configured my DSN and all

Discussion (2)0
Log in or sign up to continue

Comments

Eduard Lebedyuk · Dec 19, 2018

If you're using InterSystems IRIS try this connection string (replacing values with appropriate):

"Driver=InterSystems ODBC Driver;Host=127.0.0.1;Port=56772;Database=USER;UID=myUsername;PWD="

and for Caché/Ensemble try (driver name could be InterSystems ODBC):

"Driver=Cache ODBC Driver;Host=127.0.0.1;Port=1972;Database=USER;UID=myUsername;PWD="

If the problem persist, check Audit log.

0
Heru.H · Jun 20, 2023

i got the same error message, have you solved the problem?

0