ODBC Driver for QuickBooks

Connecting to QuickBooks via ODBC Driver



Windows DSN Configuration

After installing the driver, create a DSN for QuickBooks in the ODBC Data Source Administrator.

  1. Open the ODBC Data Source Administrator.
    • Type ODBC Data Sources in the Windows search box and choose the application that matches the bitness of the third-party application (32-bit or 64-bit). You can also open ODBC Data Sources from Control Panel > Administrative Tools. Note that before Windows 8, the icon was named Data Sources (ODBC).
    • Alternatively, you can run C:\Windows\SysWOW64\odbcad32.exe to create a 32-bit DSN or C:\Windows\System32\odbcad32.exe to create a 64-bit DSN.
  2. Select the User DSN or System DSN tab. Most applications work with both types, yet some applications require a specific type of DSN.
  3. Click Add. The Create New Data Source dialog will appear.
  4. Select Devart ODBC Driver for QuickBooks and click Finish. The driver setup dialog will open.
  5. Click Connect to QuickBooks.

    connection_settings_qb

  6. In the Web Login dialog box, sign in with Google or enter your QuickBooks account credentials and click Sign in.

    Enter credentials to log in to QuickBooks

  7. Enter the code that you received from QuickBooks and click Continue.

    6-digits code verification

  8. Click Connect to allow the driver to view and update your data.

    Authorization to QuickBooks

  9. The company id and refresh token will be filled in automatically.

    filled-connection-options

  10. You may test the connectivity by clicking Test Connection.
  11. Click OK to save the DSN.

See Also

Connection Options

© 2015-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback