AndresL5 Member since 2018 34 posts
Scotiabank Colpatria
Posted: 6 months ago
Last activity: 6 months 2 weeks ago

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!

Pega Robotic Process Automation 8.0 Robotic Process Automation Financial Services Robotics System Architect
Share this page LinkedIn