Knowledgebase: TroubleShooting
[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 64-bit. What determines which ODBC driver architecture is used 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 the ODBC Data Source window by default, it will open 64-bit ODBC Data Source Manager because OS is 64-bit.

You need to search "Configure QODBC Data Source."

OR 

OR 

 



Or

Run the 32-bit ODBC admin utility to see the 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.

 

(1 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).