ODBC Connection - Receiving SQL Errors
I have established an ODBC connection with our client based on credentials they provided. The test connection was successful and after using the Link Table wizard I can now see the client's tables and properties. However when we try to execute a query in IRIS we are getting error code -226. I'm trying to determine if this could be just a simple setting problem in IRIS or something with the client.
We have tried with PostgreSQL as well as with TSQL. Same result for each.
Has anyone seen this error before and could it be pointing me in a certain direction? Documentation on the error is sparse at best.
Five Points Technology Group