Knowledgebase: Tutorials
[QODBC-Desktop] Troubleshooting - QuickBooks Data DSN Not Showing Up In ODBCAD32.exe ODBC Data Source Administrator in Win8
Posted by Jack - QODBC Support on 10 July 2015 08:56 AM

Troubleshooting - QuickBooks Data DSN Not Showing Up In ODBCAD32.exe ODBC Data Source Administrator in Win8

Problem Description:

I can't configure QuickBooks Data DSN from Configure QODBC Data Source window. When I click on QuickBooks Data, configure is grayed out.



Please let me know what I am doing wrong.

 

Problem Description:

I don’t seem to have the Configure QODBC Data Source or the Configure QODBC Data Source 64-Bit programs under the QODBC Driver for use with QuickBooks.

Solutions:

You have opened a 64-bit ODBC manager, On 64-bit platforms, 32-bit ODBC drivers are available to 32-bit applications, but not to 64-bit applications. What determines which ODBC driver architecture used is whether your application is 32-bit or 64-bit not whether your client platform (or database platform or DBMS) is 32-bit or 64-bit. Since QODBC is a 32-bit only ODBC driver, the only applications that can access it are 32-bit applications. So if you open ODBC Data Source window by default it will open 64-bit ODBC Data Source Manager because OS is of 64-bit.

You need to search "Configure QODBC Data Source"

OR 

OR 

 



Or

Run the 32-bit ODBC admin utility to see data source:

C:\windows\sysWOW64\odbcad32.exe

 

For 64-bit ODBC admin utility to see data source:

c:\WINDOWS\System32\odbcad32.exe

 



Open Configure QODBC Data Source>>Go To "System DSN" Tab>> select QuickBooks Data>> click "configure"

Start>> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source >>Go To "System DSN" Tab >> select DSN name >> click "configure" >> General tab >> select mode when opening "Same as company file" option.

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).