Key 'DatabaseOracleODP' is not found!

[spnvelvet]

I have downloaded "Oracle Data Provider for .NET" from Oracle web site and installed it.

Then downloaded "Oracle Data Provider for .NET Database pack". Then I Compiled the project (Target framework 2.0).
Added services in Stimulsoft Report Designer (for Winforms).

When I clicked on New Connection, I got the following exception.

Kindly tell me why it is occuring and whats the solution.
(I am using Stimulsoft Reports.Ultimate 2010.1, Visual Studio 2010 and ODP.Net 11.2).


************** Exception Text **************
System.Exception: Key 'DatabaseOracleODP' is not found!
at Stimulsoft.Base.Localization.StiLocalization.Get(String category, String key, Boolean throwError)
at Stimulsoft.Report.Dictionary.StiOracleODPDatabase.get_ServiceName()
at Stimulsoft.Report.Design.Dictionary.StiDatabaseSelectForm.StiDatabaseWrapper.ToString()
at System.Windows.Forms.ListControl.GetItemText(Object item)
at System.Windows.Forms.ListBox.NativeAdd(Object item)
at System.Windows.Forms.ListBox.OnHandleCreated(EventArgs e)
at System.Windows.Forms.Control.WmCreate(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ListBox.WndProc(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: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
Designer
Assembly Version: 2010.1.700.0
Win32 Version: 2010.1.700.0
CodeBase: file:///C:/Program%20Files%20(x86)/Stimulsoft%20Reports/Bin/Designer.exe
----------------------------------------
Stimulsoft.Report
Assembly Version: 2010.1.700.0
Win32 Version: 2010.1.700.0
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Stimulsoft.Report/2010.1.700.0__ebe6666cba19647a/Stimulsoft.Report.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Stimulsoft.Base
Assembly Version: 2010.1.700.0
Win32 Version: 2010.1.700.0
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Stimulsoft.Base/2010.1.700.0__ebe6666cba19647a/Stimulsoft.Base.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Stimulsoft.Report.Design
Assembly Version: 2010.1.700.0
Win32 Version: 2010.1.700.0
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Stimulsoft.Report.Design/2010.1.700.0__ebe6666cba19647a/Stimulsoft.Report.Design.dll
----------------------------------------
Stimulsoft.Controls.Win
Assembly Version: 2010.1.700.0
Win32 Version: 2010.1.700.0
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Stimulsoft.Controls.Win/2010.1.700.0__ebe6666cba19647a/Stimulsoft.Controls.Win.dll
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_64/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Stimulsoft.Report.MySqlDatabase
Assembly Version: 2010.1.700.0
Win32 Version: 2010.1.700.0
CodeBase: file:///C:/Program%20Files%20(x86)/Stimulsoft%20Reports/Bin/Stimulsoft.Report.MySqlDatabase.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Stimulsoft.Database
Assembly Version: 2010.1.700.0
Win32 Version: 2010.1.700.0
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Stimulsoft.Database/2010.1.700.0__ebe6666cba19647a/Stimulsoft.Database.dll
----------------------------------------
Stimulsoft.Controls
Assembly Version: 2010.1.700.0
Win32 Version: 2010.1.700.0
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Stimulsoft.Controls/2010.1.700.0__ebe6666cba19647a/Stimulsoft.Controls.dll
----------------------------------------
Stimulsoft.Editor
Assembly Version: 2010.1.700.0
Win32 Version: 2010.1.700.0
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Stimulsoft.Editor/2010.1.700.0__ebe6666cba19647a/Stimulsoft.Editor.dll
----------------------------------------
System.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
Stimulsoft.Report.Helper
Assembly Version: 2010.1.700.0
Win32 Version: 2010.1.700.0
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Stimulsoft.Report.Helper/2010.1.700.0__ebe6666cba19647a/Stimulsoft.Report.Helper.dll
----------------------------------------
Stimulsoft.Report.Win
Assembly Version: 2010.1.700.0
Win32 Version: 2010.1.700.0
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Stimulsoft.Report.Win/2010.1.700.0__ebe6666cba19647a/Stimulsoft.Report.Win.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
Stimulsoft.Report.OracleODP
Assembly Version: 2010.1.700.0
Win32 Version: 2010.1.700.0
CodeBase: file:///C:/Program%20Files%20(x86)/Stimulsoft%20Reports/Bin/Stimulsoft.Report.OracleODP.DLL
----------------------------------------
MySql.Data
Assembly Version: 6.3.3.0
Win32 Version: 6.3.3.0
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/MySql.Data/6.3.3.0__c5687fc88969c44d/MySql.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.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:





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.

[Alex K.]

Hello,

Please download the latest prerelise build, check it and let us know about the result.

Thank you.

[spnvelvet]

Downloaded Pre-Release build of dlls.
After making Stimulsoft.Report.OracleODP.dll, copied to Bin directory.
Also copied Oracle.DataAccess.dll to Bin directory.

Now when I click on Build button in New Connection dialog, I got the following error.


************** Exception Text **************
System.BadImageFormatException: Could not load file or assembly 'Oracle.DataAccess, Version=2.112.1.2, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. An attempt was made to load a program with an incorrect format.
File name: 'Oracle.DataAccess, Version=2.112.1.2, Culture=neutral, PublicKeyToken=89b483f429c47342'
at Stimulsoft.Report.Dictionary.StiOracleODPDatabase.EditConnectionString(String connectionString)
at Stimulsoft.Report.Dictionary.Design.StiSqlDatabaseEditForm.buttonBuild_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.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.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
Designer
Assembly Version: 2010.2.764.0
Win32 Version: 2010.2.764.0
CodeBase: file:///C:/Users/Leafcon/Desktop/UL_2010.09.15_Trial/Designer.exe
----------------------------------------
Stimulsoft.Report
Assembly Version: 2010.2.764.0
Win32 Version: 2010.2.764.0
CodeBase: file:///C:/Users/Leafcon/Desktop/UL_2010.09.15_Trial/Stimulsoft.Report.DLL
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Stimulsoft.Base
Assembly Version: 2010.2.764.0
Win32 Version: 2010.2.764.0
CodeBase: file:///C:/Users/Leafcon/Desktop/UL_2010.09.15_Trial/Stimulsoft.Base.DLL
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Stimulsoft.Report.Design
Assembly Version: 2010.2.764.0
Win32 Version: 2010.2.764.0
CodeBase: file:///C:/Users/Leafcon/Desktop/UL_2010.09.15_Trial/Stimulsoft.Report.Design.DLL
----------------------------------------
Stimulsoft.Controls.Win
Assembly Version: 2010.2.764.0
Win32 Version: 2010.2.764.0
CodeBase: file:///C:/Users/Leafcon/Desktop/UL_2010.09.15_Trial/Stimulsoft.Controls.Win.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Stimulsoft.Report.OracleODP
Assembly Version: 2010.2.764.0
Win32 Version: 2010.2.764.0
CodeBase: file:///C:/Users/Leafcon/Desktop/UL_2010.09.15_Trial/Stimulsoft.Report.OracleODP.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Stimulsoft.Database
Assembly Version: 2010.2.764.0
Win32 Version: 2010.2.764.0
CodeBase: file:///C:/Users/Leafcon/Desktop/UL_2010.09.15_Trial/Stimulsoft.Database.DLL
----------------------------------------
Stimulsoft.Controls
Assembly Version: 2010.2.764.0
Win32 Version: 2010.2.764.0
CodeBase: file:///C:/Users/Leafcon/Desktop/UL_2010.09.15_Trial/Stimulsoft.Controls.DLL
----------------------------------------
Stimulsoft.Editor
Assembly Version: 2010.2.764.0
Win32 Version: 2010.2.764.0
CodeBase: file:///C:/Users/Leafcon/Desktop/UL_2010.09.15_Trial/Stimulsoft.Editor.DLL
----------------------------------------
Stimulsoft.Report.Helper
Assembly Version: 2010.2.764.0
Win32 Version: 2010.2.764.0
CodeBase: file:///C:/Users/Leafcon/Desktop/UL_2010.09.15_Trial/Stimulsoft.Report.Helper.DLL
----------------------------------------
Stimulsoft.Report.Win
Assembly Version: 2010.2.764.0
Win32 Version: 2010.2.764.0
CodeBase: file:///C:/Users/Leafcon/Desktop/UL_2010.09.15_Trial/Stimulsoft.Report.Win.DLL
----------------------------------------
Stimulsoft.Report.Design.WebViewer
Assembly Version: 2010.2.764.0
Win32 Version: 2010.2.764.0
CodeBase: file:///C:/Users/Leafcon/Desktop/UL_2010.09.15_Trial/Stimulsoft.Report.Design.WebViewer.DLL
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.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:





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.

[Alex K.]

Hello,

We check Oracle Data Provider for .NET Database pack (OracleODP) and could not reproduce this error.
Are ODAC Components installed on that PC?

Thank you.

[spnvelvet]

Yes sir, I have downloaded ODTwithODAC112012.zip from Oracle web site.
Uncompressed it and installed Oracle Client Components.
(I am using Windows 7 Ultimate 64 Bit and Oracle 11g R2)

[Alex K.]

Hello,

In this case, Oracle.DataAccess cannot be loaded (Could not load file or assembly 'Oracle.DataAccess')
Compile the adapter to the latest prerelease build. Please try reinstalling ODAC components.

Thank you.

[spnvelvet]

Dear Sir, if there would be a problem with data provider, I should not be able to use in Winforms and Web projects.
But all of my forms accessing data from Oracle use the same adapter and work perfectly.

I uninstalled and then re-installed the Oracle tools for Visual Studio which contain ODP.Net.

I am using latest version of Oracle tools for Visual Studio (available on oracle.com).

Feeling helpless.

[Alex K.]

Hello,

We have tested this adapter on multiple machines, errors occur only if there are some problems with Oracle.DataAccess. Please let us know how do you add this library in the reference when compiling the adapter?

Thank you.

[spnvelvet]

Dear Sir, this is what I am doing.

[Alex K.]

Hello,

When you add a reference Oracle.DataAccess try add in tab ".NET" instead "Browse" tab.
Please see the sample video on www.stimulsoft.com/private/OracleODPVideo.zip

Thank you.