We are currently on SQL server 7. Will I be able to use QODBC?...
1507
kmfstudios673
Dec 7, 2011 5:33 am
I'm trying to rollout some new code that writes monthly sales receipt data to QB. The problem being, I need to write ~4000 lines to QB and each one is taking...
1508
Brad
flexq
Dec 7, 2011 5:41 am
conor you don't mention the size of your QuickBooks company file - try testing against an empty file and see if it makes a difference. you could also archive...
1509
dkrumholz
Dec 16, 2011 4:58 pm
When running the VB test app only 10,000 records are returned from my customer file. Is that just a limitation to the VB app or is there a limit to the number...
1510
rajendra420
Dec 16, 2011 5:05 pm
Hi, QODBC does not have a limitation of 10,000. 10,000 record limit is on VB Demo. VB Demo is designed to show limited records, VB Demo is an application to...
1511
rajendra420
Dec 16, 2011 5:44 pm
Hi, I would like to also add that single queries larger than 10k are not recommended because QuickBooks has to allocate memory for the entire result of the...
1512
kevindurflinger
Dec 16, 2011 8:14 pm
Is there any way to define and/or access Custom Fields. For example if I wanted to create a customer account number. Could I do so when inserting a new...
1513
kmfstudios673
Dec 20, 2011 7:52 am
I'm trying to break a bunch of queries (~4000) into batches of 200. My process is: Insert a row into SalesReceiptLineItem run sp_optimizeupdatesync...
1514
kmfstudios673
Dec 20, 2011 7:52 am
Brad, Thanks for the response. Unfortunately, exporting old data out of the company file isn't really an option at the moment. Our company file is about...
1515
Brad
flexq
Dec 20, 2011 8:09 am
sounds like something you should post to our support board, offhand i'd suggest turning off caching for this operation, or try blocks of 50, memory can be an...
1516
Brad
flexq
Dec 20, 2011 8:12 am
conor i did not ask you to take data out of your company file, i asked you to test if the file size is an issue by starting with an empty database copy. for...
1517
bryanlawrie
Dec 21, 2011 9:40 am
I have connected Excel to the Txn table. It downloads all the transaction data but when producing a monthly pivot report to create trial balances, I note that...
1518
Brad
flexq
Dec 21, 2011 9:44 am
sure, there is a trial balance report built in to QODBC using sp_reports function. Keep in mind that QuickBooks does not provide the rules for creating such...
1519
jmchenry81
Dec 21, 2011 3:44 pm
Hello, We've been using qodbc for about 3 years now on server 2003 with no issues. I have a new server setup (server 2008 x64 hyper-v), quickbooks enterprise...
1520
Brad
flexq
Dec 21, 2011 3:47 pm
the 64 bit world and the 32 bit world are line a chinese wall - no crossing it! ! looks like your VBS scripts are running in 64 bit mode - try running them...
1521
jmchenry81
Dec 21, 2011 4:12 pm
I figured it was something like that... Used wscript from the syswow64 directory... now see this error: [QODBC] QB Begin Session Failed. Error = 80040408,Could...
1523
Brad
flexq
Dec 21, 2011 4:13 pm
get QuickBooks started, then try it. this is also a 64 bit issue, especially on terminal services OS. brad ... -- Brad Waddell, Managing Director ...
1524
jmchenry81
Dec 21, 2011 4:59 pm
QB itself runs fine... I've tried with UAC enabled and disabled. Everything was installed and begin testing using default UAC settings. I just now disabled UAC...
1525
Brad
flexq
Dec 21, 2011 5:02 pm
so - i'm not clear - you get this same error when QuickBooks is running with no company file open? brad ... -- Brad Waddell, Managing Director FLEXquarters.com...
1526
jmchenry81
Dec 21, 2011 5:31 pm
In the ODBC setup I have the QB file set for unattended exports, we only access one file during our nightly export. After a reboot, I believe I just have to...
1527
Brad
flexq
Dec 21, 2011 5:39 pm
i'm having difficulty getting an answer from you - i think you should probably post to our support forum. they can run a test for you using similar software. i...
1528
jmchenry81
Dec 21, 2011 5:49 pm
Yes, The error was the same with QB open. I am waiting for our president to input the admin password for the QB file that qodbc accesses to give permissions to...
1529
Brad
flexq
Dec 21, 2011 6:25 pm
ok. this can sometimes happen if you have multiple versions of QuickBooks on the same machine as well - it does not know which one to start. brad ... -- Brad...
1530
jmchenry81
Dec 21, 2011 6:29 pm
Nope, clean virtual machine with QB Enterprise 12.0 fresh install.. Still waiting for the password......
1531
jmchenry81
Dec 21, 2011 8:27 pm
It seems to be working so far. If any errors occur over tonight's export, I'll let you know. Thanks for your help!...
1532
dvera73
Dec 24, 2011 5:34 am
I download the trial version of QODBC Driver For QuickBooks Point Of Sale which I read that "QuickBooks Point Of Sale Versions Supported QODBC Driver for...
1533
Donald
don.sizemore
Jan 12, 2012 5:08 am
We have custom fields in our items table. If you double click on an item there is a custom fields are where you can add fields. There is probably other areas...
1534
skrutherfordii
Jan 17, 2012 6:04 pm
Has anyone tried doing inventory adjustments using qodbc?...
1535
Rajendra Dewani
rajendra420
Jan 18, 2012 8:56 am
Hi INSERT INTO InventoryAdjustmentLine (AccountRefListID, ...
1536
Sam Rutherford
skrutherfordii
Jan 18, 2012 4:50 pm
Thanks, Raj. Exactly what I needed. Sam ________________________________________________________________ ... ...
