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 Installation Incomplete?Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Installation Support Forum

 New Topic 
 
 Post Reply 
[1]  
 QODBC Installation Incomplete? 
 Author   Message 
  Colin Springer 
  
 Group: Members 
 Posts: 5 
 Joined: 2006-11-18 
 Profile
 Posted : 2006-11-18 09:07:36

I'm eager to try using QODBC, particular experimenting with the Web Server edition to access our Quickbooks company file via a  linked database in SQL Server.

I downloaded the demo installer (qodbc.exe) from your website, and started it up.  It reports version 7.0.0.200; I select the USA version, no key, default installation location, and it gets to 21% installed and appears to lock up.  Even "Cancel" does nothing ....  The status displayed is "Skipping file: C:\..\QODBC Driver for QuickBooks\odbcinst.ini".

I'm running Windows XP Professional, and have Quickbooks Enterprise Solutions 6.0 installed.  Please let me know if you need any additional information.

By the way, I was able to successfully install the read-only desktop version of QODBC which was distributed with Quickbooks Enterprise 6.0.

Thanks for any assistance!

Colin

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-11-18 10:24:37
You must be logged into Windows XP with a user account with full admin rights, it can't be a Limited Account. Our installer for the full version of QODBC is different. 

  Top 
  Colin Springer 
  
 Group: Members 
 Posts: 5 
 Joined: 2006-11-18 
 Profile
 Posted : 2006-11-21 01:26:24

Thanks.  My user account has full administrator rights to my machine; I tried running the installer from the local administrator account itself, with the exact same results.

I've also tried rebooting into safe mode and installing from there, thinking that perhaps some running process/service was interfering with the installer, but again had the same results.

No doubt I've missed something simple; hopefully we'll be able to figure it out!

Thanks again,

Colin

 

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

A long shot, check that C:\..\QODBC Driver for QuickBooks\odbcinst.ini and odbc.ini files are not marked as read only files. The installer is also trying to write registry entries at:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\QODBC Driver for QuickBooks
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\QuickBooks Data

 

  Top 
  Colin Springer 
  
 Group: Members 
 Posts: 5 
 Joined: 2006-11-18 
 Profile
 Posted : 2006-11-21 08:41:06

C:\Documents and Settings\All Users\Application Data\QODBC Driver for QuickBooks\odbcinst.ini is definitely not read-only.

C:\Windows\odbc.ini is also read-write.

Looking at the registry, I see the the ODBCINST.INI\QODBC Driver for Quickbooks entries (which is added successfully by the installer since if I rename that key, a new one is generated by the installer).  However the ODBC.INI entry doesn't have a "QuickBooks Data" entry.

Hopefully this helps; let me know if you have any other suggestions.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-11-21 09:09:51

Try editing and adding this to your C:\Windows\odbc.ini file:

Under the [ODBC 32 bit Data Sources] label somewhere add this line:
QuickBooks Data=QODBC Driver for QuickBooks (32 bit)

Then add this new label and settings at the end of the ini file:

[QuickBooks Data]
Driver32=C:\WINDOWS\system32\fqqb32.dll
DBQ=.
OptimizerDBFolder=%UserProfile%\QODBC Driver for QuickBooks\Optimizer

 

  Top 
  Colin Springer 
  
 Group: Members 
 Posts: 5 
 Joined: 2006-11-18 
 Profile
 Posted : 2006-11-21 09:17:09
I'm afraid this had no apparent effect ...  I subsequently also tried adding the corresponding keys to the registry, again with no effect. 

  Top 
  Colin Springer 
  
 Group: Members 
 Posts: 5 
 Joined: 2006-11-18 
 Profile
 Posted : 2006-11-22 02:49:52

Not seeing further suggestions, I spent some time trying to get the installer to work, and was able to get it to complete.

Looking at task manager, I watched which processes were being created.  When the installer locked up, I killed the "rundll32.exe" process which had been started during the installation, and this allowed the installer to continue.  It appeared to complete successfully, although I'm obviously concerned that some piece(s) may not have been installed correctly.

I'm not sure if this gives any further clues as to what the underlying problem was, or if you have any idea as to whether my installation is corrupt.  Obviously my confidence is less than I'd like it to be ...

 

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

Thank you for the feedback. You can check your INSTALL.LOG in C:\Program Files\QODBC Driver for QuickBooks against mine to see if all the components were installed at the end:-

***  Installation Started 10/24/2006 15:06  ***
Title: QODBC Driver Installation
Source: C:\DOCUME~1\Tom\LOCALS~1\Temp\GLB810.tmp
Logging Setup choices made by user
REGION = QuickBooks USA
Destination Directory MAINDIR = C:\Program Files\QODBC Driver for QuickBooks
CMDLINE =
WINOS = 5.1.2600
SYS = C:\WINDOWS\system32
SYS32 = C:\WINDOWS\system32
OEM = N
QBREGION = US
DEVDEBUG =
DEVDSN =
DEVMSG =
DEVSERIAL =
DEVNAME =
INTUIT = N
INTUITEDITION =
INTUITSUPERQUIET = N
Date/Time: Following file not copied.
 File Copy: C:\Program Files\QODBC Driver for QuickBooks\QODBC Manual.pdf
