Knowledgebase
[QODBC-Desktop] How to setup QODBC for auto-login into QuickBooks.
Posted by Juliet (QODBC Support) on 17 June 2009 08:13 AM

How QODBC and QuickBooks SDK works

Intuit QuickBooks SDK inside of the QuickBooks application uses XML format for reading and writing QuickBooks data.

QODBC uses the QuickBooks SDK to talk to QuickBooks data.  QODBC acts as a 'wrapper' around the Intuit SDK so customers can get at their QuickBooks data using standard database tools; speeding development time.

QODBC converts this XML communication into the easier to use SQL/ODBC format.

You cannot use the QuickBooks SDK without running QuickBooks as they are one and the same programs.

You can run QuickBooks on the desktop or you can run it in "hidden" mode. Either way, it is running, the only difference is whether you see it on the desktop or not.

How to setup QODBC for auto-login into QuickBooks.

1. Locate the "QODBC Driver for QuickBooks" program group on your desktop. Click on the "Configure QODBC Data Source" icon to launch the configure data source program supplied with QODBC.

autolg-1.jpg

2. Click on the “Add” button to create a new QODBC data source.

autolg-2.jpg

3. The following general setup screen will become available. Check the Locate a company file: option. This allows you to set up the full path to where your QuickBooks data file resides. For example: “C:\Documents and Settings\All Users\Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks Enterprise Solutions 9.0\sample_service-based business.qbw”. The [Browse] button will let you choose your QuickBooks company file from the folder it is in. To use the QODBC auto-login unattended mode you must specify the full path of the QuickBooks company file you wish to connect to.

autolg-3.jpg

4. Choose the Advanced tab in QODBC Setup. Use these settings to allow "auto-login" with or without a visible QuickBooks User Interface.

autolg-4.jpg

And then click on the "OK" button to create a new data source named "test".

5. Click on the “QuickBooks Enterprise Solution 9.0” icon on the desktop to launch it and Open your QuickBooks data file. Be sure to login in as the Administrator user.

autolg-5.jpg

6. Locate the "QODBC Driver for QuickBooks" program group on your desktop. Click on the "VB Demo" icon to launch the VB Demo program supplied with QODBC.

autolg-6.jpg

7. The following VB Demo screen will become available. To establish a connection: From the menu bar select "Connections" / "Add a new connection", select the "Machine Data Source" tab and "test" System DSN, Click "OK”.

autolg-1.jpg



autolg-1.jpg

8. Then the QuickBooks will ask you permission for this driver to access your QuickBooks data. Check the “Yes, always; allow access even if QuickBooks is not running” option and then click on the “Continue…” button to confirm.

autolg-8-1.jpg

Confirm that you want to allow this access by clicking on "Yes" and then “Done”. This will allow applications to integrate with QuickBooks data when QuickBooks is running on the desktop.

autolg-8-2.jpg autolg-8-3.jpg

Note:
          The application certificate needs to be accepted for each Company File.
          The application certificate needs to be accepted for each Application.
          The application certificate needs to be accepted for each Windows Machine.
          The application certificate needs to be accepted for each Windows User.

This is because Intuit's LGB file which was common earlier is now changed to new a method and integration information will be stored for each Windows user separately.

For Example,
You have 4 Windows Machines, and each has 3 windows users. All those 3 windows users use QODBC via Microsoft Excel, Access, Crystal or any other applications.

Switch to 1st Windows Machine
Login to User-A to windows OS. Login to your Company Files as Admin. Test the connectivity with QODBC using each application, One by one. Perform connection to your QODBC DSN from each application & Authorize/Accept application certificate for EACH application.
Log off as User-A

Login as User-B to windows OS. Login to your Company Files as Admin. Test the connectivity with QODBC using each application, One by one. Perform connection to your QODBC DSN from each application & Authorize/Accept application certificate for EACH application.
Log off as User-B

Login as User-C to windows OS. Login to your Company Files as Admin. Test the connectivity with QODBC using each application, One by one. Perform connection to your QODBC DSN from each application & Authorize/Accept application certificate for EACH application.
Log off as User-C

Switch to 2nd Windows Machine
Perform the same steps for each of the Windows users.

Switch to 3rd Windows Machine
Perform the same steps for each of the Windows users.

Switch to 4th Windows Machine 
Perform the same steps for each of the Windows users.

9. From the QuickBooks Edit menu, select Preferences, and then select Integrated Applications. There are often instances in which you want an integrated application designed to share data with QuickBooks to access QuickBooks files automatically, without user intervention. This might permit, for example, a particular application to run during the night when there is no other activity in the company file. Also, QuickBooks doesn't need to be running in the foreground for ODBC compliant applications to access the data files using QODBC while setting in this mode.

autolg-9.jpg

10. Click the Company Preferences tab and make sure that the "Don't allow any applications to access this company file" checkbox isn't checked. The "Notify the user before running any applications whose certificate has expired" checkbox can be checked. If it is, however, automatic access will be suspended if the application's certificate expires.

autolg-10.jpg

11. Select the "FLEXquarters QODBC" driver you want to run automatically and click the “Properties…” button.

autolg-11.jpg

Check "Allow this application to access this company file." Uncheck "Prompt before Allowing Access." Check "Allow this application to log in automatically." Select your "Login as" user. (Normally "Admin") Click on the “OK” button.

12. Testing Your Connection: Now that you have successfully established a connection to your QuickBooks data, it's time to type in your desired SQL query, for example, you can use the default "SELECT * FROM Customer" or type in another table like stock by entering "SELECT * FROM ItemInventory". Click on the "Query" button and the requested query results will appear! In case you're wondering, the * in the select statement means all columns in that table.

autolg-12.jpg

 

Possible problem & solution:

Problem Description:

When our application queries the QB database, the connection time is at least 7 seconds (usually 12 seconds or more).
The log file shows about 7 seconds between starting to connect and a successful connect.
Once connected, the SQL seems to be processed very quickly.

Solution:

As you are using Auto Login QuickBooks may take time in running in the background.

I would like to inform you that If company file in on the network location, then there might be a possibility of delay in opening QuickBooks company file through a network.

I kindly request you to please put the company file on same machine & test again.

If the company file on the same machine, I kindly request you to please keep QuickBooks running no need to login company file just keep QuickBooks window open. So you can eliminate the time which is required to start QBW32.exe (QuickBooks) in the background.

 

Also Refer: How to setup QODBC Driver to auto-connect to QuickBooks. (Video)

How to use the VB Demo for testing

VB Demo is missing

    
Tags : QuickBooks start, QuickBooks autostart, QuickBooks startup, QuickBooks connect, Hidden QuickBooks,Quiet QuickBooks, Silent QuickBooks, Background QuickBooks, How to setup QODBC for Auto-login into QuickBooks, process for automatically start of QuickBooks, QuickBooks automatic, automatic quick books, autostart QuickBooks,automatically start of QuickBooks, running QuickBooks automatic,how to run without QuickBooks

(333 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).