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 : Error 3110Search Forum

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

 New Topic 
 
 Post Reply 
[1]  
 Error 3110 
 Author   Message 
  Don 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-11-15 
 Profile
 Posted : 2006-11-15 20:58:09

I just upgraded from version 6.0.0.155 to 7.0.199 and have noticed several issues while trying to import the data directly into Access 2003 against QB Pro 2005 on top of XP Pro-SP2. The import process now takes forever (hours) in version 7.x  and has grown the database size within Access from 128MB (Ver 6.x) to over 250MB in ver 7.x

Just in case the issue was with the QB DB I ran a rebuild prior to loading the data and had no issues.
I turned off the Optimizer in Ver 7.x in an attempt to facilitate speed for one time imports of the QB snapshot
All other tables appear to import OK except the following three

First, I get an error with the Entity table however, VB App appears to be able to get to the data :

Second, I get an issue with the PayrollItemNonWage table - however the error seems to be reasonable but wanted to check as it was never thrown in Ver 6

 

Lastly, I'm getting an error on the TxnDeleted table. I first noticed that under 6.x that the table was present but there was never any rows present which started my whole upgrade process to Ver 7.x.
This table does contain data as the QB report "Voided/Deleted Transactions"  show the deleted items within the report

My process is to export all QB data and build custom analytic reports off-line to QB
I would appreciate knowing how to get these two tables exported cleanly into Access.

Thanks,
Don 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-11-15 21:32:56

Because of the large record sets being used here, the Iterator or Chunk Size in the Advanced Tab in the QODBC Setup Screen should be setup up to accomodate the largest returned record set to speed up your imports. The default is 500, and it can be set to any value up to 100,000. Increasing the Iterator or Chunk Size will also fix the ODBC call failed. [QODBC] error (#10004) you are getting with the Entity table.

To see Payroll tables you must have a current Intuit Payroll Service subscription for the company file in question.

The TxnDeleted table is only valid for USA versions of QuickBooks. It does not function for Canadian, UK or Australian versions of QuickBooks.

 

 

  Top 
  Don 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-11-15 
 Profile
 Posted : 2006-11-15 23:01:00

Thanks for the quick reply and solution for the first two issues.
Interesting the first 155MB ripped througn in @30 min. still waiting on the Transaction table (@86K rows) to complete an hour later

I am using a USA version of QB so the TxnDeleted table error is still an open issue

 

  Top 
  Don 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-11-15 
 Profile
 Posted : 2006-11-16 02:53:00

As from before the TxnDeleted error is raised on a USA version  of QB 2005 Pro
Please let me know if there is anything else I can provide to help resolve the issue

Regards,
Don

A portion of the qbsdkklog with the error for the TxnDeleted table:

20061115.054141 I 332 RequestProcessor ========= Started Connection =========
20061115.054141 I 332 RequestProcessor Request Processor, QBXMLRP2 v4.0
20061115.054141 I 332 RequestProcessor Connection opened by app named 'FLEXquarters QODBC'
20061115.054142 I 332 RequestProcessor Opening the file in the DoNotCare mode.
20061115.054149 I 372 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 332).
20061115.054206 I 372 SpecVersion Current version of qbXML in use: 4.0
20061115.054206 I 372 QBSDKMsgSetHandler QUERY: Host
20061115.054206 I 372 QBSDKMsgSetHandler Request 1 completed successfully.
20061115.054206 I 372 QBSDKMsgSetHandler QUERY: Company
20061115.054206 I 372 QBSDKMsgSetHandler Request 2 completed successfully.
20061115.054206 I 372 QBSDKMsgSetHandler QUERY: DataExtension Definition
20061115.054206 I 372 QBSDKMsgSetHandler Request 3 completed successfully.
20061115.054206 I 372 MsgSetHandler Finished.
20061115.054206 I 372 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 332), ret = 0.
20061115.054208 I 372 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 332).
20061115.054209 I 372 SpecVersion Current version of qbXML in use: 4.1
20061115.054209 I 372 QBSDKMsgSetHandler QUERY: Transaction Delete
20061115.054209 E 372 TxnDeletedStorage::DoQuery Data Validation Failure: The enumerated value "ARRefundCreditCard" in the field "TxnDelType" is unknown or invalid for the qbXML version in use.
20061115.054209 I 372 QBSDKMsgSetHandler Request 1 failed.
20061115.054209 I 372 MsgSetHandler Finished.
20061115.054209 I 372 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 332), ret = 0.
20061115.072317 I 332 RequestProcessor Connection closed by app named 'FLEXquarters QODBC'
20061115.072317 I 332 RequestProcessor ========== Ended Connection ==========
20061115.072317 I 332 CertVerifier The Authenticode signature validated OK.

And from the Trace Log:

