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 data source:

      C:\windows\sysWOW64\odbcad32.exe

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

 

Install QODBC

1.   Click on QODBC icon to start the installation

2.   Install OQDBC step by step till it 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 data source (as it 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 “test1” 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 

 

  QODBCStartMenu.png

 

 

o Navigate to System DSN. Click on Add Button

image009_32.png

 

 

 

3.   Run a VB Demo and create a new connection with the created data source“test1”

     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 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 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 follows: (The “Test Connection to QuickBooks” button is grey and cannot be used.)

     (4) When connect 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).