I just bought this product today and am impressed with how easy it is to use --- I did the entire set up and when testing the append to the Invoice Line table...
See FAQ at: http://www.qodbc.com/QODBCAutoFAQ.htm?faq_id=27 <http://www.qodbc.com/QODBCAutoFAQ.htm?faq_id=27&category_id=1> &category_id=1 Run the SQL: ...
Thanks for the help. only I'm still having some minor difficulties. My insert statement seams to be working but I do not see any data in Quickbooks(I made...
Set the FQSaveToCache to False and see if it makes it to Quickbooks --- that's all I needed to do.. Eileen Murphy epmConsulting, Inc. cell/voice mail:...
On the last line you insert into the invoiceline table set the FQSaveToCache = 0. If you only have one line, set it to 0. If it would make coding easier you...
You're very welcome. _____ From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of bnr1900 Sent: Tuesday, November 08, 2005 12:16 PM To:...
I have a speed problem with QODBC, and would be grateful for any pointers on how to improve things. I've read the FAQ entry on this, and it doesn't seem to be...
In the where statement use FullName instead of Name. FullName is what we call a jumpin and reduces the amount of data exchanged between QODBC and QuickBooks. ...
We're using the multi store version of QBPOS and when using QODBC to view the Inventory Item table in Access, there are no values in the Qty on Hand fields....
Using: QB Premiere 2005 (contractor's edition). QODBC Driver for QuickBooks Pro 2005/2004/2003/2002 Version 5.0.0.104 Microsoft Access 2002 - SP2 I have an...
Please visit www.qodbc.com/schema to see the TimeTracking Table. note which fields are insertable, modifyable, etc. Chuck Vigeant M.Ed. MCSE, CCNA, Certified...
I have the following set up on a small LAN: QB Premiere 2005/Contractor's Edition (5 PC License) 1 QODBC Driver for QuickBooks 2005 USA Read/Write I wish to...
The QODBC driver is machine specific,,, so you need a driver for each machine. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director,...
Dear All, I have the following questions about the new driver. - Does it support QuickBooks RDS? - What the optimizer really does? Is it keeping a synchronized...
Hi all, The New QuickBooks Enterprise 6.0 is based in a relational database core, probable Sybase. Is QODBC already ready for that release? It should improbe...
William, QODBC does not provide support for RDS setup but because QODBC is based off of the SDK it should work. QODBC does include the /nSoftware Remote ...
... I set it up to give Linux machines access to QB. It worked fine for me. I eventually moved the scripts to the windows machine itself and removed it....
Congratulations on the release of QODBC 6! I have a question on the performance improvements and version dependencies though. The product page on your website...
... Yes. ... Yes. The comment about "best performance" refers mainly to the way data is transferred to our optimization routines. The speed of the driver using...
I've just recently made a huge upgrade in my Quickbooks. Went from 2003 Pro 5-user edition to 2006 Enterprise Edition. With the 2003 version I was using QODBC...
You won't have to upgrade QReportGrabber, but we have some issues with it and the new driver. It will probably be a week or two to work out the bugs. Chuck...
The QODBC version with Enterprise is read-only, if that is what you need, you are all set. If you need write ability, it's just $99 after rebate with proof of...
I've imported about 500 PO's into QB06. I'm working on adding the bills to those PO's and having them linked. I've successfully inserted the bill but not...
Mario, The full updated schema connected to your version of QuickBooks can be seen by using the sp_columns command in QODBC - the only part we have not ...
Thanks for the heads up on the sp_columns. It will definately help. I've searched the KB and haven't found what I need. Here's the issue in more details....
I've been using a form in MS Access that inserts invoices into QB for about a year now without a glitch and now it won't work. Below is a sample sql statement...
Have you upgraded the QODBC driver and/or your version of QuickBooks? Can you post the error message being generated by the QuickBooks tool? ... for ... ...
Try testing by inserting first with the minimum fields, then add one field back at a time until you see which is the offending field. Off the top of my head,...