Search:  
NamespacesDiscussions.NET v1.1Feedback
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
Ad
MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT
 
 Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com