Stack Overflow
Stack Overflow

Questions tagged [qodbc]

ODBC driver for connecting to QuickBooks data

Link to QODBC site

47 questions
10
votes
3 answers

Connection forcibly closed while executing the subqueries in the QuickBooks online ODBC driver connection

I am using the trial version of QuickBooks Online ODBC (QODBC) driver and configured the DSN named QuickBooks Online Data as well as QuickBooks Online Data QRemote I have ensured the connection using the test tool and I am able to execute the SQL…
Janakiraman
  • 121
  • 4
4
votes
0 answers

How to pass args into a class to create instance of Python Singleton pattern wrapper for PyODBC?

Looking for examples of class patterns people use to wrap PyODBC, I found this example here at SO: single database connection throughout the python application. I don't understand how the DBConnection class works in the original example. How is…
xtian
  • 2,765
  • 7
  • 38
  • 65
3
votes
1 answer

Parameterize pyodbc connect string using keyword arguments from my qodbc API?

Help me to understand if I can parameterize my connection string for a pyodbc connection to this qodbc interface for QuickBooks: pyodbc.connect(r'DSN=qremote_dsn;IPAddress=192.168.0.50;Port=4500;RemoteDSN=login_dsn;OpenMode=F;OLE DB Services=-2;',…
xtian
  • 2,765
  • 7
  • 38
  • 65
2
votes
0 answers

Company ID not found issue occurs while connecting QuickBooks online ODBC driver

I have installed the trial version of the QuickBooks Online ODBC (QODBC) and configured the DSN named “QuickBooks Online Data” as well as "QuickBooks Online Data QRemote" I have ensured both the connection using the test tool and I am able to…
Janakiraman
  • 121
  • 4
2
votes
0 answers

Insert QODBC from C #

I am trying to insert data into the "Transaction" table of Quickbooks through QODBC but I receive the following error: System.Data.Odbc.OdbcException: 'ERROR [42S00] [QODBC] Data type mismatch for one or more field. Invalid operand for operator:…
Javier
  • 121
  • 3
1
vote
1 answer

QODBC connecting to Python

I am using QODBC Driver to connect to my Quickbooks Data. Until now, I was the QODBC directly in Power BI/Excel and QODBC works perfectly fine there. But today, I tried to connect to QODBC using python and it is giving me the following error The…
Mayank
  • 93
  • 1
  • 9
1
vote
1 answer

Access Database - QODBC Driver Execute Grant On Admin

When attempting to execute the following statement with my .accdb file: grant select on MSysObjects to Admin; I get the following information back from QSqlError::text(): encountered SQL Error [[Microsoft][ODBC Microsoft Access Driver] Cannot open…
D. Foley
  • 1,034
  • 1
  • 9
  • 23
1
vote
0 answers

Why do I keep receiving the issue Run-time "3155" in QODBC?

Why do I keep receiving the issue Run-time "3155" ODBC -- insert on a linked table 'New_Invoice' failed. At least one line record is required. Is there an issue with my InvoiceLine Query? The following is my code: I have a button that executes these…
user10957443
1
vote
1 answer

How to parameterize datestamp in pyODBC query?

I'm using pyodbc together with QODBC to construct an ODBC query. I'm having trouble inserting datestamp parameters. Here you can see the escalation starting from the literal version (1) to string-format version (2) to error-state versions. (Note…
xtian
  • 2,765
  • 7
  • 38
  • 65
1
vote
1 answer

Quickbooks - migrate import IIF to QODBC

I'm trying to migrate my actual logic to import invoices into Quickbooks using QODBC tool, and I'm having trouble finding the relationship of the columns of the IIF file with the columns of the DB. Here is the header of my IIF file !TRNS TRNSID …
esteban
  • 102
  • 1
  • 7
0
votes
2 answers

SSIS Ado.NET Source With Expression Fails Validation

I have a weird problem where I have a control flow like so: And at the end a data flow like so: I am trying to read data from a QuickBooks Desktop file but to make sure I don't unnecessarily run the Data Flow task, I first compare the modified…
Coda759
  • 107
  • 14
0
votes
1 answer

MS Access rst.MoveNext not Moving to next record

I am using the code below to run through a table of payments and apply those payments to available balances. I keep having trouble where it will not move to the next payment. Sometimes it will loop through payments, most times it will try to run the…
Kode
  • 1
  • 1
0
votes
0 answers

Can I configure NSSM to run my python script from a non-elevated/admin shell?

I've installed NSSM to run some maintenance Python scripts over ODBC to QuickBooks (using QODBC Driver for QuickBooks). NSSM site says it's running with elevated/admin privileges: "Danger Will Robinson! nssm requires administrator access to your…
xtian
  • 2,765
  • 7
  • 38
  • 65
0
votes
0 answers

Why does my PyODBC parameterized date query return too much data?

I have a QODBC query for QuickBooks that generates Profit & Loss report with dynamic columns. The parameterized date value works to return the requested three daily values, AND 300+ more columns of None! sql1 = textwrap.dedent(""" sp_report …
xtian
  • 2,765
  • 7
  • 38
  • 65
0
votes
0 answers

Can I assign column names to SQL query with dynamic columns?

I'm a noob at SQL. Sorry if my title isn't correct; Here's the problem: I have a QODBC [1] query for QuickBooks that generates Profit & Loss report with dynamic columns: sp_report ProfitAndLossStandard show "Text", "RowType", …
xtian
  • 2,765
  • 7
  • 38
  • 65
1
2 3 4