Pega Robotics Runtime ODBC error connection SQLITE
Hello everybody!
We are building a bot that uses an ODBC driver for connecting to a SQLITE3 database (Function attatched). When we debug our solution using Pega Robotics Studio 8.2025, the queries work well. However, when whe deploy the project and run it using Pega Robotics Runtime 8.2025, the following error appears:
ERROR [HY000] connect failed ERROR [IM006] [Microsoft][Administrador de controladores ODBC] Error de SQLSetConnectAttr del controlador
We made sure that all the rights and permissions were ok. However, the exception is appearing in the following line:
using (var conexion = new OdbcConnection("DRIVER=SQLite3 ODBC Driver;Database=" + pathDataBase + ";LongNames=0;Timeout=60000;NoTXN=0;SyncPragma=NORMAL; StepAPI=0;Version=3;New=True;Compress=True;"))
Do you know how we can solve the issue?
Thank you for your attention!
Pegasystems Inc.
US
Are there any ODBC drivers required to connect to the database? If those aren't installed, that may cause a failure on one machine where they don't exist versus one where they do.