File Overwrite: C:\Program Files\QODBC Driver for QuickBooks\QODBCFUL.EXE
File Overwrite: C:\Program Files\QODBC Driver for QuickBooks\QODBCUPD.EXE
Date/Time: Following file not copied.
 File Copy: C:\Program Files\QODBC Driver for QuickBooks\CPPDEM32.EXE
Date/Time: Following file not copied.
 File Copy: C:\Program Files\QODBC Driver for QuickBooks\VBDEMO32.EXE
Date/Time: Following file not copied.
 File Copy: C:\Program Files\QODBC Driver for QuickBooks\qodbc.lic
Date/Time: Following file not copied.
 File Copy: C:\Program Files\QODBC Driver for QuickBooks\press4qodbc.exe
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\ODBCAD32.EXE
File Overwrite: C:\Program Files\QODBC Driver for QuickBooks\README.RTF
File Overwrite: C:\Program Files\QODBC Driver for QuickBooks\connector.exe
File Overwrite: C:\Program Files\QODBC Driver for QuickBooks\license.txt
File Overwrite: C:\Program Files\QODBC Driver for QuickBooks\images\dfqb.jpg
File Overwrite: C:\Program Files\QODBC Driver for QuickBooks\images\qlogo.gif
File Overwrite: C:\Program Files\QODBC Driver for QuickBooks\QuickBooks Table Schema.url
File Overwrite: C:\Program Files\QODBC Driver for QuickBooks\EditQDSN.exe
Preserve Existing: Following file not copied.
 File Copy: C:\Program Files\QODBC Driver for QuickBooks\qbXMLRP2eQODBCInteractive.exe
Preserve Existing: Following file not copied.
 File Copy: C:\Program Files\QODBC Driver for QuickBooks\qbXMLRPeQODBCInteractive.exe
File Overwrite: C:\Program Files\QODBC Driver for QuickBooks\UNWISE32.EXE
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\VB40032.DLL
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\SSDW3BO.OCX
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\ssr2c.dll
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\ssprn32.dll
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\ssmedt32.dll
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\MSVCRT.DLL
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\MFC42.DLL
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\ssdw3bo.ocx
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\GRID32.OCX
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\ODBCCP32.DLL
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\ODBCINST.HLP
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\ODBCCP32.CPL
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\ODBC16GT.DLL
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\ODBC32GT.DLL
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\DS16GT.DLL
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\DS32GT.DLL
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\ODBCINT.DLL
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\ODBCCR32.DLL
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\ODBC32.DLL
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\MSVCRT20.DLL
Preserve Existing: Following file not copied.
 File Copy: C:\WINDOWS\system32\CTL3D32.DLL
Preserve Existing: Following file not copied.
 File Copy: C:\Documents and Settings\All Users\Application Data\QODBC Driver for QuickBooks\odbcinst.ini
