[QODBC-Desktop] Vista/Windows 7 and 64-bit and QODBC
Posted by Juliet (QODBC Support) on 12 October 2009 06:51 AM
Vista/Windows 7 and 64-bit and QODBC
Operating system: Windows Vista / Windows 7 64-bit
Software: QODBC version 126.96.36.1999 (32-bit)
QuickBooks Enterprise Solutions 9.0 (USA Version)
Summary about Using 32-bit ODBC driver on 64-bit platforms
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.
Installation and Configuration of 32-bit QODBC under 64-bit system
ODBC Driver situation before QODBC is installed
1. Run the default system data source:
Start -> Control Panel -> Performance and Maintenance -> Administrative Tools -> Data Source (ODBC)
There is only the default SQL Server driver in the windows vista business 64-bit system:
2. Run the 32-bit ODBC admin utility to see the data source:
There are many drivers of 32-bit programs but no OQDBC driver:
1. Click on the QODBC icon to start the installation
2. Install OQDBC step by step till it is finished.
ODBC Driver situation after QODBC is installed
1. Run the default system data source:
(The same as it mentioned above)
2. Run the 32-bit ODBC admin utility to see the data source (as mentioned above):
Choose "System DSN", there is a QODBC driver for QuickBooks.
Test with QODBC installed
1. Open QuickBooks and open the sample file - sample_service-based business.qbw
2. Create a new data source named "test" by running odbcad32.exe
You can create a new DSN entry/or configure the existing one
Navigate to Start Menu, QODBC Drivers for Use with QuickBooks, and click Configure QODBC Data Source.
For example, here we are creating the new DSN and will test the connectivity.
Click on "Start" and "Programs" and locate QODBC Driver for the QuickBooks program group. Click on the "Configure QODBC Data Source".
o Navigate to System DSN. Click on Add Button
Select "QODBC Driver for QuickBooks" and click on Finish
Input the name "Test" as DSN name and click on "Apply".
3. To test the connection, Click on "Start" and "Programs" and locate QODBC Driver for the QuickBooks program group. Click on the QODBC Test Tool icon to launch the program supplied with QODBC. From the dropdown list, select the "Test" DSN to establish a connection and click on "Connect".
Make a certification for QODBC in QuickBooks
Then can get data from QuickBooks
[Note: For those users who need to use remote connect, RDS is not supported under 64-bit at all. ]
UAC and QODBC in 64-bit Vista / Windows 7
UAC (User Account Control): is a new technology in Windows Vista to improve system security which asks all users permission to run programs and tasks under a standard account module. It can prevent the installation of programs without authentication and can also prevent the un-appropriate change of the system setup from a standard user.
1. With UAC on:
(1) Log in as Administrator.
(2) Start -> Control Panel -> User Account -> Open or Close “User Account Control” (UAC) -> check “Using User Account Control(UAC) to protect your computer”
(3) Run "OQDBC Setup Screen" and you will see the follows: (The "Test Connection to QuickBooks" button is lighted)
(4) Click on the "Test Connection to QuickBooks" button and then make a certification for QODBC:
When the test connection succeeds, you can get data from QuickBooks.
2. With UAC off:
(1) Login as Administrator
(2) Start -> Control Panel -> User Account -> Open or Close “User Account Control” (UAC) -> uncheck Using User Account Control(UAC) to protect your computer”-> restart the computer
(3) Run "OQDBC Setup Screen" and you will see the following: (The "Test Connection to QuickBooks" button is grey and cannot be used.)
(4) When connected to QuickBooks using the data source with UAC off, it pops out some errors: