Knowledgebase: TroubleShooting
[QODBC-Desktop] QuickBooks Data not showing up in the list of data sources
Posted by Rajendra Dewani (QODBC Support) on 23 August 2012 06:11 AM

Problem Description:

When I attempt to configure the driver and data source, only QRemote for the QuickBooks driver is visible; please see below: 

Where can I find QuickBooks Data, the driver? Don't I need to configure the QuickBooks Data driver instead of QRemote for QuickBooks driver?


Summary about Using 32-bit ODBC driver on a 64-bit system 

      On a 64-bit system, 32-bit ODBC drivers are available to 32-bit applications but not 64-bit. If your application is 32-bit, you must use a 32-bit ODBC driver. If your application is 64-bit, you must use a 64-bit ODBC driver. It would be best if you chose the ODBC driver per your application architecture, not your OS architecture. Since QODBC is a 32-bit only ODBC driver, the only applications that can access it are 32-bit applications.


In the 64-bit system, when you open ODBC Data Source Manager by default, it will open 64-bit ODBC Data Source manager. You can run the default system data source from:    

Start -> Control Panel -> Performance and Maintenance -> Administrative Tools -> Data Source (ODBC)

     This brings up Data Source listing the 64-bit drivers

How to open a 32-bit ODBC Data Source Manager under a 64-bit System

You can open the 32-bit ODBC Data Source manager from: 

1.Click  Start -- > All Programs -- > QODBC Driver for use with QuickBooks  -- > Configure QODBC Data Source.



2.   You can run the 32-bit ODBC admin utility to see 32-bit data source from the 32-bit ODBC Data Source Manager:

Navigate to C:\Windows\SysWOW64\ folder and find odbcad32.exe & run odbcad32.exe by double click on it :



Tags: ODBCAD32, QuickBooks Data, 64-bit, Driver Not Showing, No Driver listing

Also, Refer:

How to setup QODBC for Auto-login into QuickBooks

How to create or configure a QODBC DSN

(1 vote(s))
Not helpful

Comments (3)
20 September 2012 12:31 PM
Hi,On 2008 R2, i created a DSN with 32-bit odbc. But etenrxal client applications trying to connect the DB, are unable to find 32-bit DSN, rather they are still only finding 64-bit DSNs. I tried removing the registry entries for the 64-bit DSN. But now i'm getting error on client(cognos) that no DSN available. Is there a way that the client applications (32-bit) see 32-bit DSNs? Thanks a lot
20 September 2012 05:16 PM
I'm not sure that you can turn it off, since it would be necessary if you nedeed to use a 64-bit application. The easiest thing is to make a shortcut to the 32-bit version and place it in a more prominent location (on the Start Menu for example).
20 September 2012 07:03 PM
I am not able to connect using BO XI Client tools to our DB2 daaabtse.On the server I have setup the odbc system drivers using 32-bit. Everthing works on the server connection wise but the client tools do not. Any suggestions?
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).