Invite a Co-worker

RoyL · ‎2020-02-05

Hi HowardF, This was the trick! Thanks for your solution!

RoyL · ‎2020-02-05

Hi BevanWeiss, Thanks for your recommendation!

RoyL · ‎2020-02-05

OS: Windows Server 2016 (64bit) ClearScada: CS2017 R3 ODBC DSN: 64bit When I run the query in an eventwindow or mimic script I get the data (no error), when I try to execute a ST Logic with the same query I get the error

RoyL · ‎2020-02-05

When I execute a ST Logic with a sql query to a linked odbc table with a 64bit driver, I get the following program error: QP Error - Cannot suspend Database Write Lock lock while caching the results of SQL queries for OnUpdate execution How can I fix this error?

Online Status	Offline
Date Last Visited	yesterday

Invite a Co-worker

Invitation Sent

About RoyL

Re: Is it possible to use a sql query in ST Logic to access data in linked odbc table with 64bit driver?

Re: Is it possible to use a sql query in ST Logic to access data in linked odbc table with 64bit driver?

Re: Is it possible to use a sql query in ST Logic to access data in linked odbc table with 64bit driver?

Is it possible to use a sql query in ST Logic to access data in linked odbc table with 64bit driver?

Support

FAQ

About

Invite a Co-worker

Invitation Sent

About RoyL

Re: Is it possible to use a sql query in ST Logic to access data in linked odbc table with 64bit driver?

Re: Is it possible to use a sql query in ST Logic to access data in linked odbc table with 64bit driver?

Re: Is it possible to use a sql query in ST Logic to access data in linked odbc table with 64bit driver?

Is it possible to use a sql query in ST Logic to access data in linked odbc table with 64bit driver?

Support

FAQ

About

Starting your topic is just steps away!

Connect with Peers & Experts

Get Support in Our Knowledge Base

Ask Questions. Give Solutions