<![CDATA[FLEXquarters.com Limited]]> <![CDATA[[QODBC-Online] - Troubleshooting - Unable to connect to QuickBooks Online when using a new QODBC Online 64-Bit DSN]]> Troubleshooting - Unable to connect to QuickBooks Online when using a new QODBC Online 64-Bit DSN

Problem Description:

I have installed QODBC Online build 358.

I can connect to the QuickBooks Online company file using QODBC Online 32-bit DSN.

I have created a new QODBC Online DSN 64-Bit.

When I am trying to connect to the QuickBooks Online company file using QODBC Online 64-Bit DSN, on the browser, it says connected, but the DSN still shows "Connect to QuickBooks," and it does not connect.

Sometimes the DSN window disappears.

 

Solution:

 

Updates (2025-05-30):

We are currently working on fixing the issue, and we will soon release a new build.

 

 

The issue is limited to when using the new QODBC Online 64-bit DSN.

If you are using a single QuickBooks Online company file, you can use "QuickBooks Data Online" from a 32-bit system.

Once you connect to your QuickBooks Online company file using a 32-bit "QuickBooks Online Data" DSN, this will automatically update your "QuickBooks Online Data" 64-bit.

You should be able to use "QuickBooks Online Data" 64-bit.

 

If you wish to create your own QODBC Online DNS, you can use one of the following workarounds.

 

Workaround 1:

 

Use QODBC Online 32-bit DSN, connect to the QuickBooks Online company file.

Once connected, export the connection key from the 32-bit.

 

Export your connection key – Start >> QODBC Driver for QuickBooks Online >> General tab >> Click on the "Export Connection key" button. Save the connection key file.

 

Import the exported connection key to your 64-bit DSN.

To import your QODBC Online connection key, go to Start >> QODBC Driver for QuickBooks Online >> General tab >> click on the "Import Connection key" button.

 

Please test the reported issue & share the outcome.
 
 
Workaround 2:
 
You can downgrade your QODBC Online driver from build 358 to 357. 

Please raise a support ticket and request QODBC Online build 357.

Click here to raise a support ticket.

 
]]> <![CDATA[Solved: [QODBC-Desktop] Troubleshooting - Unable to change the default configuration of newly created QODBC DSN - Build 348]]> Solved: [QODBC-Desktop] Troubleshooting - Unable to change the default configuration of newly created QODBC DSN - Build 348

Issue:

We created a new QODBC 32-Bit DSN with the name "QODBC-MyCompany.

The DSN was created successfully.

We tried to change the "Mode when opening" to "Single-user Mode" or "Multi-user Mode," applied the changes, and closed the QODBC Setup Screen.

The changes are not saved.

We tried changing the company file path, but the same issue.

 

Reason:

We have identified the issue and are currently working on the fix.

The issue is limited to the QODBC Desktop build 348.

 

Solution:

Please download and install the QODBC build 349 or above. - https://qodbc.com/download/desktop

 

Workaround:

Create a new QODBC 64-Bit DSN with the same name as your QODBC 32-Bit DSN.

After creating a 64-Bit DSN of the same name, you can apply the changes to your 32-Bit DSN.

Please raise a support ticket with us if you do not wish to apply the above workaround. We will help you with downgrading QODBC to build 345 or 346.

Click here to raise a support ticket.

]]> <![CDATA[[QODBC-Desktop] Troubleshooting - Auto Login as Service and Syncing tables to SQL Server]]> Troubleshooting - Auto Login as Service and Syncing tables to SQL Server

Problem Description:

So the QODBC works excellently running on the machine. We intend to integrate into our website / Intranet to create customers or make changes from the web. I noticed QuickBooks needs to be logged in and open to function. Is there a server version that will not require a user to log in or pass the info along automatically, so the website continues to function correctly?

Is there a way to try the server version by syncing to the SQL server? I need to be able to dump the customer table once daily into SQL. Maybe other tables in the future, like orders or quotes. Does the server version need a remote desktop session open to work? If the server reboots because of an update, I need to log in to make it work again. That doesn’t seem very feasible for us. 

Solution:

QODBC is not a driver you would install on a server; multiple workstations would have access to it. The server version of QODBC is for synchronizing SQL Server with QuickBooks data or for a web or intranet application.

>>Is there a server version that will not need a user logged in or pass the info along automatically, so the website continues to function correctly?
>>Does the server version need to have a remote desktop session open to work?

Please refer to how to Setup QODBC to Access QuickBooks when no one Logged in.

OR

You may configure a session-0 to start and start QuickBooks and QRemoteServer automatically.
When you configure session-0, you are setting up the auto login of a user, and that user will have a desktop session running.

>>Is there a way to try the server version by syncing to the SQL server?

You can use La inked Server on SQL Server and connect to QuickBooks Data using QRemote. When you query the Linked Server/tables, you will always get live QuickBooks Data.

For a dump of all the tables or selected tables from QODBC to Tables in SQL Server Database, you may write a script to create the table(s) in SQL Server and get data from the linked server.

e.g.
SELECT * into LocalSQLTableName FROM OPENQUERY(YourLinkedServerName, 'SELECT * FROM LinkedTableName')

