We are preparing to import Bills from our MS SQL 2000 database into Quickbooks via QODBC. We have observed that, when a bill is created within Quickbooks it...
1291
Chuck Vigeant
txbtech
Oct 12, 2006 10:38 pm
All of the information in Bill is also in BillExpenseLine. If you go to www.qodbc.com <http://www.qodbc.com/> to their help desk, and search on "INSERT" you...
1292
Rod Lewis
ddprlewis
Dec 6, 2006 5:13 am
I am using the QODBC driver that comes with QB Enterprise. I'm trying to automate the process for an unattended operation. I have assigned the specific...
1293
Chuck Vigeant
txbtech
Dec 6, 2006 5:37 am
(1) Get everybody out of QB (2) Go into QB>Edit>Preferences>Integrated Applications. Remove any ODBC listings. (3) Go to your directory where the QB file is...
1294
Robyn Zelickson
robyn_renwick
Dec 6, 2006 6:46 am
Hi Rod, I emailed you. First question I would have would be which version of the driver are you using? Were you logged in as Admin when you set up unattended...
1295
Rod Lewis
ddprlewis
Dec 7, 2006 3:04 am
Chuck, Your suggestion worked for one company. For another I had to do what they suggested on the QODBC site (moving all related files except for the QBW)....
1296
Chuck Vigeant
txbtech
Dec 7, 2006 8:12 am
Probably the .lgb file. The .ND file is a configuration file, that usually doesn't need to be removed, but just remember to rename them to .old I never like...
1297
praefex
Jan 4, 2007 2:40 am
Warning: odbc_exec(): SQL error: [QODBC] Error: 3170 - There was an error when m odifying a ItemService. Cannot use SalesOrPurchaseMod aggregate when the item...
1298
Chuck Vigeant
txbtech
Jan 4, 2007 5:52 am
You will have to provide a loop to check for which Price "field" is applicable to that item. If an item is performed or bought from a subcontractor it changes...
1299
sjdeetz
Jan 9, 2007 8:55 pm
A client of mine purchased a QODBC license for V. 6 Read/Write in August of 2006. They never installed and the secretary never notified me until today that...
1300
Matt Babineau
praefex
Jan 9, 2007 9:08 pm
Are they running QB 2007? I ran into this problem. Basically QODBC 6 will work with all versions of QB up to 2006. QODBC 7 will work with versions up to 2007. ...
1301
sjdeetz
Jan 10, 2007 6:32 pm
Matt, No they are running 2006. They did an upgrade last summer. Steve ... will ... versions up ... sure to not ... how... ... expired....
1302
Matt Babineau
praefex
Jan 10, 2007 7:48 pm
This doesn't work: SELECT * FROM Item WHERE Type != 'ItemService' This does work: SELECT * FROM Item WHERE Type = 'ItemService' Am I building this query wrong?...
1303
Matt Froncek
matt_froncek
Jan 12, 2007 9:23 pm
Try: SELECT * FROM Item WHERE Type <> 'ItemService' Matt Froncek QODBC Development Support / FLEXquarters.com LLC Consultant QODBC Driver for QuickBooks -...
1304
Robyn Zelickson
robyn_renwick
Jan 12, 2007 10:29 pm
Not sure what you're using to run the query, but in Access you have to say: SELECT * FROM Item WHERE Type<>'ItemService'; ... From: Matt Babineau To:...
1305
Matt Babineau
praefex
Jan 13, 2007 1:52 am
Awesome...that makes sense. I've been in MySQL too long! Thanks, Matt Babineau Criticalcode 858.733.0160 matt@... http://www.criticalcode.com...
1306
Robyn Zelickson
robyn_renwick
Jan 13, 2007 5:13 am
Yup, how soon we forget! Glad it helped.. take care, robynz ... From: Matt Babineau To: qodbc@yahoogroups.com Sent: Friday, January 12, 2007 06:50 PM Subject:...
1307
virtualjosemx
Jan 14, 2007 12:29 pm
Hi, I have to Udpate all the accounts number of Chart of Accounts. Even do I'm Using QODBC Read/Write I can not update any account and I do not know why, I...
1308
virtualjosemx
Jan 14, 2007 1:09 pm
... So far I had to create a small routine to open and close windows as well as adding the charaters require for the account format update. It does work but it...
1309
Matt Froncek
matt_froncek
Jan 15, 2007 5:00 am
What version of QuickBooks are you using? QODBC uses the Intuit SDK and Account information was not updatable until QuickBooks 2007. Matt Froncek QODBC...
1310
Jose Moreno
virtualjosemx
Jan 15, 2007 8:01 am
That answer my question. We are using Pro Version 2006 Thank you! ... From: Matt Froncek <matt@...> To: qodbc@yahoogroups.com Sent: Sunday, January 14,...
1311
odakcm
Mar 21, 2007 9:32 am
I have a VB.NET application that "select * from <table> " succesfully from all the QBOE tables EXCEPT (Invoice, InvoiceLine, InvoiceLinkedTxn). I am using the...
1312
Jose Moreno
virtualjosemx
Mar 21, 2007 7:41 pm
Hi Fellow Programmer, I did used QODBC for one of my projects and it did fulfill all of my client needs. But it we were lucky cause we were working all around...
1313
Brad Waddell
flexq
Mar 21, 2007 9:35 pm
Our technical support system is best staffed by those who can help with this question, please see the FAQ search and support ticket system for help on this...
1314
odakcm
Mar 22, 2007 6:26 pm
Thanks for the replies. I understand I am running into the QBOE 1000 row result set limit. I could break up the select into groups of < 1000, but first I need...
1315
Matt Froncek
matt_froncek
Mar 22, 2007 6:35 pm
Kevin, That should be handled correctly inside the driver if you have the version 7.x driver. It is free to download the most current evaluation. The only time...
1316
Robert Noche
rnoche
Mar 22, 2007 6:37 pm
Use transaction date as a qualifier. Test with VBdemo to eliminate SQL statement errors from programming errors. I was able to create good transactions with...
1317
odakcm
Mar 22, 2007 7:10 pm
Version 7.00.00.207 Evaluation Copy SELECT COUNT(*) FROM INVOICE returns 0 ... version ... only ... inside of ... <http://www.qodbc.com/> ... Behalf Of ... ...
1318
Brad Waddell
flexq
Mar 23, 2007 7:34 pm
limit by date range so the result set can fit under the 1000 transaction limit imposed by QBOE. ... QODBC Driver for Quickbooks - Interactive QuickBooks data...
1319
sdoerrer
May 12, 2007 9:50 pm
Hi! Quick question that I thought I could find either at qdeveloper.com or qodbc.com.au, which seem to be more active but also seem to be down right now. I'm...
