OraFAQ Forum: Windows » Start using ODP.net

Home » Infrastructure » Windows » Start using ODP.net (Oracle 11.0.2.10 Window 10 Pro Visual Studio 2010 IIS 6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Start using ODP.net [message #666072]

Thu, 12 October 2017 01:16

OraFerro
Messages: 433
Registered: July 2011

Senior Member

Hi All,

My team shifted to full Oracle DB instead of a split between SharePoint and Oracle.
I need support as I am trying to start using ODP.net to utilize its bulk insert capabilities.

I used to have Oracle instant client 12 in order to access the database though sqlplus and dbForge (another tool). I have tnsnames.ora placed in Oracle directory on my local machine and the Path environment variable points to it.

I guess the problem is that I tried to install ODAC122010Xcopy_x64 and I guess there is a confusion that takes place. Although sqlplus and dbForge work fine, the application does not work.

In my .net application I am trying to make a simple connection, just to run a query.

Attached is a snapshot from the simple app with the reported error: "There was a mismatch between the processor architecture of the project being built and the processor architecture of the reference "Oracle.DataAccess"

I tried everything I could find on the internet:
- copying Dll directly to my project bin folder
- adjust IIS to allow Enable 32-bit apps
- adjust build target architecture 32-bit to True
- make specific version False for Oracle.DataAccess project reference

Still same error and I am running out of clues.

Regards,
Ferro

Attachment: AppCode.jpg
(Size: 361.97KB, Downloaded 3167 times)

Report message to a moderator

Re: Start using ODP.net [message #666094 is a reply to message #666072]

Fri, 13 October 2017 06:58

Flyby
Messages: 188
Registered: March 2011
Location: Belgium

Senior Member

Did you install ODAC122010Xcopy_...? (the 32-bit version, probably ending with x86)

Report message to a moderator

Re: Start using ODP.net [message #666102 is a reply to message #666094]

Sun, 15 October 2017 02:09

OraFerro
Messages: 433
Registered: July 2011

Senior Member

@Flyby, the one I installed ends with _x64 not x86
a snapshot attached.

In my application, an exception: "Message=An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) Source=Oracle.DataAccess" is fired as soon as the statement:

con = new OracleConnection();

is executed.

Thanks
Ferro

Attachment: Capture.PNG
(Size: 13.77KB, Downloaded 3078 times)

[Updated on: Sun, 15 October 2017 02:09]

Report message to a moderator

Previous Topic:	Start database on Windows (split from hijacked topic)
Next Topic:	ODP.net passing grid data to SP UDT parameter - C#

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 07:44:19 CST 2025