Hi, I am getting the following error trying to run an ASP page that connects to my QuickBooks data file. I have QuickBooks Pro 2003 (for Accountants) and I've...
Attempting to create a check transaction from an Access front end. All works fine until I attempt to manipulate the amount field, which is consistent with...
I have been able to add invoiceLine records whick result in the creation of invoice records. Using the same method, I tried to add credit memo line items. No...
We just purchased the upgrade. Worked through a couple of DCOM errors. But we are still getting the same error through through SQL Server/Query Analyzer: OLE...
Bank Transfers are not available in the Intuit SDK at this time. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director, FLEXquarters...
INNER JOIN is implicit, and should not be used in the statement. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director, FLEXquarters...
The check amount as you state is not insertable, because it is a calculated total of either checkexpenseline items or checkitemline items. Chuck Vigeant M.Ed....
Go to Program Files\Intuit\QB Pro 2003 (or wherever the main directory of the QB program is) and run reboot.bat That should solve your problem. Chuck Vigeant...
NumColumns refers to the total number of columns returned. Amount_count refers to the number of Amount_"x" columns returned to help you with this process. If...
I have the web version of QODBC installed on my server and have gone through the steps to create a linked server. I can use the three sample queries using SQL...
Hi all, I am writing a VB application to insert an invoice into QuickBooks Premier 2004 using the "QODBC Pro Read/Write 2004 Asia Pacific Version 4.20.00.050"...
addendum note to my *.UDL question: Although the "Provider" tab of the "Data link properties" dialog for My TEST.UDL has to be set to "Microsoft OLE DB Provder...
... So I'd replicate the QB database using Access, then query the database in Access? Sorry, I'm not a database whiz and aren't sure how to set this up....
I created a file TEST.txt. Chnaged the name to TEST.UDL. then, I attempted to set it up with the UDL "Data Link Properies" window that comes up when I double...
Dear Sir/Madam, I've been trying to insert or update an Invoice's CustomFieldOther field without success. Below are examples of my sql statements: (1) To...
The custom fields Other, Other1 and Other2 are not updatable through the SDK and therefore not updatable through QODBC. Matt Froncek QODBC Development Support ...
That is not possible unless you create a little vb applet that calls the names into an array. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor ...
I suggest that you take a step back and test it in vbdemo to make sure there is no QODBC syntax errors. Then take it back to your code to see if you have any...
We have no timetable from Intuit. We have passed on the request previously. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director,...
Yes, the step back approach is usually the best. In this case, you must insert an InvoiceLine record first. Every invoice must have at least one line. You can...
If you are doing a pass through query or using VBDemo32 or CPPDem32 then the inner join use the {oj } syntax as follows: SELECT ItemInventory.SalesDesc AS...
Can you send a snippet of code or SQL statement you are using? Matt Froncek QODBC Development Support QODBC Driver for QuickBooks - Unleash your data at...
I have already loaded QODBC Pro with my Quickbooks Premier. We are getting ready to upgrade to Quickbooks Enterprise. Is there anything I will need to do for...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
