QODBC only supports the DEFAULT shipping address in USA editions of QuickBooks 2006. While USA users of QuickBooks 2006 can enter multiple addresses and set which address (Ship To 1, Ship To 2, Ship To 3 etc) is the DEFAULT shipping address, QODBC will only show the DEFAULT shipping address in the Customer table.

In this example I set the DEFAULT shipping address to  Ship To 2 :

So when I run the following query:

SELECT "ShipAddressAddr1", "ShipAddressAddr2", "ShipAddressAddr3", "ShipAddressAddr4",
"ShipAddressCity",  "ShipAddressState", "ShipAddressPostalCode", "ShipAddressCountry"
FROM Customer where "FullName" = 'Data Access Worldwide'

I now see the Ship To 2 shipping address:

Has there been any change to this since 2006? It would be helpful to be able to access the full list of on file Ship to addresses via QODBC.

Thanks.