[QODBC-Desktop] Troubleshooting: Cannot find QODBC Driver/QuickBooks Data under system DSN with any application other than the QODBC Test Tool
Posted by Rajendra Dewani (QODBC Support) on 23 August 2012 10:10 AM
Troubleshooting: Cannot find QODBC Driver/QuickBooks Data under system DSN with any application other than the QODBC Test Tool
Testing under the 64-bit system, when using the QODBC Test Tool application, the user can see DSN (QuickBooks Data) in the ODBC manager, but when using other applications or trying to configure the DSN through ODBC manager, the user cannot find the DSN.
Under the 64-bit system, there are two ODBC managers, one is for 32-bit, and the other is for 64-bit. QODBC is 32-bit, so the default DSN (QuickBooks data) is 32-bit too. You cannot find it in the 64-bit ODBC manager.
Please use the 32-bit ODBC manager to view and modify QODBC DSN.
1.Click Start -- > All Programs -- > QODBC Driver for use with QuickBooks -- > Configure QODBC Data Source.
Alternative: The 32-bit ODBC manager can be found at C:\windows\sysWOW64\odbcad32.exe.
Please refer to this article: Vista/Windows 7 and 64-bit and QODBC for more detailed information.
And If the application cannot find QODBC DSN, it is probably because the application is 64-bit. QODBC is 32-bit, and it can not directly work with the 64-bit application. Please refer to this article: How to Configure QODBC to Work With 64-bit Applications for more information if you want to use QODBC with 64-bit applications.