You are viewing limited content. For full access, please sign in.

Question

Question

Quick Fields 9 has a connection problem doing a lookup to Oracle DB.

Quick Fields Version 9
Updated January 30, 2014
asked on January 27, 2014

 Quick Fields 9 on a 64bit Win7 machine will not connect to Oracle in a Lookup with the client for Oracle 11g. We had it working perfectly on 32 bit machines with Oracle 11g client and upgraded the Quick Fields from 8.3 to 9.0 on a new Win 7 64 bit machine, it no longer seems to want to connect. Not with either the 32bit or 64 bit client. Anybody else run into this problem? Btw, we upgraded a 32 bit ;machine with QF9 as well, it no longer works, but it at least connects. Working on that as well.

0 0

Answer

SELECTED ANSWER
replied on January 30, 2014

After many attempts we finally uninstalled everything.

 

We installed QF9 back then installed only the 32 bit Oracle client. Went back and installed the Oracle ODBC driver throught the "Custom" Oracle install. This seems to have put the driver in the right place so that we can now use the 32 bit client. I have set everything now to use ODBC in the Lookup and the Customize Fields source area. It FINALLY  works. Now I will go and try to recreate this in the computer where everything stopped working all of a sudden and hope it will fix that as well.

0 0

Replies

replied on January 27, 2014

Quick Fields is a 32-bit application, so the 32-bit version of the Oracle driver should be used. What does the error say?

0 0
replied on January 28, 2014

 

This is after applying the following patches

 

0 0
replied on January 28, 2014

Could you copy the text under *******Exception Text********** and paste it here, please? Or have your reseller open a support case with that information.

0 0
replied on January 29, 2014

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
Laserfiche.NotLocalizedException: The data source type 'Laserfiche.Project.Data.Runtime.Oracle, Laserfiche.Project.Data.3rdParty, Version=9.0.0.0, Culture=neutral, PublicKeyToken=607dd73ee2bd1c00' could not be found.
   at Laserfiche.Project.Data.Design.DataSourceDesigner.Create(TypeConfigurationFile typeConfigurationFile)
   at Laserfiche.QuickFields.Wizards.Data.ConfigureDataSourceWizardDriver.HandleProviderPageClosed(Boolean fromNext, PageEventArgs e)
   at Laserfiche.QuickFields.Wizards.Data.ConfigureDataSourceWizardDriver.HandleProvderPageClosedNext(Object sender, PageEventArgs e)
   at Laserfiche.UI.Wizard.WizardPage.OnCloseFromNext(Wizard wizard)
   at Laserfiche.UI.Wizard.Wizard.Next()
   at Laserfiche.UI.Wizard.Wizard.btnNext_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18052 built by: FX45RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Laserfiche.QuickFields
    Assembly Version: 8.1.0.0
    Win32 Version: 9.0.0.460
    CodeBase: file:///C:/Program%20Files%20(x86)/Laserfiche/Quick%20Fields%208.0/Laserfiche.QuickFields.exe
----------------------------------------
Laserfiche.QuickFields.Base
    Assembly Version: 8.1.0.0
    Win32 Version: 9.0.0.460
    CodeBase: file:///C:/Program%20Files%20(x86)/Laserfiche/Quick%20Fields%208.0/Laserfiche.QuickFields.Base.DLL
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18036 built by: FX45RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18021 built by: FX45RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18034 built by: FX45RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Laserfiche.BatchProcessor
    Assembly Version: 8.1.0.0
    Win32 Version: 9.0.0.460
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Laserfiche.BatchProcessor/v4.0_8.1.0.0__35de22b2ae3b724a/Laserfiche.BatchProcessor.dll
----------------------------------------
Laserfiche.Project
    Assembly Version: 9.0.0.0
    Win32 Version: 9.1.0.330
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Laserfiche.Project/v4.0_9.0.0.0__607dd73ee2bd1c00/Laserfiche.Project.dll
----------------------------------------
Laserfiche.Base
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.0.427
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Laserfiche.Base/v4.0_9.0.0.0__607dd73ee2bd1c00/Laserfiche.Base.dll
----------------------------------------
LfLicenseReader
    Assembly Version: 9.0.0.2
    Win32 Version: 9.0.0.3
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/LfLicenseReader/v4.0_9.0.0.2__607dd73ee2bd1c00/LfLicenseReader.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
Interop.BPINTERFACES81Lib
    Assembly Version: 8.1.0.0
    Win32 Version: 8.1.1.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Interop.BPINTERFACES81Lib/8.1.0.0__35de22b2ae3b724a/Interop.BPINTERFACES81Lib.dll
----------------------------------------
Laserfiche.BatchProcessor.UI
    Assembly Version: 8.1.0.0
    Win32 Version: 9.0.0.460
    CodeBase: file:///C:/Program%20Files%20(x86)/Laserfiche/Quick%20Fields%208.0/Laserfiche.BatchProcessor.UI.DLL
----------------------------------------
BatchProcessor.Connection
    Assembly Version: 8.1.0.0
    Win32 Version: 9.0.0.460
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/BatchProcessor.Connection/v4.0_8.1.0.0__607dd73ee2bd1c00/BatchProcessor.Connection.dll
----------------------------------------
ImageControl
    Assembly Version: 8.1.0.0
    Win32 Version: 9.0.0.427
    CodeBase: file:///C:/Program%20Files%20(x86)/Laserfiche/Quick%20Fields%208.0/ImageControl.DLL
----------------------------------------
Laserfiche.Project.TabbedUI
    Assembly Version: 8.3.1.0
    Win32 Version: 9.0.2.400
    CodeBase: file:///C:/Program%20Files%20(x86)/Laserfiche/Quick%20Fields%208.0/Laserfiche.Project.TabbedUI.DLL
