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?
|
|
|
|
Tom |
|
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 |
|
|
|
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? |
|
|
|
Tom |
|
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? |
|
|
|
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. |
|
|
|
Tom |
|
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.
|
|
|
|
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
|
|
|
|
Tom |
|
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). |
|
|
|
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. |
|
|
|
Tom |
|
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). |
|
|
|
Tom |
|
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
|
|
|
|