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 : Many Remote Connector connections for a single querySearch Forum

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

 New Topic 
 
 Post Reply 
[1]  
 Many Remote Connector connections for a single query 
 Author   Message 
  Mike 
  
 Group: Members 
 Posts: 13 
 Joined: 2007-05-31 
 Profile
 Posted : 2007-05-31 05:05:16

 Hello,

I am evaluating QODBC to use with our QuickBooks Enterprise server.  I plan to use the Remote Connector with the server edition to access QuickBooks from Crystal Reports under Visual Studio 2005.   As a prototype, I have written a simple report against the Invoice table using one of the sample databases provided with QuickBooks.

Using the Remote Connector, the report runs on a server that has QODBC, but not QuickBooks.   I have performed a "Reload All Data" with the Optimizer on the Crystal side and left the keep up-to-date option as "Start of every query".

The report runs fine but it is slow (about 45 seconds to complete).  The sample Invoice table has a total of 150 records of which 33 are found for inclusion in my report ( ... were IsPaid=0).   Looking at the Remote Connector log, I see a lot of disconnect and reconnections.   I would like to know if this is normal and if there are any changes I should make to the settings to reduce the number of reconnections.   I am relying on Crystal to connect to the ODBC source, so please let me know of any Crystal-specific changes that might improve this behavior.  I am concerned that the slow performance will mean we cannot deploy QODBC to be used from our Intranet web site.  I also realize that the first 20 seconds are probably the time is takes QuickBooks to auto-login.  The QB server is running unattended so the QODBC configuration is set up to allow it to connect to QB as needed.

Thanks,

_Mike

Information from Remote Connector log:

[5/30/2007 2:22:45 PM] IBizQB Remote Connector Started.
[5/30/2007 2:23:15 PM - 172.22.11.56] Client has connected.
[5/30/2007 2:23:15 PM - 172.22.11.56]
Received from client: <?xml version="1.0"?><?qbxml version="3.0"?><QBXML><QBXMLMsgsRq onError="continueOnError"><HostQueryRq/></QBXMLMsgsRq></QBXML>[5/30/2007 2:23:35 PM - 172.22.11.56]
Response from QuickBooks:
[5/30/2007 2:23:35 PM - 172.22.11.56]
<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<HostQueryRs statusCode="0" statusSeverity="Info" statusMessage="Status OK">
<HostRet>
<ProductName>QuickBooks Enterprise Solutions: Professional Services Edition 7.0</ProductName>
<MajorVersion>17</MajorVersion>
<MinorVersion>0</MinorVersion>
<Country>US</Country>
<SupportedQBXMLVersion>1.0</SupportedQBXMLVersion>
<SupportedQBXMLVersion>1.1</SupportedQBXMLVersion>
<SupportedQBXMLVersion>2.0</SupportedQBXMLVersion>
<SupportedQBXMLVersion>2.1</SupportedQBXMLVersion>
<SupportedQBXMLVersion>3.0</SupportedQBXMLVersion>
<SupportedQBXMLVersion>4.0</SupportedQBXMLVersion>
<SupportedQBXMLVersion>4.1</SupportedQBXMLVersion>
<SupportedQBXMLVersion>5.0</SupportedQBXMLVersion>
<SupportedQBXMLVersion>6.0</SupportedQBXMLVersion>
<IsAutomaticLogin>true</IsAutomaticLogin>
<QBFileMode>MultiUser</QBFileMode>
</HostRet>
</HostQueryRs>
</QBXMLMsgsRs>
</QBXML>
[5/30/2007 2:23:35 PM - 172.22.11.56]

[5/30/2007 2:23:35 PM - 172.22.11.56] Client has disconnected.
[5/30/2007 2:23:35 PM - 172.22.11.56] Client has connected.
[5/30/2007 2:23:35 PM - 172.22.11.56]
Received from client: .[5/30/2007 2:23:51 PM] Opened persistent connection to QuickBooks.
[5/30/2007 2:23:51 PM - 172.22.11.56] Client has disconnected.
[5/30/2007 2:23:51 PM - 172.22.11.56] Client has connected.
[5/30/2007 2:23:51 PM - 172.22.11.56]
Received from client: x[5/30/2007 2:23:51 PM - 172.22.11.56]
Response from QuickBooks:
[5/30/2007 2:23:51 PM - 172.22.11.56]
C:\Documents and Settings\mikel5\My Documents\QBData\sample business.qbw[5/30/2007 2:23:51 PM - 172.22.11.56]

