I have created a linked server to ODBC Data source.
It works well. When I query SQL Server Linked server sends connect odbc call and executes the queries.
If I wait for 1 minutes with no activity the connection is closed automatically.
Is there a way to Disconnect Linked Server connection - Not delete and re-add. I would like to do similar to what we do in any programming language i.e
cn.Disconnect() - To send the disconnect command to the DNS data source.