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
|
|
Error Getting XML in BuildAndLoadXMLForNextRecord |
Author |
Message |
|
Posted : 2006-08-18 04:35:00 |
I'm attempting to import the Invoice table into MS SQL via the QODBC driver and the Data Transformation Services Wizard in MS SQL.
The process fails and within the QODBC Trace File (QODBCTRA.TXT) I see the following line within a lot of other things. Just wondering if support could explain what might be happening and what a resolution could be.
Error Getting XML in BuildAndLoadXMLForNextRecord
Thank you, AD |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-08-18 14:09:54 |
There are currently a number of issues concerned iterators and chunking in MS SQL Server threaded environments. The QuickBooks session is per thread and we have to restart a new session every time the MS SQL Server thread ID changes.
This has been fixed in QODBC Setup v6 Build 186 (or higher). Please install it as soon as the release is available......
QODBC Advanced Setup
The selected defaults in the Advanced settings should apply to most users and normally don't need not be changed.
- Reconnect Delay: Is an amount of time to wait after a disconnect when using the remote connector. This allows QuickBooks to fully unload it if it is being loaded in the background on the Host Remote Connector, before you connect again.
- Maximum Field Name Length: is set to the QuickBooks limitation but certain applications like Delphi can not handle this limit and must be set accordingly.
- Use Case Sensitive RefNumber Searches when checked means a refnumber of 'ABC' and 'abc' will be different, but means QuickBooks can use an index internally for a search instead of a complete table scan. (Note: this feature applies to versions of QuickBooks 2005 and higher)
- Include Raw Files if checked will display both filtered and raw data formats. QODBC formats data into SQL field types more easily used in programming languages for math and comparison operations. The Raw tables return the data as it is returned to QODBC without modification.
- Run 2.1 ODBC Compatibility is checked for certain applications that require ODBC 2.1 Compatibility to use QODBC. Anything that uses the Java ODBC library, like ColdFusion, requires this option turned on or recordsets will be returned with no rowsets or only 1 rowset.
- Simulate Transaction Support for SQL Server will turn transaction support on so that SQL Server will allow updates when using QODBC as a linked server. QODBC still does not support transactions, but simulates the turning on and off of transactions.
- The Advanced tab in QODBC Setup v6 Build 186 and later has new defaults for Use Iterators and Iterator or Chunk Size fields. This allows you to turn off iterators. This is needed on systems like MS-SQL and Web Servers that use multiple threads.
- Integrated Application Defaults Authorization popup settings. These settings are only available to USA QuickBooks 2005 and USA QuickBooks 2006 users, otherwise they are greyed out.
|
|
|
|
|
Posted : 2006-08-19 02:29:02 |
Tom your response sounds promissing, any indication when QODBC Setup v6 Build 186 (or higher) might become available? Are we talking days, weeks, months?
Thanks, Ali Daniali |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-08-19 11:01:33 |
It's only days away, but in the meantime I found another chunking problem that's got fix, so everyhting may need to be rebuilt and QC retested for a 187 release. |
|
|
|
|
Posted : 2006-08-30 03:10:03 |
Tom when will the next release be available?
It's been 10 days since you last posted a reply.
Could you please let me know when we can hope for 186 or 187?
Thanks, AD |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-08-30 08:23:19 |
Actually I believe it's already up to QODBC v6.00.00.188 internally. Unfortunately, I don't control when Build updates are pubicly released, I just get the job of testing the fixes.... but I've chased it up and they now indicate that it should be posted by the end of this week. |
|
|
|
|