[5/30/2007 2:23:51 PM - 172.22.11.56] Client has disconnected.
[5/30/2007 2:23:51 PM - 172.22.11.56] Client has connected.
[5/30/2007 2:23:51 PM - 172.22.11.56]
Received from client: <?xml version="1.0"?>
<!DOCTYPE QBXML PUBLIC '-//INTUIT//DTD QBXML QBD 1.0//EN' "http://developer.intuit.com">
<QBXML>
 <QBXMLMsgsRq onError="continueOnError">
  <HostQueryRq requestID="1"></HostQueryRq>
 </QBXMLMsgsRq>
</QBXML>[5/30/2007 2:23:52 PM - 172.22.11.56]
Response from QuickBooks:
[5/30/2007 2:23:52 PM - 172.22.11.56]
<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<HostQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK">
<HostRet>
<ProductName>belprofessional</ProductName>
<MajorVersion>17</MajorVersion>
<MinorVersion>0</MinorVersion>
<SupportedQBXMLVersion>1.0</SupportedQBXMLVersion>
<SupportedQBXMLVersion>1.1</SupportedQBXMLVersion>
<SupportedQBXMLVersion>2.0</SupportedQBXMLVersion>
<SupportedQBXMLVersion>2.1</SupportedQBXMLVersion>
<SupportedQBXMLVersion>3.0</SupportedQBXMLVersion>
<SupportedQBXMLVersion>4.0</SupportedQBXMLVersion>
<SupportedQBXMLVersion>4.1</SupportedQBXMLVersion>
<SupportedQBXMLVersion>5.0</SupportedQBXMLVersion>
<SupportedQBXMLVersion>6.0</SupportedQBXMLVersion>
</HostRet>
</HostQueryRs>
</QBXMLMsgsRs>
</QBXML>
[5/30/2007 2:23:52 PM - 172.22.11.56]

[5/30/2007 2:23:52 PM - 172.22.11.56] Client has disconnected.
[5/30/2007 2:23:52 PM - 172.22.11.56] Client has connected.
[5/30/2007 2:23:52 PM - 172.22.11.56]
Received from client: <?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="6.0"?>
<QBXML>
 <QBXMLMsgsRq onError="continueOnError">
  <CompanyQueryRq requestID="1">
   <IncludeRetElement>IsSampleCompany</IncludeRetElement>
  </CompanyQueryRq>
 </QBXMLMsgsRq>
</QBXML>[5/30/2007 2:23:53 PM - 172.22.11.56]
Response from QuickBooks:
[5/30/2007 2:23:53 PM - 172.22.11.56]
<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<CompanyQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK">
<CompanyRet>
<IsSampleCompany>true</IsSampleCompany>
</CompanyRet>
</CompanyQueryRs>
</QBXMLMsgsRs>
</QBXML>
[5/30/2007 2:23:53 PM - 172.22.11.56]

[5/30/2007 2:23:53 PM - 172.22.11.56] Client has disconnected.
[5/30/2007 2:23:53 PM - 172.22.11.56] Client has connected.
[5/30/2007 2:23:53 PM - 172.22.11.56]
Received from client: <?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="6.0"?>
<QBXML>
 <QBXMLMsgsRq onError="continueOnError">
  <DataExtDefQueryRq requestID="1">
   <OwnerID>0</OwnerID>
  </DataExtDefQueryRq>
 </QBXMLMsgsRq>
