Knowledgebase: Data & Table
[QODBC-Desktop] Troubleshooting - How to close SQL Linked Server connection
Posted by Jack - QODBC Support on 13 July 2016 02:35 PM

Troubleshooting - How to close SQL Linked Server connection

Problem Description:

We are using QRemote with SQL Linked Servers with several different QuickBooks files. How can we close the connection to a QuickBooks file after the query has run, then open it to connect to another database?  

Solution:

SQL Server Linked Server automatically handles disconnect.

SQL Server Linked Server does not have a disconnection command which can be fired/executed.

After executing the query, you will have to wait 30-45 seconds. SQL Server will automatically send the disconnect command if there is no activity on the linked server connection.

(5 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).