Greetings, Your dirver looks promising for a project. I looked at the 2003 schema and could not find where the Customer's Credit card information, particularly...
29
manishkrishan <man...
manishkrishan
Feb 14, 2003 4:04 am
I have downloaded the QODBC evaluation version. I am trying it with QuickBooks 2003. But whenever I try to run the VB demo program it show me the following...
30
r30316 <mark.ander...
r30316
Feb 14, 2003 10:12 pm
You might want to try updating Quickbooks. Click on "File" then "Update Quickbooks". Also make sure all the registration info (Registration Code, Serial#,...
31
Manish K. Agarwal
manishkrishan
Feb 18, 2003 3:32 am
Hi, I have already tried it (Click on "File" then "Update Quickbooks") I was trying it with trial version QB2003. Any other reason for this. Manish ... From:...
32
Brad Waddell
flexq
Feb 18, 2003 3:50 am
Ah, that is the problem. QODBC does not work with trial versions of QuickBooks. thanks! brad qodbc.com ... Brad Waddell *** FLEXquarters.com ***...
33
wjwinans <techinfo...
wjwinans
Feb 24, 2003 8:10 pm
Any word on when the release of the network-based verions of QODBC will be out?...
34
Brad Waddell
flexq
Feb 24, 2003 10:43 pm
Working on it, could be about 6 weeks. thanks! Brad Waddell Product Manager, QODBC the ODBC Driver for QuickBooks www.QODBC.com ... Brad Waddell ***...
35
enadel <enadel@......
enadel
Mar 3, 2003 8:38 pm
It seems to me that the DepositLine table is not being processed correctly. I tried importing this table into MS Access 2000 and found that while the...
36
Forever Nicholas <...
forever_nich...
Mar 3, 2003 8:47 pm
Quickbook Clients will not close after running a query against the Check table. I used logging in the ODBC config and logs shows database close was issued and...
37
Brad Waddell
flexq
Mar 3, 2003 11:02 pm
We will take a look into this right away, thanks for the detailed information! The way QuickBooks SDK handles child record line items is particularly...
38
Brad Waddell
flexq
Mar 4, 2003 12:03 am
Which client are you using? Some applications don't close properly, and in those cases you must close QuickBooks via the task manager, but there is no risk of...
39
Forever Nicholas <...
forever_nich...
Mar 4, 2003 3:10 am
The Client is Quickbooks 2003 The program that is reading the Check Table is Compiled Perl That's how I've been closing it but it makes me a little nervous. ...
40
Brad Waddell
flexq
Mar 4, 2003 9:54 am
... The Client is Perl - and it is not closing the files properly. Check with the Perl documentation and check for ways you can flush all buffers and sever the...
41
Anthony Smith
anthony_smith_524@...
Mar 6, 2003 3:16 pm
... GHR Renew U is a 100 % Natural Nutraceutical Capsule product developed in our own laboratories by our chemists and clinically tested by doctors in studies...
42
Ellis Lombert
elombert
Mar 7, 2003 6:45 pm
Hi! I'd like to know how to access the prefered Payment Method info for a customer? It is not listed on the Customer table schema. Thanks Ellis...
43
pot_sumper
Mar 8, 2003 10:17 pm
Hello - I am hoping to create invoices in QB Pro 2002 using QODBC, and am wondering if anyone on this group knows if this is possible. After looking at the...
44
Brian Anderson
brianinberthoud
Mar 9, 2003 6:27 am
Richard, I think there are other fields that you want to copy in on the invoice header (billing and shipping address, etc.). The schema definition says that...
45
John Spikowski
johnspikowski
Mar 9, 2003 6:41 am
As I understand it from Brad, Invoice (header & lines) are READONLY at this point. Invoice creation is not a feature of the ODBC driver at the moment. I heard...
46
John Spikowski
johnspikowski
Mar 9, 2003 6:59 am
Version 3.0.0.013 - Readme.rtf < The SDK that we use from Intuit requires that you have an open session of QuickBooks when using QODBC to make a connection to...
47
Brian Anderson
brianinberthoud
Mar 9, 2003 9:50 pm
John, A quick question on the schema definition from QODBC, is there a further explanation of the column titles? Because on the Invoice file, the column labled...
48
John Spikowski
johnspikowski
Mar 9, 2003 10:02 pm
If you have a Visual Basic background, you could access Intuit's QBFC (QuickBooks foundation class) COM object to handle invoice creation. (You might want to...
49
pot_sumper
Mar 10, 2003 1:13 am
John, Brian: Thank you for the responses. I'll keep watching the newsgroup, and also for the QODBC release. Don't want to fool with QBFC if the SDK allows it...
50
Brad Waddell
flexq
Mar 10, 2003 1:41 am
We are currently working on tutorials for inserting invoices, among other items which have child records, when it is available, we will notify our mailing list...
51
Brad Waddell
flexq
Mar 10, 2003 1:41 am
QuickBooks must always be "running" in memory of the machine you wish to use the qbXML system on. this does not mean it has to be loaded as a foreground...
52
Brad Waddell
flexq
Mar 10, 2003 1:41 am
The reason some files are read-only is only because we are designing a method of saving the child records and the parent at the same time. ODBC, being record...
53
John Spikowski
johnspikowski
Mar 10, 2003 1:54 am
I now see your dilemma. Could you expand a bit on how you plan on solving this? (two logical tables) ... From: Brad Waddell [mailto:brad@...] ...
54
Brad Waddell
flexq
Mar 10, 2003 1:54 am
If it is not listed in our schema document, it is not available from the QuickBooks SDK, the method we use for accessing information from QuickBooks files. If...
55
Brian Anderson
brianinberthoud
Mar 10, 2003 3:38 am
Brad, I dont' believe ODBC supports transactions, but perhaps you could do a pseudo-transaction environment to handle invoice headers and related child records...
56
John Spikowski
johnspikowski
Mar 10, 2003 4:59 am
I'm confused how the ODBC driver would work in a multi-user environment. *NOTE: PC1 & PC2 are on a local network. PC1 - Has QuickBooks running on it. PC2 - Has...
57
Brad Waddell
flexq
Mar 10, 2003 7:03 am
At the moment the plan is to use work tables to load all of the parts into, then do a passthru query calling a stored procedure to post all of the work tables...
