Quickbooks - Customer table ?

I am trying to add Customers to the Customer table using QODBC. I am doing this in vb.net with ADO. But when I try to put values for the "BillAddressAddr1" field I get an error, same with any of the other 4 BillAddressAddr fields. But "BillAddressCity" and the others works fine.
I checked the ADO record and it shows these columns, spelled same as I have it. What could this be?
LVL 1
Jess31Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
stlinaeConnect With a Mentor Commented:
What version of the qODBC driver are you using? What version of QuicBooks? Can you add a customer from the VBDemo? What error are you receiving?

You have to use the columns in the same order as they're shown here:
http://tinyurl.com/2gya8dc
0
 
Jess31Author Commented:
The Problem is only when I'm doing an Insert with Name, CompanyName, BillAddressAddr1, BillAddressCity/state/postalcode/phone/fax/email/notes. If I leave out the BillAddressAddr1 it works. And if I do an Update on this record and set the BillAddressAddr1 this works.

The error I get is
"[QODBC] Error parsing complete XML return string"
0
 
Jess31Author Commented:
I've requested that this question be deleted for the following reason:

it's been way too long. does not seem of any use keeping in online.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.