Andres Luna (AndresL5)
Scotiabank Colpatria
Process Automation Engineer
Scotiabank Colpatria
AndresL5 Member since 2018 37 posts
Scotiabank Colpatria
Posted: April 13, 2020
Last activity: April 14, 2020
Posted: 13 Apr 2020 12:09 EDT
Last activity: 14 Apr 2020 12:43 EDT

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
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.