ISAMOpen
    Database: C:\Accounting\QuickBooks\Master Manuals, Inc..QBW
    DSN: QuickBooks Data
    UserName:
    Password:
    DeveloperCode:
    ApplicationCode:
    OpenMode: F
    UseDCOM: N
    IBizRemoteConnection: N
    IBizRemoteURL: http://localhost:2080
    IBizRemoteUserName: admin
    IBizRemotePassword:
    IBizRemoteAskPassword: Y
    IBizRemoteSSLAcceptServerCert:
    IBizRemoteConnectionTimeOut: 120
    IBizRemoteForce2002_2003: N
    IBizOEConnection: N
    IBizOETicketGUID:
    IBizOELoginGUID:
    IBizOELoginAsk: Y
    IBizReconnectionDelay: 0
    ColumnNameLen: 50
    UseCaseSensitiveRefNumber: Y
    OptimizerOn: N
    OptimizerDBFolder: C:\Documents and Settings\dward\Application Data\QODBC Driver for QuickBooks\Optimizer
    OptimizerCurrency: C
    OptimizerEncrytionOn: Y
    UseIterators: Y
    IteratorChunkSize:  100000
    IAppLaunchQBUI: N
    IAppAutomaticLogin: Y
    IAppReadOnly: N
    IAppAllowPersonalData: Y
    OleInitialize - Returned OK
    Logged In User:    dward
    Is a Service:      No
    Registration Name: Don Ward
    RegSerial:         W06U10014668
    QODBC Version:     7.00.00.199
    DLL:               C:\WINDOWS\system32\fqqb32.dll
    Driver Name:       FQQB32.DLL
    Process Count:     1
    Thread Count:      0
    OpenMode:          Follow Company
    Include Raw:       No
    Version Type:      QODBC Desktop Read Write 2006
    Access Method:     QBXMLRP2.DLL (IAuth2)
    Thread ID:         320
    SDK Module:        QBXMLRP2.DLL (IAuth2)
    QB Company Name:   C:\Accounting\QuickBooks\Master Manuals, Inc..QBW
    QB Product Name:   QuickBooks Pro 2005
    QB Major Version:  15
    QB Minor Version:  0
    QB File Mode:      SingleUser
    QB Automatic Login:No
    QB Country:        US
    QB Supported Ver:  1.0
    QB Supported Ver:  1.1
    QB Supported Ver:  2.0
    QB Supported Ver:  2.1
    QB Supported Ver:  3.0
    QB Supported Ver:  4.0
    QB Supported Ver:  4.1
    Optimize File:
    0x001DF1E8 [ISAM]
    NO_ISAM_ERR 00000 00000
ISAMDriver
    0x001DF1E8 [ISAM]
    FQQB32.DLL
ISAMPrepare
    0x001DF1E8 [ISAM]
    SELECT Config, nValue FROM MSysConf
    35
    0x00000000 [ISAMStatement]
   
    0
    10003
ISAMCaseSensitive
    0x001DF1E8 [ISAM]
    FALSE
ISAMMaxTableNameLength
    0x001DF1E8 [ISAM]
    63
ISAMOpenTable
    0x001DF1E8 [ISAM]
    MSysConf
   
    TRUE
    1
    FALSE
    FALSE
    FALSE
    FALSE
    FALSE
    ERR_INVALIDTABLENAME S0000 S0000 [QODBC] Invalid table name: %s
ISAMGetErrorMessage
    0x001DF1E8 [ISAM]
    S0000 S0000 [QODBC] Invalid table name: %s
ISAMName
    0x001DF1E8 [ISAM]
    QODBC [FLEXquarters]
