RSS Feed
Knowledgebase : QODBC > Microsoft Products
TROUBLESHOOTING - GETTING ERROR INVALID AUTHORIZATION SPECIFICATION IN SQL SERVER. PROBLEM DESCRIPTION: I am trying to create Linked Server on SQL Server. VB DEMO connects successfully to QREMOTE on QuickBooks Server. Setting up the Linked server - I...
TROUBLESHOOTING - PERFORMANCE ISSUE VB DEMO VERSUS MY C# APP. PROBLEM DESCRIPTION: I am running the same query on both returns a big difference. The VB Demo app takes around 7 seconds and my C# app takes 1:20 minutes. Are there any settings which I ne...
TROUBLESHOOTING - RUNTIME ERROR (28) WHEN USING WINDOWS XP, BUT NOT WINDOWS 2000. PROBLEM DESCRIPTION: We have four machines using the ODBC driver with QuickBooks and Access 2003 that work perfectly fine. The odd machine is a slightly higher version of ...
TROUBLESHOOTING - HOW TO FIND ITEM NOT SOLD AFTER A CERTAIN DATE AND MARK IT AS INACTIVE. PROBLEM DESCRIPTION: We would wish to make items that have not sold after a certain date inactive. Is this possible? If so, any help would be appreciated. SOLUTI...
TROUBLESHOOTING - HOW TO CHANGE CONNECTION STRING STORED IN EXCEL PROBLEM DESCRIPTION:  I have changed setting in QODBC Setup Screen from Open mode to same as company file but my Excel still does not takes the changes and needs company file to be in mul...
SAMPLE VB.NET SOURCE CODE FOR INSERTING INVOICELINE INTO EXISTING INVOICE SAMPLE APPLICATION: Please click here [http://support.flexquarters.com/esupport/newimages/INVC/QODBC-Invoice-Insert-Sample-VB.zip] for downloading Sample Code. Please refer be...
SAMPLE VB.NET WEB APPLICATION FOR INSERTING INVOICELINE INTO EXISTING INVOICE SAMPLE APPLICATION: Please click here [http://support.flexquarters.com//support.flexquarters.com/esupport/newimages/INVCW/QODBC-Invoice-Insert-Sample-Asp.net-VB.zip] for down...
HOW TO EXPORT QUICKBOOKS INVOICES INTO MS ACCESS REPORT FORMAT PROBLEM DESCRIPTION: I would like to know if QODBC will convert QuickBooks Pro Desktop invoices into Microsoft Access. The attached invoice is similar to what we need to export to Access...
HOW TO EXPORT QUICKBOOKS INVOICES INTO MS EXCEL REPORT FORMAT PROBLEM DESCRIPTION: I would like to know if QODBC will convert QuickBooks Pro Desktop invoices into MS Excel Report. The attached invoice is similar to what we need to export to MS Excel...
TROUBLESHOOTING - "TRANSACTIONS" TABLE, BUT THEY DON'T APPEAR TO "BALANCE" PROBLEM DESCRIPTION: I am attempting to extract data from a client's hosted QuickBooks Enterprise system. I need every transaction in the system as we are transitioning to a dif...
USING OPTIMIZER OFF FOR SELECTED TABLES IN MS-ACCESS LINKED TABLE PROBLEM DESCRIPTION: I am using QODBC access QuickBooks Data. I have linked all QuickBooks tables using QODBC. I want to use Customer table to be Optimizer OFF and rest of the tables t...
TROUBLESHOOTING - GETTING ERROR A FOUR-PART NAME WAS SUPPLIED, BUT THE PROVIDER DOES NOT EXPOSE THE NECESSARY INTERFACES TO USE A CATALOG OR SCHEMA. PROBLEM DESCRIPTION: I am using QODBC to fetch QuickBooks Data in SQL Server. I have created Linked S...
TROUBLESHOOTING - [FIXED] MICROSOFT EXCEL/ACCESS 365/2016 - INVALID CERTIFICATE ERROR/DIGITAL SIGNATURE ERROR/CERTIFICATE ERROR/GETTING INVALID CERTIFICATE ERROR WHEN TRYING TO CONNECT USING MS ACCESS OR EXCEL PROBLEM DESCRIPTION: I am using QODBC to e...
TROUBLESHOOTING - GETTING ERROR WHEN TRYING TO CONFIGURE QODBC IN SQL SERVER PROBLEM DESCRIPTION: I'm trying to install the QODBC on our SQL Server, and I followed all steps in your documentation How to create Link Server with MS SQL 2005/2008/2012 64-...
TROUBLESHOOTING - QREMOTE FOR QUICKBOOKS NOT LISTED AS CHOICE IN ODBC SETUP SCREEN PROBLEM DESCRIPTION: I am trying to set up the QODBC Driver on a machine running Windows Server 2016. Previously, I have had it set up and working fine on my local Windo...
TROUBLESHOOTING - HOW CAN I COMBINE TWO REPORTS AND GET THE REPORT OF TRANSACTIONS OF A CUSTOMER. PROBLEM DESCRIPTION: I need a report by particular customer showing the beginning balance, payments made by the customer, invoices with details showing th...
TROUBLESHOOTING - HOW TO USE PROMPTED DATE RANGES IN MS EXCEL WITH SP_REPORTS PROBLEM DESCRIPTION: I am using QODBC for exporting QuickBooks reports in MS Excel. I am using BalanceSheetStandard report for specific date ranges as below. sp_report Bala...
TROUBLESHOOTING - EXCEL ONLY RETURNING AMOUNT_1 AND NOT AMOUNT_1 THROUGH AMOUNT_12. PROBLEM DESCRIPTION: I am working in Excel, I have set up 3 pass-through queries and had them working to reference cells in for DateFrom and DateTo parameter. The queri...
HOW TO CREATE SP_REPORTS USING MICROSOFT EXCEL HOW TO EXTRACT SP_REPORTS USING MICROSOFT EXCEL OPEN MICROSOFT QUERY IN EXCEL Open Microsoft Excel, get external data from Microsoft Query via Data Menu -> "Get Data -> From Other Sources->From Microsoft...
TROUBLESHOOTING - HOW TO CONVERT MS OFFICE FROM 64-BIT TO 32-BIT PROBLEM DESCRIPTION: I am on Windows 64-bit and Office 365 64-bit. VB Demo works fine when I use QuickBooks Data as connection source. If I use QRemote I get the "Evaluation Expired. QR...