Knowledgebase
[QODBC-ALL] Troubleshooting - Unable to execute update statement when using SQL Server 2019 linked server on Windows 11 or Windows Server 2019
Posted by Rajendra Dewani (QODBC Support) on 02 September 2022 01:46 PM

[QODBC-ALL] Troubleshooting - Unable to execute update statement when using SQL Server 2019 linked server on Windows 11 or Windows Server 2019

Issue:

We recently upgraded our Windows OS to Windows 11 and SQL Server to 2019.

We can connect from SQL Server to QODBC/QRemote.

We can execute select statements

We are experiencing an issue when updating a record. The following is the SQL statement we are using. This is working correctly in Windows 10 and SQL Server 2017.

update QRemote...Bill set Memo='Sent' where TxnID='12-1234-56789'

 

Reason:

It seems there are some changes in the standard ODBC API in Windows OS 11 or Windows Server 2019 when using SQL Server.

The issue is caused because QODBC received the following SQL statement from SQL Server.
update QODBC..Bill set Memo='Sent' where TxnID='12-1234-56789'
instead of
update QODBC.Bill set Memo='Sent' where TxnID='12-1234-56789'

 

Solution:

The issue has been identified and resolved in QODBC build 346.

Please install the latest version of QODBC.

QODBC Desktop - https://qodbc.com/download/desktop

QODBC Online - https://qodbc.com/download/online

QODBC POS - https://qodbc.com/download/pos

 

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).