Knowledgebase
[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:

http://support.flexquarters.com/esupport/newimages/IntAPPPOS/step8.png 

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

Solution:

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.

QODBCStartMenu.png

Or

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 :

      C:\Windows\SysWOW64\odbcad32.exe

 

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))
Helpful
Not helpful
Comments (3)
Udhynk
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
Ahmed
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).
Rizky
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:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).