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 : Remote data access and Invoice Creation (very slow)Search Forum

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

 New Topic 
 
 Post Reply 
[1]  
 Remote data access and Invoice Creation (very slow) 
 Author   Message 
  BrianC 
  
 Group: Members 
 Posts: 1 
 Joined: 2009-02-11 
 Profile
 Posted : 2009-02-11 02:59:37

 

      1.   Using Remote data access with two servers:

             one server is running QB 8.0 R6P  &  QB Remote Data Sharing Server v7.0.0.121

             the other is running SQL Server 2005 & QODBC Driver v9.0.0.253  &  QB Remote Data Sharing Client v7.0.0.121

      2.   The select queries work correctly and quickly EX: SELECT * FROM OPENQUERY(QODBC, 'SELECT * FROM Customer' takes only a few seconds to run

    3. Invoice creation using multiple line invoices has yet to complete correctly (1+hours)

EX:

INSERT OPENQUERY(QODBC, 'SELECT "InvoiceLineItemRefFullName", "InvoiceLineQuantity", "FQSaveToCache"

FROM InvoiceLine WHERE 1=0') VALUES ( @InvoiceLineItemRef, @InvoiceLineQuantity, 1)

 

INSERT OPENQUERY(QODBC, 'SELECT "InvoiceLineQuantity", "InvoiceLineDesc", "FQSaveToCache"

FROM InvoiceLine WHERE 1=0') VALUES (NULL, 'JobNumber(s):', 1)

 

INSERT OPENQUERY(QODBC, 'SELECT "CustomerRefFullName", "TermsREFFullName", "PONumber", "IsToBePrinted", "IsToBeEMailed", "ItemSalesTaxRefFullName", "InvoiceLineQuantity", "InvoiceLineDesc"

FROM InvoiceLine WHERE 1=0') VALUES (@CustomerRef, @TermsRef , @PONumber, @IsPrinted, @IsEMailed , @SalesTaxRef, NULL, @InvoiceLineDesc)

 

I set this up initially using only one server with both QODBC and QB running; using the same exact query the invoice creation takes a little over 15 seconds with multiple lines;  I still can not get this to complete the creation of an invoice using the setup with Remote data access and QB running on one server and SQL on another; but the select queries work very well.

   What do I need to do to have this work?   Does Remote data sharing support invoice creation? 

 Thanks in advance.

 

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-02-11 11:10:17
I can see QODBC having all sorts of trouble trying to work with all the remote threading happening here. Most likely the Plan B method shown in: Using ClassRefListID when inserting invoice lines will work better as it adds lines to invoices instead of trying to cache mutliple inserts. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to