</QBXML>[5/30/2007 2:23:54 PM - 172.22.11.56]
Response from QuickBooks:
[5/30/2007 2:23:54 PM - 172.22.11.56]
<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<DataExtDefQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK">
<DataExtDefRet>
<OwnerID>0</OwnerID>
<DataExtName>Birthday</DataExtName>
<DataExtType>STR255TYPE</DataExtType>
<AssignToObject>Customer</AssignToObject>
<AssignToObject>Employee</AssignToObject>
</DataExtDefRet>
<DataExtDefRet>
<OwnerID>0</OwnerID>
<DataExtName>Color</DataExtName>
<DataExtType>STR255TYPE</DataExtType>
<AssignToObject>Item</AssignToObject>
</DataExtDefRet>
<DataExtDefRet>
<OwnerID>0</OwnerID>
<DataExtName>Date of last raise</DataExtName>
<DataExtType>STR255TYPE</DataExtType>
<AssignToObject>Employee</AssignToObject>
</DataExtDefRet>
<DataExtDefRet>
<OwnerID>0</OwnerID>
<DataExtName>Discount Available</DataExtName>
<DataExtType>STR255TYPE</DataExtType>
<AssignToObject>Vendor</AssignToObject>
</DataExtDefRet>
<DataExtDefRet>
<OwnerID>0</OwnerID>
<DataExtName>Material</DataExtName>
<DataExtType>STR255TYPE</DataExtType>
<AssignToObject>Item</AssignToObject>
</DataExtDefRet>
<DataExtDefRet>
<OwnerID>0</OwnerID>
<DataExtName>Spouse&apos;s Name</DataExtName>
<DataExtType>STR255TYPE</DataExtType>
<AssignToObject>Customer</AssignToObject>
<AssignToObject>Employee</AssignToObject>
</DataExtDefRet>
<DataExtDefRet>
<OwnerID>0</OwnerID>
<DataExtName>Web URL</DataExtName>
<DataExtType>STR255TYPE</DataExtType>
<AssignToObject>Customer</AssignToObject>
<AssignToObject>Vendor</AssignToObject>
</DataExtDefRet>
</DataExtDefQueryRs>
</QBXMLMsgsRs>
</QBXML>
[5/30/2007 2:23:54 PM - 172.22.11.56]

[5/30/2007 2:23:54 PM - 172.22.11.56] Client has disconnected.
[5/30/2007 2:23:54 PM - 172.22.11.56] Client has connected.
[5/30/2007 2:23:54 PM - 172.22.11.56]
Received from client: <?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="6.0"?>
<QBXML>
 <QBXMLMsgsRq onError="continueOnError">
  <InvoiceQueryRq requestID="1" iterator="Start">
    <MaxReturned>00000500</MaxReturned>
 <PaidStatus>NotPaidOnly</PaidStatus>
   <IncludeLineItems>0</IncludeLineItems>
   <IncludeLinkedTxns>0</IncludeLinkedTxns>
   <IncludeRetElement>TxnID</IncludeRetElement>
 <IncludeRetElement>EditSequence</IncludeRetElement>
 <IncludeRetElement>CustomerRef</IncludeRetElement>
 <IncludeRetElement>TxnDate</IncludeRetElement>
 <IncludeRetElement>TermsRef</IncludeRetElement>
 <IncludeRetElement>SalesRepRef</IncludeRetElement>
 <IncludeRetElement>AppliedAmount</IncludeRetElement>
 <IncludeRetElement>BalanceRemaining</IncludeRetElement>
 <IncludeRetElement>IsPaid</IncludeRetElement>
 <OwnerID>0</OwnerID>
  </InvoiceQueryRq>
 </QBXMLMsgsRq>
