Knowledgebase
[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

System Environment

Operating system: Windows Vista / Windows 7 64-bit

Software: QODBC version 9.0.0.259 (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:

      C:\windows\sysWOW64\odbcad32.exe

      There are many drivers of 32-bit programs but no OQDBC driver:

 

Install QODBC

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

Or

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:

(377 vote(s))
Helpful
Not helpful

Comments (2)
linda saltz
07 June 2013 03:52 PM
Can you update this page
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2344/76/vista/windows-7-and-64-bit-and-qodbc

I had the same trouble on 2 computers. Both of the computers had an administrator user and a Named (standard user).
I tried all the fixes on all the websites to fix the problem where the Test connection button was greyed out. Nothing worked.

I finally logged off the administrator log in and logged into the named user and THAT WORKED.

So I think it will be helpful to other users if you could post as a "to try" to log off as administrator on that computer and log back in as a named user.
Rajendra Dewani
21 September 2013 07:38 AM
HI,

We do have articles explaining details and workaround of the issue.
Please refer

http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2507

http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2451
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).