Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Cannot close QuickBooks after using of the QODBC driver.Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v7 Forum

 New Topic 
 
 Post Reply 
[1]  
 Cannot close QuickBooks after using of the QODBC driver. 
 Author   Message 
  Yuri 
  
 Group: Members 
 Posts: 3 
 Joined: 2007-06-27 
 Profile
 Posted : 2007-11-28 18:19:51

We have developed the application which import and export some data in QuickBooks using QODBC driver.

But QuickBooks cannot be closed after the using of QODBC driver.

Our application was developed using Delphi7 and ADO controls.
QuickBooks version is “QuickBooks Enterprise 7.0”
QODBC driver version is “QODBC Desktop Read Write 2007 Version 7.00.00.214” (Licensed)
QODBC driver is configured to use the company file that’s now opened in QuickBooks

I have created the simple application using Delphi (ADOConnection and ADOQuery on the form). The same behavior is reproduced with that application. I do the following: open connection (ADOConnection.Connected:=True), open query (ADOQuery.Open), close query (ADOQuery.Close), close connection (ADOConnection.Connected:=False), !!! wait several minutes!!!, do the same things (open connection and query, close query and connection), after that close test application and try to close QuickBooks. As the result we cannot close QuickBooks. If we do not do !!! wait several minutes!!! then QuickBooks closes after closing the test application.

I can send the test application and QODBC logs if it is required.

Please help.
Do we something wrong?
Can we (somehow) force to close QuickBooks?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-11-29 06:50:30

Try closing the Delphi7 test application and check the behaviour using VB Demo. If you sent an invalid query to QODBC, it's also possible to leave a broken connection in memory that won't let you close QuickBooks. See: I'm getting the error message "Cannot close company file" for more information. 

See also: Ado Item Query returns EOF in Delphi when wrong Cursor type is used 

 

  Top 
  Dan 
  
 Group: Members 
 Posts: 1 
 Joined: 2008-10-14 
 Profile
 Posted : 2008-10-16 06:19:43
I am having the same problem... Not with Delphi but using VS 2005. I believe this is some sort of authority problem. I have discovered that if I'm logged on as administrator to the machine, I don't have this problem. I don't have to be logged into Quickbooks as an administrator.  

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to