File Overwrite: C:\WINDOWS\system32\FQQB6.exe
File Overwrite: C:\WINDOWS\system32\fqqbc32.exe
File Overwrite: C:\WINDOWS\system32\fqqb32.dll
Shell Link: C:\Documents and Settings\Tom\Start Menu\Programs\QODBC Driver for QuickBooks\README File.lnk
Shell Link: C:\Documents and Settings\Tom\Start Menu\Programs\QODBC Driver for QuickBooks\QODBC Remote Connector.lnk
Shell Link: C:\Documents and Settings\Tom\Start Menu\Programs\QODBC Driver for QuickBooks\Purchase QODBC Pro Now.lnk
Shell Link: C:\Documents and Settings\Tom\Start Menu\Programs\QODBC Driver for QuickBooks\QODBC Setup Screen.lnk
Shell Link: C:\Documents and Settings\Tom\Start Menu\Programs\QODBC Driver for QuickBooks\VB Demo.lnk
Shell Link: C:\Documents and Settings\Tom\Start Menu\Programs\QODBC Driver for QuickBooks\QuickBooks Table Schema.lnk
Shell Link: C:\Documents and Settings\Tom\Start Menu\Programs\QODBC Driver for QuickBooks\Configure QODBC Data Source.lnk
Shell Link: C:\Documents and Settings\Tom\Start Menu\Programs\QODBC Driver for QuickBooks\Uninstall QODBC.lnk
Shell Link: C:\Documents and Settings\Tom\Start Menu\Programs\QODBC Driver for QuickBooks\QODBC Manual.lnk
RegDB Key: Software\Microsoft\Windows\CurrentVersion\Uninstall\QODBC Driver
RegDB Val: QODBC Driver
RegDB Name: DisplayName
RegDB Root: 2
RegDB Old: QODBC Driver
RegDB Key: Software\Microsoft\Windows\CurrentVersion\Uninstall\QODBC Driver
RegDB Val: C:\Program Files\QODBC Driver for QuickBooks\UNINST.BAT
RegDB Name: UninstallString
RegDB Root: 2
RegDB Old: C:\Program Files\QODBC Driver for QuickBooks\UNINST.BAT
RegDB Key: SOFTWARE\QODBC Driver for QuickBooks
RegDB Val: C:\Program Files\QODBC Driver for QuickBooks
RegDB Name: Installation Directory
RegDB Root: 2
RegDB Old: C:\Program Files\QODBC Driver for QuickBooks
RegDB Key: SOFTWARE\QODBC Driver for QuickBooks
RegDB Val: US
RegDB Name: Region
RegDB Root: 2
RegDB Old: US
RegDB Key: SOFTWARE\QODBC Driver for QuickBooks
RegDB Val: N
RegDB Name: IntuitInstaller
RegDB Root: 2
RegDB Old: N
RegDB Key: SOFTWARE\ODBC\ODBC.INI\QuickBooks Data
RegDB Val: C:\WINDOWS\system32\fqqb32.dll
RegDB Name: Driver
RegDB Root: 2
RegDB Old: C:\WINDOWS\system32\fqqb32.dll
RegDB Key: SOFTWARE\ODBC\ODBC.INI\QuickBooks Data
RegDB Val: .
RegDB Name: DBQ
RegDB Root: 2
INI File: C:\WINDOWS\ODBCINST.INI
INI Sect: QODBC Driver for QuickBooks (32 bit)
INI Item: Developer
INI Val:
INI File: C:\WINDOWS\ODBCINST.INI
INI Sect: QODBC Driver for QuickBooks (32 bit)
INI Item: IncludeRaw
INI Val: No
INI Old: No
INI File: C:\WINDOWS\ODBC.INI
INI Sect: QuickBooks Data
INI Item: DBQ
INI Val: .
INI File: C:\WINDOWS\ODBC.INI
INI Sect: QuickBooks Data
INI Item: DFQ
INI Val: .
RegDB Key: SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
RegDB Val: QODBC Driver for QuickBooks
RegDB Name: QuickBooks Data
RegDB Root: 2
RegDB Old: QODBC Driver for QuickBooks
Shared DLL counter ignored:
File Overwrite: C:\WINDOWS\system32\msvci70.dll
Shared DLL counter ignored:
File Overwrite: C:\WINDOWS\system32\msvcr70.dll
Shared DLL counter ignored:
File Overwrite: C:\WINDOWS\system32\msvcr71.dll
File Overwrite: C:\WINDOWS\system32\xerces-c_2_6.dll
File Overwrite: C:\WINDOWS\system32\xerces-com.dll
File Overwrite: C:\WINDOWS\system32\ibizqb3.dll
File Overwrite: C:\WINDOWS\system32\ipwssl6.dll
FLEXquarters Installation Completed
RegDB Key: Software\Microsoft\Windows\CurrentVersion\Uninstall\FLEXquarters QODBC Driver for QuickBooks
RegDB Val: http://www.qodbc.com/faq
RegDB Name: HelpLink
RegDB Root: 2
RegDB Old: http://www.qodbc.com/faq
RegDB Key: Software\Microsoft\Windows\CurrentVersion\Uninstall\FLEXquarters QODBC Driver for QuickBooks
RegDB Val: FLEXquarters.com LLC.
RegDB Name: Publisher
RegDB Root: 2
RegDB Old: FLEXquarters.com LLC.
RegDB Key: Software\Microsoft\Windows\CurrentVersion\Uninstall\FLEXquarters QODBC Driver for QuickBooks
RegDB Val: http://www.qodbc.com/faq
RegDB Name: URLInfoAbout
RegDB Root: 2
RegDB Old: http://www.qodbc.com/faq
Self-Register: C:\PROGRA~1\QODBCD~1\QBXMLR~1.EXE
Self-Register: C:\PROGRA~1\QODBCD~1\QBXMLR~2.EXE
Could not Self-Register: C:\WINDOWS\system32\VB40032.DLL
Self-Register: C:\WINDOWS\system32\ssdw3bo.ocx
Self-Register: C:\WINDOWS\system32\ssr2c.dll
Self-Register: C:\WINDOWS\system32\ssprn32.dll
Self-Register: C:\WINDOWS\system32\ssmedt32.dll
Could not Self-Register: C:\WINDOWS\system32\msvcrt.dll
Self-Register: C:\WINDOWS\system32\mfc42.dll
Self-Register: C:\WINDOWS\system32\ssdw3bo.ocx
Self-Register: C:\WINDOWS\system32\GRID32.OCX
Self-Register: C:\WINDOWS\system32\xerces-com.dll
User Rights: Admin

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to