Checking the Connect To QuickBooks Online Edition checkbox activates the fields required to connect to the QuickBooks Online Edition. The connection string attribute for this item is IBizOEConnection. The valid values are Yes and No. The default is No.

The Connection Key is a unique key that can only be created by your Online Edition Administrator. If you have administrator rights to your Online Company file then you can run the following URL: https://login.quickbooks.com/j/qbn/sdkapp/confirm?serviceid=2004&appid=71271511 to obtain a connection key. Follow the wizard. The “…” after Connection Key: will launch a browser with the above URL. The connection string attribute for this item is IBizOETicketGUID. The default is an empty string.

Connection Key Wizard

A short summary

Login to your company file

Start of Interview

For Connection Name, use "QODBC Driver"

Select the access you want QODBC to have to your Online Data

Select who can access. NOTE: If you choose anything other than "No, Anyone can run QODBC Driver on this computer can use the connection" you will have to enter your login in every time a QODBC session or a QODBC connection is made. For a user to have access to your data they must have a connection ticket which can only be created by a company file administrator and must be running a copy of QODBC which passes it own private password along to connect.

If you choose No you will get this warning also. See the note above on who could access the data and if you want to login every time you connect to QODBC.

The Login Key comes from Intuit by running the following URL: https://login.quickbooks.com/j/qbn/sdkapp/sessionauth2?serviceid=2004&appid=71271511 and logging in. The “…” after Login Key: will launch a browser with the above URL. The connection string attribute for this item is IBizOELoginGUID. The default is an empty string. This value is only required if the QuickBooks Online Edition company file has user security activated. If you chose No security then leave this blank. This Key will expire after a period of non-use. If your application makes several connections each time you access QODBC you might want to return to this screen and press the "..." and login once, saving the new Login Key. Then you will not be prompted again until the non-use timeout expires.

Ask to login if invalid can be checked to allow the user to be sent to the Intuit WEB site to login if the Login Key is not valid. After the user has successfully logged in the user must copy the Login Key to the clipboard, close the browser and paste the Login Key into the Popup prompting for a Login Key. If not checked, and the Login Key is invalid, then an error message is returned to the calling program. The connection string attribute for this item is IBizOEPromptForLogin. The valid values are Yes and No. The default value is Yes. This is only useful if the QuickBooks Online Edition company file has user security activated.