----------------------------------------
ActiproSoftware.UIStudio.Dock.Net20
    Assembly Version: 2.0.98.0
    Win32 Version: 2.0.98.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ActiproSoftware.UIStudio.Dock.Net20/2.0.98.0__be939c973e8cb8a6/ActiproSoftware.UIStudio.Dock.Net20.dll
----------------------------------------
ActiproSoftware.WinUICore.Net20
    Assembly Version: 1.0.94.0
    Win32 Version: 1.0.94.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ActiproSoftware.WinUICore.Net20/1.0.94.0__1eba893a2bc55de5/ActiproSoftware.WinUICore.Net20.dll
----------------------------------------
ActiproSoftware.Shared.Net20
    Assembly Version: 1.0.94.0
    Win32 Version: 1.0.94.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ActiproSoftware.Shared.Net20/1.0.94.0__36ff2196ab5654b9/ActiproSoftware.Shared.Net20.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Design
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Design/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
AxSessionTree81Lib
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Laserfiche/Quick%20Fields%208.0/AxSessionTree81Lib.DLL
----------------------------------------
SessionTree81Lib
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Laserfiche/Quick%20Fields%208.0/SessionTree81Lib.DLL
----------------------------------------
Accessibility
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
AxInterop.LFImage90Lib
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Laserfiche/Quick%20Fields%208.0/AxInterop.LFImage90Lib.DLL
----------------------------------------
Interop.LFImage90Lib
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.0.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Interop.LFImage90Lib/9.0.0.0__607dd73ee2bd1c00/Interop.LFImage90Lib.dll
----------------------------------------
AxInterop.LFText90Lib
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Laserfiche/Quick%20Fields%208.0/AxInterop.LFText90Lib.DLL
----------------------------------------
Interop.LFText90Lib
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.0.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Interop.LFText90Lib/9.0.0.0__607dd73ee2bd1c00/Interop.LFText90Lib.dll
----------------------------------------
Laserfiche.BatchProcessor.Processes
    Assembly Version: 8.1.0.0
    Win32 Version: 9.0.0.427
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Laserfiche.BatchProcessor.Processes/v4.0_8.1.0.0__35de22b2ae3b724a/Laserfiche.BatchProcessor.Processes.dll
----------------------------------------
Laserfiche.BatchProcessor.XML
    Assembly Version: 8.1.0.0
    Win32 Version: 9.0.0.427
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Laserfiche.BatchProcessor.XML/v4.0_8.1.0.0__35de22b2ae3b724a/Laserfiche.BatchProcessor.XML.dll
----------------------------------------
Laserfiche.QuickFields.Processes
    Assembly Version: 8.1.0.0
    Win32 Version: 9.0.0.460
    CodeBase: file:///C:/Program%20Files%20(x86)/Laserfiche/Quick%20Fields%208.0/Laserfiche.QuickFields.Processes.DLL
----------------------------------------
Laserfiche.Project.Data
    Assembly Version: 9.0.0.0
    Win32 Version: 9.1.0.330
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Laserfiche.Project.Data/v4.0_9.0.0.0__607dd73ee2bd1c00/Laserfiche.Project.Data.dll
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18034 built by: FX45RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Laserfiche.Project.Data.UI
    Assembly Version: 9.0.0.0
    Win32 Version: 9.1.0.330
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Laserfiche.Project.Data.UI/v4.0_9.0.0.0__607dd73ee2bd1c00/Laserfiche.Project.Data.UI.dll
----------------------------------------
Laserfiche.QuickFields.Processes.Runtime
    Assembly Version: 8.1.0.0
    Win32 Version: 9.0.0.460
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Laserfiche.QuickFields.Processes.Runtime/v4.0_8.1.0.0__35de22b2ae3b724a/Laserfiche.QuickFields.Processes.Runtime.dll
----------------------------------------
Laserfiche.QuickFields.MetadataUpdater
    Assembly Version: 8.1.0.0
    Win32 Version: 9.0.0.427
    CodeBase: file:///C:/Program%20Files%20(x86)/Laserfiche/Quick%20Fields%208.0/Laserfiche.QuickFields.MetadataUpdater.DLL
----------------------------------------
Laserfiche.QuickFields.Wizards
    Assembly Version: 8.1.0.0
    Win32 Version: 9.0.0.460
    CodeBase: file:///C:/Program%20Files%20(x86)/Laserfiche/Quick%20Fields%208.0/Laserfiche.QuickFields.Wizards.DLL
----------------------------------------
System.Numerics
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
System.Data.OracleClient
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data.OracleClient/v4.0_4.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll
----------------------------------------
Laserfiche.Project.Data.3rdParty
    Assembly Version: 9.0.0.0
    Win32 Version: 9.1.0.330
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Laserfiche.Project.Data.3rdParty/v4.0_9.0.0.0__607dd73ee2bd1c00/Laserfiche.Project.Data.3rdParty.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

 

0 0
replied on January 29, 2014

Do you have Quick Fields language packs installed?

0 0
replied on January 29, 2014

Not sure. Let me go check.

0 0
replied on January 29, 2014

Ignore that, please. I can reproduce it and it is a bug. We'll look into it.

 

As a workaround, you should be able to Oracle in Lookup by going through the Windows ODBC path in the data source wizard.

0 0
SELECTED ANSWER
replied on January 30, 2014

After many attempts we finally uninstalled everything.

 

We installed QF9 back then installed only the 32 bit Oracle client. Went back and installed the Oracle ODBC driver throught the "Custom" Oracle install. This seems to have put the driver in the right place so that we can now use the 32 bit client. I have set everything now to use ODBC in the Lookup and the Customize Fields source area. It FINALLY  works. Now I will go and try to recreate this in the computer where everything stopped working all of a sudden and hope it will fix that as well.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...