Key 'DatabaseOracleODP' is not found!

[spnvelvet]

Dear Sir,
I have tried on Windows XP 32 Bit. Everything works like a charm.
But on Windows 7 64 Bit, same error.

[Alex K.]

Hello,

We tested the adapter under the Win7 x64. We have reproduced the error, but the problem is not in the adapter, and ODAC components, in any application, where we use Oracle.DataAccess the same error occurs. Please try to create a simple application using this feature to check on it.
What version of ODAC do you use?

Thank you.

[spnvelvet]

Dear Sir,
I am using ODAC 11.2.0.1.2.

I have made a complete project with a lot of DataSets and forms.

And there is no error.

[shuhoong]

Hi,

Just my experience in win form application in 64bit machine, you might need to change the compile option to 'x86' instead of 'Any' as there might be a conflict between the application running on 64 bit with a 32bit dll.

Hope this help you out

[Andrew]

Hello,

Sorry for the delay with response.
We still need some time to investigate the issue.

Thank you.

[brunopacola]

Hi!

I have the same problem, but with System.Data.OracleClient

I use Windows 7 64bit
Oracle Client 32bit.



When I compile dll to "Any CPU" ... "OracleConnection" appears but generates exception.

----------------------------
[Customer Explanation]



----------------------------
[General Info]

Application: Stimulsoft Reports.Net
Framework: v2.0.50727
Version: Version: 2011.2.1001 from 18 April 2011
OSVersion: Microsoft Windows NT 6.1.7601 Service Pack 1

----------------------------
[Exception Info]
Message: Tentativa de carregar bibliotecas de cliente Oracle resultou em BadImageFormatException. Esse problema ocorrerá ao executar em modo de 64 bits com componentes de cliente Oracle de 32 bits instalados.

Source: System.Data.OracleClient

StackTrace:
em System.Data.OracleClient.OCI.DetermineClientVersion()
em System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
em System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
em System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
em System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
em System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
em System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
em System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
em System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
em System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
em System.Data.OracleClient.OracleConnection.Open()
em Stimulsoft.Report.Dictionary.OracleConnectionEditor.bTest_Click(Object sender, EventArgs e)

----------------------------
[Assemblies]
mscorlib, Version = 2.0.0.0
Stimulsoft.Base, Version = 2011.2.1001.0
Stimulsoft.Report, Version = 2011.2.1001.0
Stimulsoft.Report.Design, Version = 2011.2.1001.0
System.Windows.Forms, Version = 2.0.0.0

When I compile to dll "x86" ... "OracleConnection" does not appear



Thanks!

[Alex K.]

Hello,

We need some time for check the issue.

Thank you.

[gunde99]

Hello!

I have exact the same issue trying to use the Oracle ODP.NET connection. I'm using the latest Stimulsoft version 2012.3 and Oracle.DataAccess.dll v.4.112.3.0.

Building the Stimulsoft.Report.OracleODP project as Debug, Any CPU makes it appear in the "Select type of connection" window, but gives BadImageFormatException.
Building the Stimulsoft.Report.OracleODP project as Debug, x86 makes it disappear from the "Select type of connection" window.

Have you found a solution to this?

Regards!

[Alex K.]

Hello,

Please send us the following information:
• Product name and its version;
• Detailed description of the problem and how to reproduce it;
• Your operational system (98, ME, 2000, XP, Vista or 7), its version and localization, installed service-packs;
• Version the of Microsoft .Net Framework package installed and its localization;
• Version of Oracle ODP.NET provider
• Additional information that can help us to solve your problem.

Thank you.

[gunde99]

• Product name and its version;
Stimulsoft Report.NET version 2012.3
Visual Studio 2010 (C#)

• Detailed description of the problem and how to reproduce it;
Extract the zip-file: C:\Program Files (x86)\Stimulsoft Reports.Net\Adapters\OracleODPDatabase.zip
Open in VS2010 and convert the project
Add reference to all Stimulsoft .dll's
Add reference to Oracle.DataAccess.dll (v. 4.112.3.0)
Build the .dll for Framework 4.0
Copy both Oracle.DataAccess.dll and Stimulsoft.Report.OracleODP.dll to C:\Program Files (x86)\Stimulsoft Reports.Net\Bin\
Run C:\Program Files (x86)\Stimulsoft Reports.Net\Bin\Designer.exe
Add connection, Oracle ODP, press Build-button and get the error:

System.BadImageFormatException: Could not load file or assembly 'Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. Ett försök att läsa in ett program med ogiltigt format gjordes.
File name: 'Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342'

• Your operational system (98, ME, 2000, XP, Vista or 7), its version and localization, installed service-packs;
Windows 7 Professional, x64, Service Pack 1

• Version the of Microsoft .Net Framework package installed and its localization;
All frameworks up to v4.0.30319 installed

• Version of Oracle ODP.NET provider
11.2.0.3

• Additional information that can help us to solve your problem.
I've attached the .dll files I'm using

Thanks!