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 : Help - Do I need to get a new license.Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v8 Forum

 New Topic 
 
 Post Reply 
[1]  
 Help - Do I need to get a new license. 
 Author   Message 
  Neal 
  
 Group: Members 
 Posts: 27 
 Joined: 2006-07-23 
 Profile
 Posted : 2007-10-18 12:00:23

In Aug of 2007 I purchased a new license because quickbooks upgraded thier product. (Even so I didn't see any new features in QB). Now two months later it appears that Quickbooks has again upgraded(?). Last time it took me a week to rework everything, it looks like it is going to be the same this time.

I reley on QB and QODBC to work properly together. If they do not, I cannot effectively bill my client and I don't get paid. I must have a stable system. Because of this huge problem, I have little choice but to move from the online version to a stand alone version. Will I need to purchase a new license if I do?

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-10-18 16:46:36
Intuit changed the major revision for QuickBooks Online Edition (QBOE) again. All you need to do to get you going again is to install a updated version of QODBC, see: Release 8.0.0.236 Fixes  

  Top 
  Neal 
  
 Group: Members 
 Posts: 27 
 Joined: 2006-07-23 
 Profile
 Posted : 2007-10-18 21:10:49
I did the upgrade and it did not work. I redid the startup procedure. It still did not work. I keep getting an API error. The one that says you need API 1.1 or 2.0. I try redoing the upgrade, the start up procedure and rebooting - I still received the API error.

I found serveral posts on API errors refering to having 2 versions on Quickbooks install,  I check, I do not have Quickbooks installed on my computer. (I'm using the online version)

So what's the next step? 

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

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 
  Neal 
  
 Group: Members 
 Posts: 27 
 Joined: 2006-07-23 
 Profile
 Posted : 2007-10-22 12:31:12

OK I downloaded and installed QODBC_237.exe. I went through the startup procedure and set everything for the online version. I also activated the drivers. Once complete I hit "Apply". I then tried the "Test Connection"  in the general and tried to start a connecton duesing the VB Demo application. Both failed. Below is a copy of the errors from the log.


2007-10-17 19:54:38 QODBC Ver:  8.00.00.236 *********************************************************************************************************************
IsAService: False
Error Getting Version

2007-10-17 19:55:44 QODBC Ver:  8.00.00.236 *********************************************************************************************************************
IsAService: False
Error Getting Version

2007-10-17 19:56:57 QODBC Ver:  8.00.00.236 *********************************************************************************************************************
IsAService: False
Error Getting Version

2007-10-17 19:57:15 QODBC Ver:  8.00.00.236 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks.
Begin Session errors can be caused when running ASP or other system service and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector"

What do I need to do now?

 

Thanks for the help.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-10-23 08:04:42
The error log is for QODBC v8.00.00.236 and not v8.00.00.237. Please check that 237 is installed in the About tab of the QODBC Setup Screen. If the installer did not override fqqb32.dll, rename fqqb32.dll to fqqb32.236 first and re-run the installer.

 

  Top 
  Neal 
  
 Group: Members 
 Posts: 27 
 Joined: 2006-07-23 
 Profile
 Posted : 2007-10-23 20:14:55

OK - I renamed the file and reinstalled the drivers. Still get an "Evaluation license has expired!" error. So I turned on the trace log, redid the setup and tried to connect using the VB Demo. Below is the trace log. I removed the IBizRemoteURL and IBizRemoteUserName information for security.

ISAMOpen
    Database: .
    DSN: QuickBooks Data
    UserName:
    Password:
    DeveloperCode:
    ApplicationCode:
    OpenMode: F
    UseDCOM: N
    IBizRemoteConnection: N
    IBizRemoteURL: {removed}
    IBizRemoteUserName: {Removed}
    IBizRemotePassword:
    IBizRemoteAskPassword: Y
    IBizRemoteSSLAcceptServerCert:
    IBizRemoteConnectionTimeOut: 120
    IBizRemoteForce2002_2003: N
    IBizOEConnection: Y
    IBizOETicketGUID: ******************************
    IBizOELoginGUID: **************************************
    IBizOELoginAsk: Y
    IBizReconnectionDelay: 0
    ColumnNameLen: 50
    UseCaseSensitiveRefNumber: Y
    OptimizerOn: Y
    OptimizerDBFolder: C:\Documents and Settings\Neal\Application Data\QODBC Driver for QuickBooks\Optimizer
    OptimizerCurrency: C
    OptimizerDirtyReads: N
    OptimizerUpdateSync: N
    OptimizerEncrytionOn: Y
    ShortCircuitOptimizeFields: N
    UseIterators: Y
    IteratorChunkSize:  500
    IAppLaunchQBUI: N
    IAppAutomaticLogin: Y
    IAppReadOnly: N
    IAppAllowPersonalData: Y
    ConvertToLongVARCHAR: FALSE
    MaxLONGVARCHAR:  4096
    Convert To LONGVARCHAR: N
    Max LONGVARCHAR:   4096
    OleInitialize - Returned OK
    Logged In User:    Neal
    Is a Service:      No
    Registration Name: HouseViewOnline
    RegSerial:         W07U10017146
    QODBC Version:     8.00.00.238
    DLL:               C:\WINDOWS\system32\fqqb32.dll
    Driver Name:       FQQB32.DLL
    Process Count:     1   
   Thread Count:      1
    OpenMode:          Follow Company
    Include Raw:       No
    Version Type:      QODBC Desktop Read Write 2007
    Access Method:     QuickBooks Online Edition
    Thread ID:         4312
    SDK Module:        QuickBooks Online Edition
    QB Company Name:   ? (Error Getting Company Name)
    QB Product Name:   QuickBooks Online Edition
    QB Major Version:  19
    QB Minor Version:  141
    QB Supported Ver:  2.0
    QB Supported Ver:  2.1
    QB Supported Ver:  3.0
    QB Supported Ver:  4.0
    QB Supported Ver:  4.1
    QB Supported Ver:  5.0
    QB Supported Ver:  6.0
    0x00000000 [ISAM]
    S0000 S0000 [QODBC] Evaluation license has expired!
Please contact your dealer for the latest version
    ISAM_DEMO_EXPIRED S0000 S0000 [QODBC] Evaluation license has expired!
Please contact your dealer for the latest version

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-10-24 10:16:38
You need to purchase a new CD Key for QuickBooks 2008. Your Serial number is only for QuickBooks 2007 (W07U10017146). 

  Top 
  Neal 
  
 Group: Members 
 Posts: 27 
 Joined: 2006-07-23 
 Profile
 Posted : 2007-10-24 10:41:55
I just bought a new license less than 3 months ago (7/26/07) and now I need to buy another? I really don't want to upgrade to ver 8, I just want the ver 7 to work. What can be worked out? Given that I have used the driver for less than 90 days, there should be some type of warrenty.  

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-10-24 11:54:47
Please contact your regional sales office directly by phone to discuss your situation. You need to have a QODBC for QuickBooks 2008 CD Key in order to connect to the QuickBooks Online Edition (QBOE). 

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

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 
 New Topic 
 
 Post Reply 
[1]  

Jump to