The situation: I have an xml file containing pricing information that is recalculated by my application. I then need to sync using qodbc this information to...
1498
vostro420_301
Nov 7, 2011 6:23 pm
... How do turn off the optimizer in a connection string?...
1499
deepan
deepan12ece
Nov 23, 2011 8:44 am
Upgrade Quick Book to 12.0 Enterprise will affect QODBC...
1500
eamesian
Nov 23, 2011 8:44 am
I am trying to use the free read-only QODBC that is included with QuickBooks 12 (which we just installed on this PC.) When I try to pull up a table in Access,...
1501
Brad
flexq
Nov 23, 2011 8:52 am
go to the QODBC setup screen and download the latest version - should fix the issue. QODBC version must be equal to or higher than QuickBooks version number. ...
1502
Brad
flexq
Nov 23, 2011 8:54 am
if you are using the included "read-only" version of QODBC, all that is required is to download a new copy of QODBC from the setup screen. If using any of the...
1503
Fola
phlayky
Nov 25, 2011 7:24 pm
We have QODBC installed on our main Quickbooks server. We have a small application that uses the QODBC DSN connection to connect to QuickBooks. Will it be...
1504
Brad
flexq
Nov 25, 2011 7:36 pm
Fola, Yes, we do have a component built in to QODBC called Qremote which lets multiple users share a single connection to QuickBooks without having to have...
1505
None
scott.wheeler
Nov 30, 2011 7:42 pm
Greetings, I'm just getting started with the QODBC driver and am curious to know if it is possible to do complex joins with mulitple tables. Thanks, Scott...
1506
jeffrholton
Dec 1, 2011 4:38 pm
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...
