Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
Flagging for weekend review. Thanks for the bump.
Persistent ODBC Connection to SQL Server
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I have an mdb application which uses a DSN-less connection to link to tables in SQL Server 2016. The app has been getting more and more frequent hangs. Looking at the server logs, it shows that every time the app needs to access data on the server it is logging on again and not maintaining a persistent connection.
I did some searching, and I cannot find a switch with the ODBC to make it a persistent connection. I am using NCLI11 with the ODBC. I have tried opening a hidden bound table as was suggested by some sites but that did not seem to have any effect.
As it is currently, each user is registering logon events thousands of times a day. How can I create the persistent connection to the back-end SQL database so Access will hold that connection open?
Microsoft 365 and Office | Access | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
6 answers
Sort by: Most helpful
-
Anonymous
2018-01-04T09:52:34+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator2018-01-04T04:39:46+00:00 Flagging for weekend review. Thanks for the bump.
-
Anonymous
2018-01-03T16:37:56+00:00 Bumping thread.
-
Anonymous
2017-12-13T23:31:27+00:00 Server is on-prem, connection is utilizing windows authentication with an active directory domain.
I am seeing the logon events by opening SSMS, going to Management, SQL Server Logs, and looking at the logs. For yesterday (12-12-2017) it recorded 397,291 logon events.
-
Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
2017-12-13T02:47:52+00:00 I'm interested in this issue.
> Looking at the server logs
Can you please be more explicit? Where are you seeing many logon events?
Also:
* Is this using SQL Server on-prem?
* Windows Authentication or SQL Server Authentication?