Unable to connect using InterSystems ODBC in PHP, access denied
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