.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
Odp.NET?
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-oracle' list.


Bruce McCleave
-- Moved from [aspngdata] to [ngfx-oracle] by Swoop Doggy Dogg <Click here to reveal e-mail address> --

Hi All,

I am getting the following error when I try and use the Odp.NET driver
in .NET. Has anyone else seen of fixed this problem?

Line 47: {
Line 48: OraConnection oConn = new OraConnection (_dsn);
Line 49: oConn.Open ();
Line 50: OraDataReader reader = null;
Line 51: try
Source File: c:\work\srds\maveric\com.srds.data\odpconnection.cs
Line: 49

Stack Trace:

[DllNotFoundException: Unable to load DLL (OraOps.dll).]

Oracle.DataAccess.Client.OpsCon.AllocValCtx(OpoConValCtx*&
pOpoConValCtx) +0

Oracle.DataAccess.Client.OraConnection.Open()

com.srds.data.connections.OdpConnection.execute(DReturn& retVal,
BaseCall call, DCall dCall) in
c:\work\srds\maveric\com.srds.data\odpconnection.cs:49

com.srds.data.DEngine.execute(DCall dCall) in
c:\work\srds\maveric\com.srds.data\dengine.cs:100

com.srds.business.User.load(DCall dCall) in
C:\work\SRDS\maveric\com.srds.business\User.cs:33

com.srds.business.User..ctor(String username) in
C:\work\SRDS\maveric\com.srds.business\User.cs:28

maveric.login.Submit1_ServerClick(Object sender, EventArgs e) in
c:\inetpub\wwwroot\maveric\login.aspx.cs:57

System.Web.UI.HtmlControls.HtmlInputButton.OnServerClick(EventArgs e)

System.Web.UI.HtmlControls.HtmlInputButton.System.Web.UI.IPostBackEventH
andler.RaisePostBackEvent(String eventArgument)

System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)

System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

System.Web.UI.Page.ProcessRequestMain()

Thanks,

Bruce
Reply to this message...
 
    
Wallace B. McClure
What is the contents of the "_dsn" variable?

Wally

----- Original Message -----
From: "Bruce McCleave" <Click here to reveal e-mail address>
To: "ngfx-oracle" <Click here to reveal e-mail address>
Sent: Friday, August 02, 2002 12:25 PM
Subject: [ngfx-oracle] Odp.NET?

> -- Moved from [aspngdata] to [ngfx-oracle] by Swoop Doggy Dogg
<Click here to reveal e-mail address> --
[Original message clipped]
Reply to this message...
 
    
Bruce McCleave
It looks like this:

"User Id=uid;Password=pwd;Data Source=host-db"

I can connect via the ole db and Enterprise manager, so I think this is
a configuration issue or security, but I'm not sure.

~Bruce

-----Original Message-----
From: Wallace B. McClure [mailto:Click here to reveal e-mail address]
Sent: Friday, August 02, 2002 10:24 AM
To: ngfx-oracle
Subject: [ngfx-oracle] Re: Odp.NET?

What is the contents of the "_dsn" variable?

Wally

----- Original Message -----
From: "Bruce McCleave" <Click here to reveal e-mail address>
To: "ngfx-oracle" <Click here to reveal e-mail address>
Sent: Friday, August 02, 2002 12:25 PM
Subject: [ngfx-oracle] Odp.NET?

> -- Moved from [aspngdata] to [ngfx-oracle] by Swoop Doggy Dogg
<Click here to reveal e-mail address> --
[Original message clipped]

| [ngfx-oracle] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-oracle.asp = JOIN/QUIT
Reply to this message...
 
    
Wallace B. McClure
can you do a tnsping of the host-db entry?

Wally

----- Original Message -----
From: "Bruce McCleave" <Click here to reveal e-mail address>
To: "ngfx-oracle" <Click here to reveal e-mail address>
Sent: Friday, August 02, 2002 1:49 PM
Subject: [ngfx-oracle] Re: Odp.NET?

[Original message clipped]
Reply to this message...
 
    
Lachlan Pitts
Ironman,

I have heard rumours that the default NTFS directory security is the =
issue with access to OraOPS.dll. Just ensure that the user context =
attempting to run the ODP is able to read the directory where OraOPS.dll =
exists. (For local testing, giving "Everyone" Read privileges might work =
- DO NOT GO LIVE with this configuration though).

Hope this helps,

Lachlan Pitts

-----Original Message-----
From: Wallace B. McClure [mailto:Click here to reveal e-mail address]
Sent: Saturday, August 03, 2002 4:37 AM
To: ngfx-oracle
Subject: [ngfx-oracle] Re: Odp.NET?

can you do a tnsping of the host-db entry?

Wally

----- Original Message -----=20
From: "Bruce McCleave" <Click here to reveal e-mail address>
To: "ngfx-oracle" <Click here to reveal e-mail address>
Sent: Friday, August 02, 2002 1:49 PM
Subject: [ngfx-oracle] Re: Odp.NET?

[Original message clipped]

| [ngfx-oracle] member Click here to reveal e-mail address =3D YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-oracle.asp =3D JOIN/QUIT
Reply to this message...
 
 
System.Collections.Specialized.NameValueCollection
System.DllNotFoundException
System.EventArgs
System.Web.UI.HtmlControls.HtmlInputButton
System.Web.UI.IPostBackEventHandler
System.Web.UI.Page




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification