Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks?Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Frequently Asked Questions

 New Topic 
 
 Post Reply 
[1]  
 QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks? 
 Author   Message 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-03-04 08:02:54

I'm getting this message on a client's machine:

QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks.

Is this because they have previously installed some version of the SDK or RDS server or something? What do I tell them to do to resolve this? Uninstall? Update?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-03-04 08:06:06

This error is normally caused because multiple region versions of QuickBooks have been installed on the same computer. For example, QuickBooks New Zealand and the USA version of QuickBooks or QuickBooks USA and the Canadian version of QuickBooks. Where this is the case you need to uninstall both versions of QuickBooks, making sure you delete your:

C:\Program Files\Common Files\Intuit

folder and then re-install the correct edition of QuickBooks for your region as a new install making sure you install QODBC again afterwards.

From there do the: How do I connect to QuickBooks for the first time? procedure.

Otherwise the error appears when any error occurs doing the very first basic call to get the Host table. Doing a Detail Trace log will normally show the real error message when you do a  [  Review_Trace Log  ]. Go to QODBC Setup Screen, press the "Messages" tab page. Click on the "Detail Tracing (Slow)" check box.

Messages allows you to review message logs from QODBC regarding errors and issues communicating with QuickBooks, clear these messages, and review messages produced by the QuickBooks qbXML SDK interface.

  • Detail Tracing (Slow) creates a trace log of exactly what QODBC is doing in the background with the application and is used for debugging purposes. Make sure the log is turned off when not needed as these logs can use up large amounts of disk space.
  • Display Optimizer Status Panel will display the progress of optimization on the data, this is especially helpful on large data files being reloaded in their entirety.
  • Display Driver Status Panel when selected shows exactly what QODBC is doing when accessing the QuickBooks data and provides a good assessment of speed using optimized data and non-optimized data.

Be sure to uncheck this option when you no longer need the tracing log turned on as it will grow quickly and slow QODBC preformance.

 

  Top 
  hamlintech 
  
 Group: Members 
 Posts: 12 
 Joined: 2006-04-08 
 Profile
 Posted : 2006-04-13 00:05:43
Tom - we are now getting this as well and nothing has changed in our setup.  We have QB2006 (US) and all was working fine 2 weeks ago.

HELP..

Ron 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-04-13 08:26:46

Sorry, we are going to need a little more detail. I understand that you are saying that nothing has changed, but can you still use QODBC to open the sample company files? What about other computers?

What do you think happened over the last two weeks? Bear in mind that I'm running four notebooks with four different versions of QuickBooks here. Did you install new software? Did you install QuickBooks POS?????

Otherwise the error appears when any error occurs doing the very first basic call to get the Host table. Doing a Detail Trace log will normally show the real error message when you do a  [  Review_Trace Log  ]. Go to QODBC Setup Screen, press the "Messages" tab page. Click on the "Detail Tracing (Slow)" check box and let me know what the real error is?

Don't post the trace file, just the lines with the real error.......

 

  Top 
  Quantum 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-08-25 
 Profile
 Posted : 2006-08-25 12:46:08

Hi Tom

I am an accredited trainer in NZ with this same error message, I did have US version installed but uninstalled it previously. Do I need to uninstall ALL versions of NZ QuickBooks i have loaded as I have 6,7.5,2002,2004,2005,2006 or can I just uninstall the one I need to access QODBC with and the delete the common files folder?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-08-25 13:12:14

Based on what I've seen on other computers, I'm guessing that parts of the USA version of QuickBooks are still in the Common Files folder that were most likely overlooked when you uninstalled it. Parts of the USA version of QuickBooks are still in the C:\Program Files\Intuit folder and will not be overwritten when you install the New Zealand version of QuickBooks because their DLLs will be older than the USA DLLs..

If you really need to get this working on your computer, please delete your:

C:\Program Files\Common Files\Intuit

folder and re-install your New Zealand 2006 edition of QuickBooks as a new install and install QODBC again afterwards. Unfortunately this will most likely break all the old versions of QuickBooks on your computer, so the choice is yours to make here. Integrated Applications are only designed by Intuit to work with one copy of QuickBooks.

From there do the: How do I connect to QuickBooks for the first time? procedure (that you know by heart now).

 

  Top 
  Georg Zimmer 
  
 Group: Members 
 Posts: 14 
 Joined: 2006-05-12 
 Profile
 Posted : 2007-10-19 01:14:39
I am getting the API version 1.1 or 2.0 error with the online version.  The solution below does not apply?  How do i install quickbooks with the online version?

The error lines in my trace log when I attempt to connect with VB Demo follow:

2007-10-18 10:53:01 QODBC Ver:  8.00.00.236 *********************************************************************************************************************
IsAService: False
Error Getting Version
    QB Version:        ? (Error Getting Version)
    0x00000000 [ISAM]
    S0000 00000 [QODBC] QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks.
    ISAM_INCORRECT_APIVER S0000 00000 [QODBC] QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks.


In QODBC log i get


2007-10-18 11:03:36 QODBC Ver:  8.00.00.236 *********************************************************************************************************************
IsAService: False
Open Connection Failed. S0000 00000 [QODBC] QB Open Connection Failed. Error = 8004042f, The requested connection type could not be found.
SDK Module: QBXMLRP2.DLL (IAuth2)

In SDK messages I get
20071018.110336    I    2656    CertVerifier    The file does not contain an Authenticode signature.
20071018.110336    E    2656    RequestProcessor    Could not find installation of QuickBooks that supports the SDK.
20071018.110336    E    2656    RequestProcessor    OpenConnection has not been called.

Thanks

Georg 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-10-19 07:43:27

Sorry, I've now established that QODBC v8.00.00.236 did not fix the connection issues with QuickBooks Online Edition (QBOE). It appears that the 7.0.DTD file posted by Intuit was invalid and we have to now move to QuickBooks 2008.

Until it get's posted as the main product release, the full install for QODBC v8.00.00.237 can be downloaded from:

http://www.qodbc.com\download\qodbc_237.exe

or as a Update Installer (for those that already have QODBC v8.00.00.234 installed) from: 

http://www.qodbc.com\download\qodbcup_237.exe

You will now need to install QODBC v8.00.00.237 and purchase a new CD Key for QuickBooks 2008.

Note: When you install 8.0.0.237, all the QODBC settings may revert back to their defaults. So you need to check all the settings again for QBOE . See: How do I use QODBC with QuickBooks Online? 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-04-04 08:11:24

With the release of QODBC v8.0.0.243 (and higher), a QODBC CD Key will be good for the version it was brought with when using QBOE, so a .08........ serial number will now be good for use with QuickBooks Online Edition as long as you continue to use QODBC v8, but it will not work with QODBC v9.

An advance copy of QODBC v8.0.0.243 can be downloaded using this link: http://www.qodbc.com/download/243/qodbc.exe

 

  Top 
  Richardm 
  
 Group: Members 
 Posts: 2 
 Joined: 2007-06-28 
 Profile
 Posted : 2008-04-16 23:41:32
Hi Tom

I am also having the same problem (QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks.) except that i do not have different regions installed. I have QB UK version 2005,2006 and 2008 installed. QODBC was working fine before and I don't really understand what has happenned. The only thing that changed is that i recently installed QB 2008.

Thanks for your support 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-04-17 11:11:24
See: Two Versions of Canadian QuickBooks 2008, the same thing applies to the UK version of QuickBooks 2008 and Australian and New Zealand versions of QuickBooks 2008/09. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to