|
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
|
|
| Not working with Australian version |
| Author |
Message |
|
|
| Posted : 2006-08-03 08:13:38 |
I installed QODBC on a Windows Server 2003, and attempted to use it with an Australian Quickbooks 2006/07, Multi-user, on the same machine. It connects, and using VB Demo 32, I can retrieve information from every table I try except Customer.
This is what's in the log file:
20060803.030453 I 2176 RequestProcessor ========= Started Connection =========
20060803.030453 I 2176 RequestProcessor Connection opened by app named 'FLEXquarters QODBC'
20060803.030453 I 2176 CertVerifier The file does not contain an Authenticode signature.
20060803.030453 I 2176 RequestProcessor Opening the file in the DoNotCare mode.
20060803.030453 I 3856 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 2176).
20060803.030453 I 3856 SpecVersion Current version of qbXML in use: AU3.0
20060803.030453 I 3856 QBSDKMsgSetHandler QUERY: Host
20060803.030453 I 3856 QBSDKMsgSetHandler Request 1 completed successfully.
20060803.030453 I 3856 QBSDKMsgSetHandler QUERY: Company
20060803.030453 I 3856 QBSDKMsgSetHandler Request 2 completed successfully.
20060803.030453 I 3856 QBSDKMsgSetHandler QUERY: DataExtension Definition
20060803.030453 I 3856 QBSDKMsgSetHandler Request 3 completed successfully.
20060803.030453 I 3856 MsgSetHandler Finished.
20060803.030453 I 3856 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 2176), ret = 0.
20060803.030457 I 3856 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 2176).
20060803.030457 I 3856 SpecVersion Current version of qbXML in use: AU3.0
20060803.030457 I 3856 QBSDKMsgSetHandler QUERY: Customer Job
20060803.030457 I 3856 CustomerStorage::DoQuery Returning no more than 00001000 customers
20060803.030459 E 3856 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE QUERY REQUEST ***. This is an indication of a possible internal QBXML error.
20060803.030459 I 3856 QBSDKMsgSetHandler Request 1 failed.
20060803.030459 I 3856 MsgSetHandler Finished.
I uninstalled, and reinstalled. I downloaded the most recent version from your web-site. No go. It just doesn't return any records when I try "SELECT * FROM Customer". I did choose Australia when installing QODBC.
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-08-03 12:40:47 |
| It appears there's internal corruption in your QuickBooks Company file. Try using another company file. |
|
|
|
|
|
| Posted : 2006-10-24 04:28:10 |
The Company file was fine when using Quickbooks Premiere 2004 (Australian). My customer upgraded to 2006/2007, and now it won't read the Customer table. I tried a Rebuild. It still doesn't work. I tried a new Company file, and it does work.
How do I get this to work? Why is the Company file corrupted under 2006/2007, but not under 2004? Is there a way to get the data (including transactions) out of the old company file and into a new one?
|
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-10-24 11:47:15 |
| Sorry, the company file appears to be corrupted internally, you will need to restore a previous backup. The Australian qbXML v3.0 SDK has a bug that causes internal corruption to a company file when too many Customer fields are attempted to be processed at the one time in an INSERT or UPDATE operation. |
|
|
|
|
|
| Posted : 2006-10-25 01:32:02 |
Again, why is it corrupt using 2006/2007 and not when using 2004? No INSERTS or UPDATES have been performed. We just upgraded the program. The first thing I did was query the Customer table, and it didn't work. I tried Verify and Rebuild. Everything works within Quickbooks, including the Customers. It's just the SDK that has a problem.
More importantly, is there any way to extract the data from the Company file and into a new one? Perhaps some tool?
|
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-10-25 08:45:10 |
| Sorry, I suggest you convert the original 2004 company file to 2006/07 format again. From there your client should contact Quicken in Australia directly for support on file corruption or data transfer. |
|
|
|
|