Knowledgebase: TroubleShooting
[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 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 the query is executed you will have to wait for 30-45 seconds, if there is no activity on the linked server connection SQL Server will automatically send the disconnect command.

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