Troubleshooting - Application Connectivity Delay
I have an inventory control system (c#, SQL Server) that needs Read Only access to four tables in the accounting system. I have deployed your multiuser version and can access the local QB instance from your VB app, Excel, and my app.
1. When I run your VB app in the production RDP session, the ODBC behavior is as expected.
2. I created a WPF/c# app to duplicate your VB and ran it in the production RDP session. The ODBC its behavior is expected.
3. When I run my app in my development environment, the ODBC behavior is as expected.
4. When I run my app in the production RDP session, opening the ODBC connection takes > 6 minutes. But it opens.
Please let me know what I am doing wrong.
Please reset your Optimizer file, check the connection time, and log the connection time in your application. Please refer:
How to Remove Optimizer file
Please try the below .net application for the troubleshooting time delay in connection opening and querying:
Sample code for Troubleshooting Connection Time Issue
If the above does not resolve the issue, please change the application, as it could eat more environmental resources.
Also, please try to move the process of reading the QuickBooks tables to a background task. It will solve the problem. I suspect that your app is consuming most of the thread pool. Creating an explicit task provides sufficient resources to resolve the issue.