ISAMGetTableList
    0x001DF1E8 [ISAM]
    Pattern: %
    Patten Length: 1
    0x00235818 [ISAMTableList]
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Account
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Bill
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    BillExpenseLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    BillItemLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    BillLinkedTxn
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    BillPaymentCheck
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    BillPaymentCheckLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    BillPaymentCreditCard
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    BillPaymentCreditCardLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    BillToPay
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Charge
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ChargeLinkedTxn
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Check
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CheckExpenseLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CheckItemLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Class
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ClearedStatus
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Company
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CompanyActivity
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CreditCardCharge
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CreditCardChargeExpenseLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CreditCardChargeItemLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CreditCardCredit
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CreditCardCreditExpenseLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CreditCardCreditItemLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CreditMemo
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CreditMemoLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CreditMemoLinkedTxn
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Customer
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CustomerMsg
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CustomerType
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    CustomField
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    DateDrivenTerms
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Deposit
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    DepositLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Employee
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    EmployeeEarning
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Entity
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Estimate
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    EstimateLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    EstimateLinkedTxn
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Host
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    HostSupportedVersions
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    InventoryAdjustment
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    InventoryAdjustmentLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Invoice
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    InvoiceLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    InvoiceLinkedTxn
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Item
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemDiscount
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemFixedAsset
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemGroup
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemGroupLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemInventory
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemInventoryAssembly
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemInventoryAssemblyLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemNonInventory
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemOtherCharge
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemPayment
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemReceipt
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemReceiptExpenseLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemReceiptItemLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemReceiptLinkedTxn
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemSalesTax
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemSalesTaxGroup
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemSalesTaxGroupLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemService
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ItemSubtotal
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    JobType
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    JournalEntry
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    JournalEntryCreditLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    JournalEntryDebitLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    JournalEntryLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ListDeleted
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    OtherName
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    PaymentMethod
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    PayrollItemNonWage
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    PayrollItemWage
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Preferences
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    PriceLevel
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    PriceLevelPerItem
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    PurchaseOrder
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    PurchaseOrderLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    PurchaseOrderLinkedTxn
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ReceivePayment
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ReceivePaymentLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ReceivePaymentToDeposit
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Sales
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    SalesLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    SalesOrder
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    SalesOrderLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    SalesOrderLinkedTxn
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    SalesReceipt
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    SalesReceiptLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    SalesRep
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    SalesTaxCode
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    SalesTaxPaymentCheck
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    SalesTaxPaymentCheckLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ShipMethod
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    StandardTerms
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Template
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Terms
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    TimeTracking
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    ToDo
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Transaction
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    TxnDeleted
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    Vendor
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    VendorCredit
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    VendorCreditExpenseLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    VendorCreditItemLine
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    VendorCreditLinkedTxn
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    VendorType
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x00235818 [ISAMTableList]
    VendorType
    ISAM_EOF S0000 S0000 [QODBC] No data found
ISAMFreeTableList
    0x00235818 [ISAMTableList]
    NO_ISAM_ERR 00000 00000
ISAMOpenTable
    0x001DF1E8 [ISAM]
    TxnDeleted
   
    TRUE
    1
    TRUE
    FALSE
    FALSE
    FALSE
    FALSE
    Elapsed Time: 00:00:00 Time Difference: 00:00:00.000 Open Table
    0x05730048 [TxnDeleted]
        TxnDeleted
        6
            TxnDelType
                SQL_VARCHAR
                20
                0
                1
                9
                0
            TxnID
                SQL_VARCHAR
                36
                0
                0
                1
                1
            TimeCreated
                SQL_TIMESTAMP
                27
                0
                1
                0
                0
            TimeDeleted
                SQL_TIMESTAMP
                27
                0
                1
                9
                0
            TimeModified
                SQL_TIMESTAMP
                27
                0
                1
                9
                0
            RefNumber
                SQL_VARCHAR
                20
                0
                1
                0
                0
    NO_ISAM_ERR 00000 00000
ISAMCloseTable
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    NO_ISAM_ERR 00000 00000
ISAMGetTableList
    0x001DF1E8 [ISAM]
    Pattern: TxnDeleted
    Patten Length: 10
    0x002293F0 [ISAMTableList]
    NO_ISAM_ERR 00000 00000
ISAMGetNextTableName
    0x002293F0 [ISAMTableList]
    TxnDeleted
    NO_ISAM_ERR 00000 00000
ISAMOpenTable
    0x001DF1E8 [ISAM]
    TxnDeleted
   
    TRUE
    1
    TRUE
    FALSE
    FALSE
    FALSE
    FALSE
    Elapsed Time: 00:00:00 Time Difference: 00:00:00.000 Open Table
    0x05730048 [TxnDeleted]
        TxnDeleted
        6
            TxnDelType
                SQL_VARCHAR
                20
                0
                1
                9
                0
            TxnID
                SQL_VARCHAR
                36
                0
                0
                1
                1
            TimeCreated
                SQL_TIMESTAMP
                27
                0
                1
                0
                0
            TimeDeleted
                SQL_TIMESTAMP
                27
                0
                1
                9
                0
            TimeModified
                SQL_TIMESTAMP
                27
                0
                1
                9
                0
            RefNumber
                SQL_VARCHAR
                20
                0
                1
                0
                0
    NO_ISAM_ERR 00000 00000
