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
|
|
Message: database disk image is malformed, optimizer setting will not stay at "end of yesterday" |
Author |
Message |
andy |
|
Group | : Members |
Posts | : 3 |
Joined | : 2006-05-16 |
|
Profile |
|
Posted : 2006-05-16 03:28:33 |
Using QB enterprise ver 6, 10 users via MS terminal services/remote desktop. Our QB file is approx. 700 meg. Installed QBODBC last night, used the "reload all data" in the optimizer. It created the optimized file in the proper directory. I then opened up QB in administrator and did a query in Excel, configured it as per instructions. I did a search of customers and it took about 15 minutes. I thought this was a little long so then tried to configure the optimizer to keep the data up to date as of the "end of yesterday", hit apply and closed the window. I did another querry and still took 15 minutes. When I opened up the utility to configure QBODBC for optimization it had switched back to "the start of every query". I changed it again and the same results. I checked the "review QBODC messages" and I was getting this error everytime I did a query
2006-05-15 09:43:39 QODBC Ver: 6.00.00.147 IsAService: False SQLOptimize_OpenOptimizeDBHandle prepare: SELECT "type", "tbl_name" FROM "SQLite_MASTER" database disk image is malformed.
Is a 15 minute querry normal? or is somthing going on with tthe way it is installed? I also tried an Access query, same results. Excel and Access are on the same server as QB, and accesed through terminal services. I tried it directly on the "terminal services" server wth the same result. The operating system is Windows Server 2003 standard edition, on a Dell Server PE700, Pentium 4, 320 GHz. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-16 08:13:35 |
|
|
|
andy |
|
Group | : Members |
Posts | : 3 |
Joined | : 2006-05-16 |
|
Profile |
|
Posted : 2006-05-17 05:42:23 |
Tom,
I did as you instructed and updated QODBC, reset the optimizer file as per your instructions , but I'm still getting the same problem happening. It worked good for a couple of small vendor related querys but then.....
I'm trying to configure the optimizer to keep the data up to date as of the "end of yesterday", but It switches back to "the start of every query". After doing a query I now get this error message in the "review QBODC messages" log.
2006-05-16 12:27:05 QODBC Ver: 6.00.00.155 IsAService: False SQLOptimize_OpenOptimizeDBHandle prepare: SELECT "type", "tbl_name" FROM "SQLite_MASTER" database disk image is malformed.
Any other Ideas? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-17 10:04:35 |
You are most likely using MS Access. MS Access retains the original connection settings when you first link tables. So regardless of the optimizer settings you setup afterwards, MS Access will override them with the values it keep. You need to re-link the tables.
The QODBC Optimizer also operates in single user only, you cannot have multiple users on a network or server use the same opt file. |
|
|
|
andy |
|
Group | : Members |
Posts | : 3 |
Joined | : 2006-05-16 |
|
Profile |
|
Posted : 2006-05-19 07:26:27 |
Can you create seperate optimization files for different users? Otherwise it defeats the purpose of having a multiuser enviroment for Quick Books |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-19 09:13:46 |
The opt file by default is on the local drive on each users workstation on a network. As QODBC doesn't support Terminal Services, Terminal Services will move the QODBC install to your "c:\documents and settings\username\program files\qodbc driver for quickbooks" username local folder.
For other Terminal Server users, you will also need to run through the QODBC.exe install procedure to install local files to their program area too! This will also mean that each user will also have their own (unique) Optimizer Database Folder and each user will have their own QODBC error logs etc.
|
|
|
|
|