</QBXML>[5/30/2007 2:24:00 PM - 172.22.11.56]
Response from QuickBooks:
[5/30/2007 2:24:00 PM - 172.22.11.56]
<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<InvoiceQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK" iteratorRemainingCount="0" iteratorID="{641e3a4c-140e-4520-bcd4-c4246614a5f2}">
<InvoiceRet>
<TxnID>19C9-1071513897</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>470000-1071514123</ListID>
<FullName>Lochrie, Steven</FullName>
</CustomerRef>
<TxnDate>2007-08-22</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>87.28</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>19D3-1071513938</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>4A0000-1071514468</ListID>
<FullName>Heldt, Bob</FullName>
</CustomerRef>
<TxnDate>2007-08-23</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>101.82</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>484-934396748</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>150000-934380929</ListID>
<FullName>Williams, Abraham</FullName>
</CustomerRef>
<TxnDate>2007-11-05</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>-1315.00</AppliedAmount>
<BalanceRemaining>1979.89</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>17E2-1071514249</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>400000-1071506196</ListID>
<FullName>Walker, Rich</FullName>
</CustomerRef>
<TxnDate>2007-11-11</TxnDate>
<TermsRef>
<ListID>30000-934380929</ListID>
<FullName>Net 30</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>185.00</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>1433-1071508927</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>380000-1071503175</ListID>
<FullName>Gregory, Dru</FullName>
</CustomerRef>
<TxnDate>2007-11-12</TxnDate>
<TermsRef>
<ListID>50000-934380930</ListID>
<FullName>2% 10 Net 30</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>784.16</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>19B0-1071511698</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>3B0000-1071505048</ListID>
<FullName>Blackwell, Edward</FullName>
</CustomerRef>
<TxnDate>2007-11-15</TxnDate>
<TermsRef>
<ListID>40000-934380929</ListID>
<FullName>Due on receipt</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>1125.00</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>6EE-934410375</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>680000-1071522117</ListID>
<FullName>Pretell, Erika:Residential</FullName>
</CustomerRef>
<TxnDate>2007-11-17</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>-950.00</AppliedAmount>
<BalanceRemaining>1597.44</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>2283-1197765722</TxnID>
<EditSequence>1197765722</EditSequence>
<CustomerRef>
<ListID>700000-1197765612</ListID>
<FullName>Julie&apos;s Doll House</FullName>
</CustomerRef>
<TxnDate>2007-11-18</TxnDate>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>40.00</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>2287-1197765738</TxnID>
<EditSequence>1197765746</EditSequence>
<CustomerRef>
<ListID>6E0001-1197764528</ListID>
<FullName>Adam&apos;s Candy Shop</FullName>
</CustomerRef>
<TxnDate>2007-11-18</TxnDate>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>40.00</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>5B0-934399359</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>C0000-934380929</ListID>
<FullName>Hughes, David</FullName>
</CustomerRef>
<TxnDate>2007-11-24</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>-513.12</AppliedAmount>
<BalanceRemaining>336.88</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>5C8-934404130</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>100000-934380929</ListID>
<FullName>Lee, Laurel:Lee Residence</FullName>
</CustomerRef>
<TxnDate>2007-11-25</TxnDate>
<TermsRef>
<ListID>30000-934380929</ListID>
<FullName>Net 30</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>1724.84</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>17E7-1071514339</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>460000-1071507326</ListID>
<FullName>Rosenstock, Amy</FullName>
</CustomerRef>
<TxnDate>2007-11-25</TxnDate>
<TermsRef>
<ListID>30000-934380929</ListID>
<FullName>Net 30</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>845.73</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>19B6-1071511769</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>60000-934380929</ListID>
<FullName>Crenshaw, Bob</FullName>
</CustomerRef>
<TxnDate>2007-11-25</TxnDate>
<TermsRef>
<ListID>30000-934380929</ListID>
<FullName>Net 30</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>1575.00</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>605-934405023</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>A0000-934380929</ListID>
<FullName>Golliday Sporting Goods:155 Wilks Blvd.</FullName>
</CustomerRef>
<TxnDate>2007-11-30</TxnDate>
<TermsRef>
<ListID>20000-934380929</ListID>
<FullName>1% 10 Net 30</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>300.00</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>612-934405267</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>110000-934380929</ListID>
<FullName>Leon, Richard</FullName>
</CustomerRef>
<TxnDate>2007-11-30</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>1390.00</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>61D-934405412</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>80000-934380929</ListID>
<FullName>Ecker Design</FullName>
</CustomerRef>
<TxnDate>2007-11-30</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>-1000.00</AppliedAmount>
<BalanceRemaining>3047.96</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>11BB-1071524646</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>620000-1071512937</ListID>
<FullName>Balak, Mike:330 Main St</FullName>
</CustomerRef>
<TxnDate>2007-11-30</TxnDate>
<TermsRef>
<ListID>30000-934380929</ListID>
<FullName>Net 30</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>180.00</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>655-934406241</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>120000-934380929</ListID>
<FullName>Middlefield Elementary School</FullName>
</CustomerRef>
<TxnDate>2007-12-01</TxnDate>
<TermsRef>
<ListID>30000-934380929</ListID>
<FullName>Net 30</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>665.00</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>1472-1071519616</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>510000-1071506314</ListID>
<FullName>Theurer-Davis, Vicki:Irrigation &amp; Lawn</FullName>
</CustomerRef>
<TxnDate>2007-12-01</TxnDate>
<TermsRef>
<ListID>70000-1071515668</ListID>
<FullName>8% 30 Net 60</FullName>
</TermsRef>
<AppliedAmount>-300.00</AppliedAmount>
<BalanceRemaining>907.29</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>624-934405526</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>B0000-934380929</ListID>
<FullName>Golliday Sporting Goods:75 Sunset Rd.</FullName>
</CustomerRef>
<TxnDate>2007-12-02</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>2404.19</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>149D-1071521470</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>670000-1071522050</ListID>
<FullName>Pretell, Erika:Pretell Estates</FullName>
</CustomerRef>
<TxnDate>2007-12-04</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>1389.01</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>6AE-934409726</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>130000-934380929</ListID>
<FullName>Paxton Consulting</FullName>
</CustomerRef>
<TxnDate>2007-12-05</TxnDate>
<TermsRef>
<ListID>30000-934380929</ListID>
<FullName>Net 30</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>3750.00</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>1421-1071508701</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>4A0000-1071514468</ListID>
<FullName>Heldt, Bob</FullName>
</CustomerRef>
<TxnDate>2007-12-08</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>1825.92</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>991-1071515873</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>60000-934380929</ListID>
<FullName>Crenshaw, Bob</FullName>
</CustomerRef>
<TxnDate>2007-12-10</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>16.03</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>995-1071515873</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>C0000-934380929</ListID>
<FullName>Hughes, David</FullName>
</CustomerRef>
<TxnDate>2007-12-10</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>16.58</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>999-1071515873</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>150000-934380929</ListID>
<FullName>Williams, Abraham</FullName>
</CustomerRef>
<TxnDate>2007-12-10</TxnDate>
<TermsRef>
<ListID>40000-934380929</ListID>
<FullName>Due on receipt</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>9.57</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>13F7-1071506534</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>490000-1071514373</ListID>
<FullName>Loomis, Anne</FullName>
</CustomerRef>
<TxnDate>2007-12-10</TxnDate>
<TermsRef>
<ListID>20000-934380929</ListID>
<FullName>1% 10 Net 30</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>4190.20</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>1444-1071516915</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>660000-1071516786</ListID>
<FullName>Rummens, Susie:721 Fern Lane</FullName>
</CustomerRef>
<TxnDate>2007-12-11</TxnDate>
<TermsRef>
<ListID>40000-934380929</ListID>
<FullName>Due on receipt</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>135.00</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>E83-1071510007</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>4C0000-1071514334</ListID>
<FullName>Hermann, Jennifer:Residential Maintenance</FullName>
</CustomerRef>
<TxnDate>2007-12-12</TxnDate>
<TermsRef>
<ListID>30000-934380929</ListID>
<FullName>Net 30</FullName>
</TermsRef>
<SalesRepRef>
<ListID>10000-1071515615</ListID>
<FullName>SBH</FullName>
</SalesRepRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>35.00</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>143B-1071516310</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>650000-1071509105</ListID>
<FullName>Rummens, Susie:2877 S Rosebush</FullName>
</CustomerRef>
<TxnDate>2007-12-12</TxnDate>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>1438.56</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>1463-1071518340</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>550000-1071508586</ListID>
<FullName>Stinson, Tracy</FullName>
</CustomerRef>
<TxnDate>2007-12-12</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>1730.30</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>718-934410716</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>D0000-934380929</ListID>
<FullName>Jim&apos;s Family Store</FullName>
</CustomerRef>
<TxnDate>2007-12-14</TxnDate>
<TermsRef>
<ListID>30000-934380929</ListID>
<FullName>Net 30</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>1833.37</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
<InvoiceRet>
<TxnID>1410-1071506667</TxnID>
<EditSequence>1032980348</EditSequence>
<CustomerRef>
<ListID>80000-934380929</ListID>
<FullName>Ecker Design</FullName>
</CustomerRef>
<TxnDate>2007-12-15</TxnDate>
<TermsRef>
<ListID>10000-934380929</ListID>
<FullName>Net 15</FullName>
</TermsRef>
<AppliedAmount>0.00</AppliedAmount>
<BalanceRemaining>123.00</BalanceRemaining>
<IsPaid>false</IsPaid>
</InvoiceRet>
</InvoiceQueryRs>
</QBXMLMsgsRs>
</QBXML>
[5/30/2007 2:24:00 PM - 172.22.11.56]

[5/30/2007 2:24:00 PM - 172.22.11.56] Client has disconnected.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-05-31 08:43:06

My recommended settings for using QODBC are shown here, the start of every connection will only preform a update at the start of every Crystal Reports Server session instead of every query, meaning reports can be re-run a whole lot faster.

The QODBC Remote Connector is also slower than using the QODBC Server Edition DCOMs and having QuickBooks locally.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to