ISAMCaseSensitive
    0x001DF1E8 [ISAM]
    FALSE
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 0 [TxnDelType]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 0 [TxnDelType]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 0 [TxnDelType]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 0 [TxnDelType]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 0 [TxnDelType]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 0 [TxnDelType]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 0 [TxnDelType]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMCaseSensitive
    0x001DF1E8 [ISAM]
    FALSE
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 1 [TxnID]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 1 [TxnID]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 1 [TxnID]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 1 [TxnID]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 1 [TxnID]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 1 [TxnID]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 1 [TxnID]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMCaseSensitive
    0x001DF1E8 [ISAM]
    FALSE
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 2 [TimeCreated]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 2 [TimeCreated]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 2 [TimeCreated]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 2 [TimeCreated]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 2 [TimeCreated]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 2 [TimeCreated]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 2 [TimeCreated]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMCaseSensitive
    0x001DF1E8 [ISAM]
    FALSE
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 3 [TimeDeleted]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 3 [TimeDeleted]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 3 [TimeDeleted]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 3 [TimeDeleted]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 3 [TimeDeleted]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 3 [TimeDeleted]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 3 [TimeDeleted]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMCaseSensitive
    0x001DF1E8 [ISAM]
    FALSE
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 4 [TimeModified]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 4 [TimeModified]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 4 [TimeModified]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 4 [TimeModified]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 4 [TimeModified]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 4 [TimeModified]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 4 [TimeModified]
    0x04DBCB00 [SqlType]
        SUPPORTED: TRUE
        NAME:      TIMESTAMP
        TYPE:      11
ISAMCaseSensitive
    0x001DF1E8 [ISAM]
    FALSE
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 5 [RefNumber]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 5 [RefNumber]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 5 [RefNumber]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 5 [RefNumber]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 5 [RefNumber]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 5 [RefNumber]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetColumnType
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    COLUMN: 5 [RefNumber]
    0x04DBCB30 [SqlType]
        SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMGetNextTableName
    0x002293F0 [ISAMTableList]
    TxnDeleted
    ISAM_EOF S0000 S0000 [QODBC] No data found
ISAMFreeTableList
    0x002293F0 [ISAMTableList]
    NO_ISAM_ERR 00000 00000
ISAMCloseTable
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    NO_ISAM_ERR 00000 00000
ISAMOpenTable
    0x001DF1E8 [ISAM]
    TxnDeleted
   
    TRUE
    1
    TRUE
    FALSE
    FALSE
    FALSE
    FALSE
    Elapsed Time: 00:00:00 Time Difference: 00:00:00.000 Open Table
    0x05730048 [TxnDeleted]
        TxnDeleted
        6
            TxnDelType
                SQL_VARCHAR
                20
                0
                1
                9
                0
            TxnID
                SQL_VARCHAR
                36
                0
                0
                1
                1
            TimeCreated
                SQL_TIMESTAMP
                27
                0
                1
                0
                0
            TimeDeleted
                SQL_TIMESTAMP
                27
                0
                1
                9
                0
            TimeModified
                SQL_TIMESTAMP
                27
                0
                1
                9
                0
            RefNumber
                SQL_VARCHAR
                20
                0
                1
                0
                0
    NO_ISAM_ERR 00000 00000
ISAMCloseTable
    0x001DF1E8 [ISAM]
    0x05730048 [TxnDeleted]
    NO_ISAM_ERR 00000 00000
ISAMName
    0x001DF1E8 [ISAM]
    QODBC [FLEXquarters]
ISAMName
    0x001DF1E8 [ISAM]
    QODBC [FLEXquarters]
ISAMPrepare
    0x001DF1E8 [ISAM]
    SELECT "TxnDelType" ,"TxnID" ,"TimeCreated" ,"TimeDeleted" ,"TimeModified" ,"RefNumber"  FROM "TxnDeleted"
    107
    0x00000000 [ISAMStatement]
   
    0
    10003
ISAMCaseSensitive
    0x001DF1E8 [ISAM]
    FALSE
ISAMMaxTableNameLength
    0x001DF1E8 [ISAM]
    63
ISAMOpenTable
    0x001DF1E8 [ISAM]
    TxnDeleted
   
    TRUE
    1
    FALSE
    FALSE
    FALSE
    FALSE
    FALSE
    Elapsed Time: 00:00:00 Time Difference: 00:00:00.000 Open Table
    0x05730048 [TxnDeleted]
        TxnDeleted
        6
            TxnDelType
                SQL_VARCHAR
                20
                0
                1
                9
                0
            TxnID
                SQL_VARCHAR
                36
                0
                0
                1
                1
            TimeCreated
                SQL_TIMESTAMP
                27
                0
                1
                0
                0
          & 


  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-11-16 08:52:27

Your problem has been logged with the QODBC Software Engineer for review under Ticket ID: BR00000039. I will respond once a reply has been received.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-11-23 08:45:15
We had ARRefundCreditCard listed as being avaliable in the Intuit qbXML 4.1 SDK used by QuickBooks 2005 and it is really in 5.0 used by QuickBooks 2006. So we have fixed this in QODBC v7.00.00.201 (and higher). This bug only affects individuals running SDK 4.1 (used in all USA versions of QuickBooks 2005). 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-12-20 12:32:58
We have now removed ARRefundCreditCard from the TxnDeleted table for SDK 4.1. That table did not appear until SDK 5.0 (QuickBooks 2006 USA Editions). See: QODBC v7.0.0.204 Released for more.  

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to