I'm trying to set up QODBC for the first time and receiving a QB COM Error = 80040154. A little history, we're using Quickbooks 2010 and I've installed the...
1366
julio
hawk1878
Aug 5, 2010 11:31 pm
Please forgive me as I just recently started playing with the ODBC driver again and I'm no programer. Iam trying to pull Estimate data into Excel which is easy...
1367
Brad
flexq
Aug 5, 2010 11:32 pm
you have to have QuickBooks application installed on a machine for QODBC to communicate with the QuickBooks SDK - it is an application layer interface which is...
1368
Brad
flexq
Aug 5, 2010 11:39 pm
i assume you are using excel to extract the data using QODBC, any excel expert or book on excel should be able to show you how to subtotal a column. you can...
1369
Matt Froncek
matt_froncek
Aug 6, 2010 2:48 pm
The term you need to know is Group by. That should be an option in MSQuery Tool. SELECT Sum(EstimateLineAmount) FROM EstimateLine GROUP BY TxnID From:...
1370
datasplicellc
Aug 6, 2010 5:54 pm
Sorry for the late reply Brad and thank you for your response. So, that's working, but now I get the mscorwks.dll error. I already have netfx20sp2 installed....
1371
Brad
flexq
Aug 6, 2010 5:57 pm
i would raise a ticket on our support system for that issue, our support people are better qualified: support.FLEXquarters.com - thanks! brad ... -- Brad...
1372
shirley72008
Aug 13, 2010 12:45 am
I am using ACCESS 2007 AND QODBC (QB Enterprise 2010 release 7) to prepare a report - We are using an sp_report CheckDetail with a cleared status field and...
1373
Brad
flexq
Aug 13, 2010 12:56 am
shirley QuickBooks sends data to QODBC by amazingly large XML statements when you have so many records. This can cause QuickBooks to crash for any SDK ...
1374
shirley72008
Aug 13, 2010 9:45 pm
Brad, Thank you for responding to my post yesterday, but I have a few more questions. 1. Part of our query is an sp_report. When QODBC reloads all data for...
1375
Brad
flexq
Aug 13, 2010 9:49 pm
shirley sp_reports cannot be optimized, they are reports run withing QuickBooks and will have different results depending on the parameters you use. if the ...
1376
shellie950
Aug 13, 2010 9:58 pm
When using the VD Demo 32 or other application with QODBC only one record is being returned when there are multiple records. SELECT name, isactive,...
1377
Brad
flexq
Aug 13, 2010 10:05 pm
this is our support system for posting a ticket: http://www.qodbc.com/faq but i would say offhand to make sure you are the same QuickBooks user in QODBC as you...
1378
shellie950
Aug 13, 2010 10:25 pm
Hi Brad, Turning off the optimizer did the trick. Thank you!!...
1379
shirley72008
Aug 15, 2010 4:58 am
Brad, The sp_report I would need to pull into Access 2007 as a loaded table is as follows: sp_report CheckDetail show TxnType, TxnID, RefNumber, Date, Name,...
1380
Brad
flexq
Aug 15, 2010 5:26 am
shirley i'm not an expert on MS Access, i think what you want is a SQL pass-thru query. you might try posting this question on an Access support forum, or you...
1381
Cesar
cparralesl
Aug 15, 2010 10:14 pm
Shirley, First, you have to decide if you want yo have it using VBA code or use a simple Pass-Through query. Whatever you decide, i give you an idea on how to...
1382
shirley72008
Aug 16, 2010 6:42 pm
Hi Brad and Cesar: Still having trouble. What I am trying to do is link two QuickBooks tables to the sp_report(QuickBooks) - run the query and build a report...
1383
Cesar
cparralesl
Aug 17, 2010 2:39 am
Hi There are some other changes you have to made. In the next code, I wrote comments along the instructions you have to take note. I did not test it, since i...
1384
shellie950
Aug 18, 2010 9:55 pm
When I try to limit the results of a query with a bind variable I receive an error [Microsoft][ODBC Driver Manager] SQL data type out of range. Any ideas?...
1385
Cesar
cparralesl
Aug 19, 2010 4:12 pm
Post your Sentence and variables you are declaring....
1386
shellie950
Aug 19, 2010 9:48 pm
... select EmployeeEarning.Name, EmployeeEarning.HiredDate from QODBC.EmployeeEarning EmployeeEarning where EmployeeEarning.Name = [SelectEmployee] Where...
1387
stephanviljoen@...
stephanviljo...
Sep 8, 2010 7:18 pm
HI There, The VBscript demo that comes with the driver seems to be working fine but I'm unable to access Quickbooks through PHP. Here's my Setup. OS: Windows 7...
1388
Brad
flexq
Sep 8, 2010 7:20 pm
stephan make sure you are using the server edition of QODBC if you want to access it via a system service. Test this by using PHP interpreter at the Windows ...
1389
stephanviljoen@...
stephanviljo...
Sep 9, 2010 7:12 am
Hi Brad, Thanks for the reply , it says : Evaluation QODBC Server Edition 2011 UK under the about tab... Is this the correct version? Also , does the driver...
1390
Brad
flexq
Sep 9, 2010 7:15 am
steph, that sounds like the correct version - contact your dealer if you are unsure. It does run under Windows 7 with 32 bit applications. is PHP 64 bit? try...
1391
stephanviljoen@...
stephanviljo...
Sep 9, 2010 7:42 am
Brad, Everything is 32Bit , Windows , apache and PHP. I don't really have a dealer as I've discovered your software through google. I've also logged a few...
1392
Brad
flexq
Sep 9, 2010 8:11 am
not that i know of - windows 7 does make it difficult for system service applications to communicate, hence the need for a new solution - our support person...
1393
stephanviljoen@...
stephanviljo...
Sep 9, 2010 8:17 am
Which Windows OS works the best with your driver? I'm not really set on using windows 7 , it was just something I had installed.. I have Windows 2003 Server /...
1394
Brad
flexq
Sep 9, 2010 8:22 am
i can't say for sure but i think you will have much better luck with XP or server 2003 - there are tutorials on how to setup in these systems. 7 and especially...
