Stack Overflow
Stack Overflow

Questions tagged [qodbc]

ODBC driver for connecting to QuickBooks data

Link to QODBC site

47 questions
0
votes
1 answer

SSIS ADO.NET Source - SQL Command Query Error

I have a problem where I try to read some data from QuickBooks Desktop file in SSIS through ADO.NET Source using QODBC driver. Driver is set up correctly, because I am able to preview table contents of the file like so I am also successful in using…
Coda759
  • 107
  • 14
0
votes
1 answer

QODBC Online linked server to SQL server has empty tables - no data

I have a linked server from SSMS to Quickbooks through QODBC Online. I have run the QODBC Setup Screen and connected to the desired client. The query runs but returns no data. it shows all the column names but no data. am I missing a step? created…
Matt Steverson
  • 1
  • 1
0
votes
1 answer

SQL Server QODBC linked server to QuickBooks keeps showing dozens of duplicate empty databases?

I have a SQL Server Express installed locally on my computer that I'm trying to (stably) connect to a local QuickBooks Enterprise file using QODBC. (Yes the SDK is a better option but we're still running 32bit Quickbooks and all our other programs…
G Alvidrez
  • 3
  • 3
0
votes
1 answer

Excel Query (QODBC / QuickBooks) Question: Is it possible to query an sp_report (in excel) and have 2 sets of amount columns?

For example, I am querying the trial balance sp_report and would like to have debit/credit columns for the current year and another set of debit/credit columns for the prior year. Current code is: sp_report TrialBalance show AccountType, Label,…
Hank Hillyup
  • 9
  • 1
0
votes
1 answer

QODBC - Email Sent Date

I'm using QODC, Just trying to find if anyone knows where the data is stored for the history of the Estimate "Sent Date" or if there is a way to get this from Quickbooks desktop into SQL. I have been through the tables and cannot see this as record…
Alex Wells
  • 1
0
votes
1 answer

Access QuickBooks with QODBC and Powershell

I am running QuickBooks Premier 2019 (Desktop) on a Windows 10 64 bit computer. I installed QODBC. I tried running the Powershell script below provided at the flexquarters website. I get this error: Exception calling "Open" with "0" argument(s):…
Fairfielder
  • 11
  • 1
0
votes
1 answer

QT Login Timeout expired QODBC3:Unable to connect ERROR

I am trying to connect my SQL Server to the qt project with this code QString servername = "OLI-PC"; QString dbname = "Translator"; QSqlDatabase db = QSqlDatabase::addDatabase("QODBC"); db.setConnectOptions(); qDebug()<<"Dupa connection…
Alex Olaru
  • 1
0
votes
1 answer

Is there a way to ignore mapping errors in SSIS?

I have a data flow in SSIS that's using an ODBC Source to a conditional split. The source returns a dynamic set of columns dependent on availability of data in the source - the number of columns goes from 1 to 13. In my conditional split I have it…
Channing
  • 129
  • 2
  • 12
0
votes
1 answer

QODBC Assembly Inventory By Site

We are trying to get assembly inventory levels by site. ItemInventoryAssembly has the total but not divided by site. ItemSites, which offers inventory by site, does not include assembly items. However, the following xml request (ItemSiteQueryRq)…
aFast
  • 131
  • 1
  • 7
0
votes
1 answer

Error Connecting QODBC to MySQL through migration wizard

I am currently attempting to migrate my QB Data through QODBC to my MySQL server, however I have run into the following error: Starting... Connect to source DBMS... - Connecting to source... Connecting to ... Opening ODBC connection to…
Metalmine
  • 71
  • 1
  • 7
0
votes
1 answer

How do I fix Run-Time error '5' in .CommandText Array(... SELECT ....) statement

I am retrieving customers last month monthly recuring charges from QuickBooks into Excel sheet, using QODBC driver. It is working OK, until I add one more field from the Customer record. It fails with run-time error '5': Invalid procedure call or…
marian
  • 1
  • 1
0
votes
0 answers

How can I run this SQL script in VBA after the first one succeeds?

I currently have this SQL query: INSERT INTO InvoiceLine (InvoiceLineItemRefListID, InvoiceLineDesc, InvoiceLineRate, InvoiceLineAmount, InvoiceLineSalesTaxCodeRefListID, FQSaveToCache) VALUES ('80002436-1519061496', 'Building permit 1', 1.00000,…
user10891568
0
votes
1 answer

Why do I get a SQL syntax error "Expected lexical element not found: =)"?

Why do I keep getting a SQL syntax error: Expected lexical element not found: =) The following is my code: I can't seem to find where the syntax error is Dim oConnection Dim oRecordset Dim sMsg Dim sConnectString Dim sSQL customer =…
user10891568
0
votes
1 answer

Trouble exporting invoices from Access to QuickBooks with form

I am currently filling out all of my invoice information in Access, does anyone have experience with exporting this info right into QuickBooks invoices? Here is an image what I currently have: All I need now is to transfer this information to…
user10891568
0
votes
1 answer

Errors when inserting date and time into QODBC query C#

I am getting an error ERROR [42500] ERROR: 3020 - There was an error when converting the date value "0000-00-48. In the field "salesOrder Transaction Date The date value I am trying to insert is 4/4/2018. My code DateTime JobDate =…
Squaddy
  • 11
  • 2
1
2
3 4