QODBC Installation Incomplete? |
Author |
Message |
|
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 |
|
|
|
Tom |
|
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. |
|
|
|
|
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 |
|
|
|
Tom |
|
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 |
|
|
|
|
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. |
|
|
|
Tom |
|
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 |
|
|
|
|
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. |
|
|
|
|
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 ... |
|
|
|
Tom |
|
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
|
|
|
|