[QODBC-Desktop] Troubleshooting: Cannot find QODBC Driver/QuickBooks Data under system DSN with any application other than the VB Demo
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 VB Demo
Testing under the 64-bit system, when using VB Demo test application, the user can see DSN (QuickBooks Data) in the ODBC manager, but when using other application or try to configure the DSN through ODBC manager, the user cannot find the DSN.
FYI, 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 64-bit ODBC manager.
Please use 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 detail information.
And If the application cannot find QODBC DSN, it is probably because that 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.