1. Using Remote data access with two servers:
one server is running QB 8.0 R6P & QB Remote Data Sharing Server v22.214.171.124
the other is running SQL Server 2005 & QODBC Driver v126.96.36.199 & QB Remote Data Sharing Client v188.8.131.52
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)
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.