SELECT * into tblVendor FROM OPENQUERY(QRemote, 'SELECT * FROM Vendor')

You can add the script to the agent to run periodically.

Please refer to the below-mentioned article for How to create a Link Server with MS SQL 2005/2008/2012 Using QODBC/QRemote.

For 32-bit SQL Server, refer to:
How to create a Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote

For 64-bit SQL Server, refer to:
How to create a Link Server with MS SQL 2005/2008/2012 64-bit Using QODBC/QRemote


Also, Refer:
How to set up QODBC Driver to auto-connect to QuickBooks. (Video)
How to setup QODBC for Auto-login into QuickBooks




]]> <![CDATA[[QODBC-Desktop] Troubleshooting: Using QODBC to connect to different versions of QuickBooks]]> Troubleshooting: Using QODBC to connect to different versions of QuickBooks

Problem Description

Can multiple versions of QuickBooks (such as Pro, Premier, and Enterprise) on the same server work with the same edition of QODBC installed?

Sometimes could get the error below:

Error Description: Error code is: 800401F3:: Failed to connect, with ODBC: [QODBC] QuickBooks Begin Session Failed. Error = 80040421, This file can only be opened with QuickBooks Enterprise Solutions. Please open this file with QuickBooks Enterprise Solutions, then try again.

Solutions

QODBC is licensed by the version of QuickBooks you are using. You cannot use it with different versions in different regions, but it could work well with both QuickBooks Enterprise Edition and QuickBooks Premier (all in the same region edition).

QODBC is not upward compatible, only backward, meaning you need version 11 of QODBC to work with QuickBooks 2011. Version 11 of the driver will work with all QuickBooks 2002- 2011 Pro and Higher editions. The Read Only version of QODBC is included with QuickBooks Enterprise Solutions 11.

And we always suggest you set up different QODBC DSNs to point to different company files. In such a case, if you set up your QODBC DSN as "Use the company file that's now open in QuickBooks," QODBC will automatically point to the currently open company file, no matter if it's a QuickBooks file or QuickBooks Pro file. And if you want to specify a company file by checking the option "Locate a company file" in QODBC, please see: How to set up QODBC for Auto-login into QuickBooks for more.

 

]]> <![CDATA[[QODBC-Desktop] QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks]]> Troubleshooting: QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks

Problem Description 1

     Getting this error message, 'QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks' when trying to connect to QuickBooks.

      I have tried, as suggested by support - to remove QuickBooks and QODBC from the system and re-install them. I drew all registry entries associated with Intuit or QuickBooks and re-installed them, but I still get the error message. I originally installed the evaluation version of QuickBooks, removed it, and installed the Canadian version. The problem occurred over a month ago, and I have tried everything save - formatting the hard disk.

Solution 1

Please re-install your QuickBooks application. Restart your machine after the installation is completed.

Possible Reasons and Solutions

     This error can occur because multiple region versions of QuickBooks have been installed on the same computer. For example, the USA version of QuickBooks and then the Canadian version of QuickBooks. Where this is the case, you need to uninstall both copies of QuickBooks and re-install only the correct version of QuickBooks for your region.

     Doing a Detail Trace log will generally show the actual error message when you do a Review Trace Log (via QODBC Setup Screen -> Messages Tab). Otherwise, the error appears when an error occurs doing the very first introductory call to get the Host table. Go to QODBC Setup Screen, and press the "Messages" tab page. Click on the "Detail Tracing (Slow)" checkbox.

     Messages allow you to review message logs from QODBC regarding errors and issues communicating with QuickBooks, clear these messages, and review messages produced by the QuickBooks qbXML SDK interface.

Detail Tracing Relative

Detail Tracing (Slow) creates a trace log of what QODBC is doing in the background with the application and is used for debugging purposes. Ensure the record is turned off when not needed, as these logs can use up large amounts of disk space.

Display Optimizer Status Panel will display the progress of optimization of the data; this is especially helpful on large data files being reloaded in their entirety.

When selected, Display Driver Status Panel shows exactly what QODBC is doing when accessing the QuickBooks data and provides a good assessment of speed using optimized and non-optimized data.

 

Problem Description 2

SDK Module: QBXMLRP2.DLL (IAuth2)
QB Company Name: C:\Program Files\Intuit\QuickBooks\Premier - Association and Nonprofit EditionDataintella.QBW
QBXMLProcessXMLWithStringPointer5 Error: Error = 80040400, QuickBooks found an error when parsing the provided XML text stream.

QBXMLProcessXMLWithStringPointer5 Error: Error = 80040423, The version of QBXML that was requested is not supported or is unknown.

QBXMLProcessXMLWithStringPointer5 Error: Error = 80040400, QuickBooks found an error when parsing the provided XML text stream.

QBXMLProcessXMLWithStringPointer5 Error: Error = 80040423, The version of QBXML that was requested is not supported or is unknown.

QBXMLProcessXMLWithStringPointer5 Error: Error = 80040423, The version of QBXML that was requested is not supported or is unknown.


