How to supress Busy Optimizing Message |
Author |
Message |
|
Posted : 2007-03-09 22:04:27 |
When adding or updating multiple records using MFC Application, I noticed QuickBooks Displays a message as follows:
Busy optimizing. Please wait
Table Name
rec#
Can I supress this message from appearing as I am writing a service to update the recrods in background.
|
|
|
Mumtaz Kazmi
Senior System Architect
Advanced Computer Systems Limited
145 Gihon Spring Drive
Rexdale, ON
Canada |
| Top | |
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-03-09 23:31:20 |
Simply uncheck the "Display Optimizer Status Panel" option.
|
|
|
|
|
Posted : 2007-03-10 02:43:57 |
Okay Thanks!
But is there a way of doing it programatically or by passing a switch to qodbc.exe setup file like we do for quite isntallation as qodbc /q.
Because I need to uncheck it automatically on client's machine during my setup program.
Mumtaz |
|
|
Mumtaz Kazmi
Senior System Architect
Advanced Computer Systems Limited
145 Gihon Spring Drive
Rexdale, ON
Canada |
| Top | |
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-03-10 09:40:36 |
Not a good idea, especially on new sites where it may take a while to optimize the table(s). Without the dialog users will think QODBC is stuck. |
|
|
|
|
Posted : 2007-03-10 20:31:26 |
Thanks for the suggestion!
Its not a good Idea for a Windows NT Service to pop Information messages as we are writing a Database synchronization server for our FoxPro Data and Quickbooks that will run as a background server and will do hidden record sync.
So in our case a user might be typing in MS Word or sending e-mail for instance and would not like optimizer messag
e to appear.
Can you please tell me where the ODBC Setup Dialog of QODBC stores its values? I checked in the Windows registry but could not get a complete list for every tab.
Mumtaz
|
|
|
Mumtaz Kazmi
Senior System Architect
Advanced Computer Systems Limited
145 Gihon Spring Drive
Rexdale, ON
Canada |
| Top | |
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-03-11 14:31:41 |
Ok, you simply just need to add a "OptimizerPanel=No" line to the odbcinst.ini file in the:
C:\Documents and Settings\All Users\Application Data\QODBC Driver for QuickBooks
folder of the installed machine under the: [QODBC Driver for QuickBooks (32 bit)] label like this:
[QODBC Driver for QuickBooks (32 bit)] Driver=C:\WINDOWS\system32\fqqb32.dll Setup=C:\WINDOWS\system32\fqqb32.dll 32Bit=1 OptimizerPanel=No |
|
|
|
|
Posted : 2007-05-08 02:58:28 |
thanks, i was looking for that answer
german |
|
|
|