2006-04-13 10:10:58 QODBC Ver: 6.00.00.150 *********************************************************************************************************************
IsAService: False
Error Getting Version
QB Version:? (Error Getting Version)
0x00000000 [ISAM]
S0000 00000 [QODBC] QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks.
ISAM_INCORRECT_APIVER S0000 00000 [QODBC] QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks.

Solution 2

     When installing QODBC, if it were for use with QuickBooks USA (for example), it would have set the 30-day evaluation for the USA version of QuickBooks. Now that you are running the Canadian version of QuickBooks, QODBC is calling your Canadian version of QuickBooks with the USA tag, and it can't find the provided XML text stream.

Option 1

     Then one option could do now is to delete your:

C:\Program Files\Common Files\Intuit

Folder and re-install your QuickBooks application as a new install and install QODBC afterward.

Note: Using the server console (local session logged in as administrator), re-install the QuickBooks Canadian Premier Edition and then re-install QODBC (selecting Canada as your region). Then using one of the sample company files, do the process shown in How to Connect to QuickBooks for the First Time, following every step. And contact our sales office directly for a new 30-day evaluation code.

Note: You could also try checking your Region Key. See: QuickBooks Canada and USA on the same computer - QODBC Region Key to confirm more.

Option 2

     Redo some post-QuickBooks install configurations. Try downloading registerall.zip and running the register all.VBS script is contained in the zip file. This will re-register all the COM.DLLs in the QuickBooks directory for you. Once that's done, retry connecting.

     If that doesn't work, you can try running the "reboot.bat" file in file in the c:\Program Files\Intuit\QuickBooks Premier folder. Just locate the file in Windows Explorer and double-click on it to execute it. This will reset all the QuickBooks COM objects.

    If that doesn't work, re-install QODBC (again, as above).

]]> <![CDATA[[QODBC-Desktop] Version update over existing version didn't seem to work]]> Troubleshooting: Version update over the existing version didn't seem to work

Problem Description 1

 I recently downloaded and installed the latest version of QODBC on top of my existing purchased version. However, when I access the QODBC setup screen, it still displays the previous version. Am I doing something wrong?

Solutions 1

 

For QODBC Desktop, please refer to the following instructions.

Please download the latest version of QODBC Desktop from the link below.

Installer

https://qodbc.com/qodbc-downloads/

NOTE: After installing this version, you may have to rebuild the optimizer file. The installer will reset the default QODBC and QRemote DSN.

Please do not deactivate the current CDKEY.

Download the QODBC Installer.

Close all the applications that use QODBC or QuickBooks.

Close / Exit QRemoteServer.

Uninstall the current version of QODBC.

Install the latest version of QODBC.

You can skip the CDKEY step during installation.

Restart Windows.

Go to the QODBC Setup Screen->" About" window to see if the version change has been applied.

If you are using QODBC remotely (using QODBC on multiple machines), please install QODBC on those machines.

After successfully installing the updated version of QODBC & QRemote, please test the reported issue & share the outcome.

 

For QODBC Online, please refer to the following instructions.

Please download the latest version of QODBC Online from the link below.

Installer

https://qodbc.com/download-online-qodbc/

Back up your connection key – Start >> All Programs >> QODBC Driver for QuickBooks Online >> General tab >> Click on the "Export Connection key" button. Save the connection key file.

Refer to the Knowledgebase article "Import / Export connection key:" at https://qodbc.com/links/2658

Please do not deactivate the current CDKEY.

Download the QODBC Online Installer.

Close all the applications that use QODBC Online

Close / Exit QRemoteServer.

Uninstall the current version of QODBC Online.

Install QODBC Online latest version.

Skip the CDKEY step during the installation

Restart Windows (if prompted)

Go to the QODBC Online Setup Screen-> "About" window to see if the version change has been applied.

Close QODBC Online Setup Screen

After successfully installing the new version of QODBC Online and QRemote, please rebuild the Optimizer file and test the reported issue.

Please do share the outcome of the test.

If you cannot connect, you can restore your connection key. To restore your connection key – Start >> All Programs >> QODBC Driver for QuickBooks Online >> General tab >> click on the "Import Connection key" button.

Select the backed-up connection key file.

NOTE: After installing this version, you may have to rebuild the optimizer file.

 

For QODBC POS, please refer to the following instructions.

Please download the latest version of QODBC POS from the link below.

Installer

https://qodbc.com/download-pos/

Download the QODBC POS Installer.

Close all the applications that use QODBC POS or QuickBooks

Close / Exit QRemoteServer

Uninstall your current QODBC POS.

Install QODBC POS latest version.

Skip the CDKEY step during installation

Restart Windows

Go to the QODBC POS Setup Screen-> "About" window to see if the version change has been applied.

After successfully installing the new version of QODBC POS and QRemote, please test the reported issue and share the outcome.


Problem Description 2

    I was using a very older version of QODBC (maybe around 3-4 years old), I just installed the latest version of QODBC, and I had a whole new screen showing it as an evaluation version. Is my license not valid for QODBC?

Solutions 1

Please activate the CDKEY again, and that should fix the issue.

If you are still facing the issue, please raise a support ticket with us.

]]>