urgent: .NET Provider for Oracle or Oracle Data Provider for .NET

If I want to access Oracle DB in ASP.NET application, and I am using .NET Provider for Oracle or Oracle Data Provider for .NET, should I have to install OracleClient on my .NET server? Is there other choice? Thank you very much.


Johnson
0
Johnson2007
2/22/2008 7:42:15 AM
asp.net.oracle 2269 articles. 0 followers. Follow

10 Replies
1512 Views

Similar Articles

[PageSpeed] 52

Johnson2007:
should I have to install OracleClient on my .NET server?
 

You have to options

1. install the ODP.NET on your web server

OR

2. put the oracle assemblies in your BIN directory 

0
jimmy
2/22/2008 9:38:32 AM

 Hi jimmy,

Thank you for you reply. Because I could not find a server right now, I should test it first before I agree or disagree with you, as most articles I have seen said that it require a Oracle Client to be installed(such as http://download.oracle.com/docs/cd/B19306_01/win.102/b14307/install001.htm#sthref61). I will test it soon. Thank you.
 


Johnson
0
Johnson2007
2/22/2008 10:09:09 AM

Eventhough u install the client software with out having the  oracle database what u will do?.

Plz correct me if i m wrong.

Thank u

Baba

Please remember to click "Mark as Answer" on this post if it helped you. 


Thank u

Baba

Please remember to click "Mark as Answer" on this post if it helped you.
0
srijaya_ramaraju
2/25/2008 6:11:46 AM

 Hi Jimmy,

Thank you very much. I tried your 1st method. And it works now. Thank you very much. But for you second method, would you please offer some more guide? or provide some url? Thank you. 


Johnson
0
Johnson2007
2/25/2008 9:37:12 AM

 

srijaya_ramaraju@yahoo.com:
Eventhough u install the client software with out having the  oracle database what u will do?.

Because the DB is installed on the DB Server.


Johnson
0
Johnson2007
2/25/2008 9:39:31 AM

Johnson2007:
Thank you very much. I tried your 1st method. And it works now. Thank you very much. But for you second method, would you please offer some more guide? or provide some url? Thank you. 
 

If you are using a web application project, you will have a references node in your solution explorer under your website. This will list all assemblies that are consumed by your application, so you can select all the oracle DLLS and set it to COPY TO LOCAL to true so that the DLLS will be copied to your BIN folder. That way when you deploy your website you jsut need to deploy it with all the files in your BIN directory 

0
jimmy
2/25/2008 9:44:18 AM

Thank you,

I just don't know which oracle DLL files to be referenced. I know the first method, I referenced the Oracle.DataAccess.dll file. But I am now sure the second method. Thank you very much.

[Update] 

 And I do not get idea where to find the oracle dlls you mentioned. Would you please offer some further help? I am using VS2005. thanks.
 


Johnson
0
Johnson2007
2/25/2008 9:52:47 AM

The .dll you need to reference to is Oracle.DataAccess.dll, you should be able to find it in your Oracl Home's bin folder(i.e mine is c:\programm files\oracle_client10g\bin), or if you still do not know where is your oracle home at, do a search on Oracle.DataAccess.dll

0
tryAsp6677
2/25/2008 4:38:09 PM

Hi tryAsp6677, 

Thanks. This method is the first method mentioned by Jimmy. If I did not make any wrong I followed the guide at http://www.oracle.com/technology/pub/articles/cook_dotnet.html . I am not sure the second method [2. put the oracle assemblies in your BIN directory] mentioned by Jimmy very exactly. and I need further help. Thank you very much for sharing.


Johnson
0
Johnson2007
2/26/2008 2:17:27 AM

Search and find where your Oracle.DataAccess.dll is at, copy it and paste in your asp.net project's bin folder, if you do not have one yet, using VS open your website, then right click on the website name and select "Add asp.net folder-->bin". By doing this, you do not have to install odp.net on your web server, when you publish your website to the server, the .dll in the asp.net bin folder will be copied over to your webserve.

0
tryAsp6677
2/26/2008 11:35:39 AM
Reply:

Similar Artilces:

which is shou i use? Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NET
Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NETI am confused?Which is better or which one should I use?BTW, I am going to use .net 2.0 with oracle 9. Can anyone tell me what shou I use for working with oracle database?Thanks very much in advance!Justin Oracle's data provider has more functionality than Microsoft's.If your doing transaction processing you can have SAVEPOINTs, which Microsoft's data provider does not provide.Also, Oracle has PL/SQL Associative Arrays which are very powerful.Oracle also allows you to bind parameters by name and pos...

Return an Oracle Ref Cursor to a .NET DataReader object by using the .NET Managed Provider for Oracle
Hello, I am wondering if anyone in this community knows the shorter way to return an Oracle Ref Cursor to a .NET DataReader object by using the .NET Managed Provider for Oracle, something likereturn (IDataReader) SqlHelper.ExecuteReader(ConnectionString, "GET_ACCOUNT", Id); instead of using the way below (look at the C# code) Stored Procedure create or replace PROCEDURE "GET_ACCOUNT" ( p_ID IN ACCOUNT.ID%type, retCursor OUT SA.MYGEN.sqlcur ) IS BEGIN OPEN retCursor FOR SELECT ID, NAME FROM ACCOUNT WHERE ID = p_ID ; ...

.NET Oracle Provider
Hi all,I am using .NET 2.0 Frameworks Oracle provider and it does not have a OracleDbTypes Type for me to use. I would like to create a parameter that is of the Oracle type NVARCHAR, but it seems I can only use DbTypes, which does not have this. If I used DbTypes.String, would this be ok, otherwise, how else can I be more specific about the Oracle Parameter data type?Thanks  can u explain which type of data u r going to storeThank uBaba Thank uBabaPlease remember to click "Mark as Answer" on this post if it helped you. What's your version of ODP? You have OracleD...

Which .Net Provider for Oracle 9i Microsoft or Oracle
Can anyone provide me pros and cons of provider to access Oracle Database ? I am aware of Microsoft Provider and Oracle Provider. Microsoft http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/manprooracperf.asp Oracle http://otn.oracle.com/software/tech/windows/odpnet/utilsoft.html I guess you can use either. But as some post suggests, if both installed, then MS ODP will not work. I've been using DataDirect Technologies Connect for .Net and Oracle. It's not free, so it depends on your budget. The speed improvements were great for us, and it's ni...

Oracle Spatial support in Devart's ADO.NET Data Provider for Oracle [Edit]
dotConnect for oracle v. 7.3 http://www.devart.com/dotconnect/oracle/ , ADO.NET Provider from Devart, includes support for Oracle Spatial in the projects, using Entity Framework. Devart Team constantly implements all the available Entity Framework innovations, and shortly after the introduction of DbGeometry and DbGeography classes in Entity Framework 5 has implemented support for Oracle Spatial in the Entity Framework provider for Oracle. Oracle MDSYS.SDO_GEOMETRY object type can now be mapped to DbGeometry and DbGeography classes. Now dotConnect for Oracle includes new versions of Devar...

Choosing Oracle Client Version with Microsoft Managed Oracle Provider For .net
We need to change the Oracle Client that the System.Data.OracleClient uses to connect to our database on a server that has multiple versions of the Oracle Client. A different application on the server that we do not have control over is requiring the default ORACLE_HOME directory to remain an older Oracle 9i version of the client. Because of this, our applications using the Managed Oracle Provider for .net are using the 9i client to connect. We have a planned Oracle upgrade for our Database that will require us to use the new 10g version of the client that is also installed on the server, bu...

reference for .net data provider for Oracle
Does anybody know of a reference for the new .net data provider for Oracle. In the MSDN site there is still only references for the Sql Server data provider and the oledb provider. Or should I just use the sql server reference and substitute oracle for sql? Here you go... http://www.microsoft.com/downloads/release.asp?ReleaseID=40032&area=search&ordinal=1 Anil - - http://SecureCoder.com - Architecture & Security in an Insecure World - thanks, but that wasnt' what I was looking for. I was hoping for more of a reference like at http://msdn.microsoft.com/lib...

Not seeing Oracle Data Provider for .NET in Change Data Source window
We've been chasing this down for a couple of days now, and for some reason haven't found an answer as to why. Problem: We've installed Oracle Developer Tools for Visual Studio .NET with Oracle 10g Release 2 ODAC 10.2.0.2.21... but we are not seeing the Oracle Data Provider for .NET in the Change Data Source window of VS2005 Team Edition. I've seen many posts and helpful sites that show this as an option after installing said product.  We've installed and reinstalled, and have checked the GAC, machine.config and registry settings, but it is not showing up.  It ...

Oracle Data Providers and NET 2.0
I am trying to gather a list of possible .NET 2.0 Data PRoviders to access an Oracle database other than the Microsoft Oracle provider and ODP.NET. Anyone using any that they would recommend and are industrial strength?Thanks,Bill KBill KirkmanConcentra Preferred Systemsbkirkman@-nospam-concentra.com Here is the link . http://www.datadirect.com/products/net/index.ssp Actually I don't use this product but people said it's much faster than the microsoft and the oracle data provider. ...

Oracle Data Provider for .NET 2.0
Does anybody know where to find the Oracle Data Provider for ASP.NET 2.0 (if it exists)?Thanks Hello, You can use the SQLDataSource to connect to Oracle.  SQL doesn't mean SQL Server, but rather a SQL database.Brian"Trust in the Lord and do what is good; dwell in the land and live securely. Take delight in the Lord, and He will give you your heart's desires" (Psalm 37: 3-4).  T ry the link below I am not saying it includes the Asp.net 2.0 provider but this is a new tool from Oracle.  Hope this helps.http://www.oracle.com/webapps/dialogue/dlgpage.jsp?p_dlg_i...

Inside Oracle .net Provider
I am developing a windows app which uses Oracle as the database. I am using the Microsoft's System.Data.OracleClient to access the oracle database.  Is it required for the Client's machine to have Oracle client installed on their machine to access the database? This application is running against the Oracle database on the server. Forgive my question, I am a newbie to Oracle. Thanks,Satya - Satya(Mark this reply as Answer, if you find it useful) Yes You ned to install Oracle client on your client system. But i think there will be work arround if you dont want to install....

Problems retrieving REF Cursor with .Net Oracle Provider (System.Data.OracleClient)
Hi , I created a package which recieves 3 parameters. One of them, is a type that I created using ref cursor, likewise the example provided in the .Net Oracle Client Documentation and inside msdn site (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcontheadonetdatareader.asp the part which talks about Ref Cursor). I´ve already tested the package, and it´s working properly. But when I tried to run the ExecuteReader method of my Oracle Command I got the error "PLS-00306: wrong number or types of arguments in call to 'PAGINAR'". Her...

Oracle Data Provider for .NET and Visual Web Developer 2008 Express Edition
Hi All, Can we use ODP.net with Visual Web Developer 2008 Express Edition?If yes, which version of ODP.net has to be installed and if not, what is the alternative for this? I have ODTwithODAC10202 installed on my machine. But when I run my application, I am getting the following Exception, The type intializer for Oracle.DataAccess.Client.OracleConnection threw an Exception. Hope any body could suggest me the right solution and guide me furthur. Thanks, Lakshya Friend, ODP.Net has the support to Visual Studio 2008, here is the link for that http://www.oracle.com/technology/s...

How call a Oracle Function using Microsoft .Net Oracle Client (System.Data.OracleClient)?
I try to call Oracle Function in .net C# by using System.Data.OracleClient. But i am not successful. Here is my code FUNCTION TTHAO_MONTT_EXISTS ( vten varchar2) RETURN boolean IS ret boolean; montt_id integer; BEGIN ret:=false; montt_id:= -1; select monthethao_id into montt_id from TTHAO_MONTHETHAO where ten = vten; if montt_id!=-1 then ret:=true; end if; return ret; Exception when others then return false; END; I do not know, when I call function TTHAO_MONTT_E...

Web resources about - urgent: .NET Provider for Oracle or Oracle Data Provider for .NET - asp.net.oracle

Provider - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Providers - Wikipedia, the free encyclopedia
Jeppe Federspiel and Rasmus Stabell started as musicians playing drums. Years later, they joined forces to form Providers, an urban production ...

Facebook App Provider North Social Is Already Thinking About The Holidays
Facebook application provider North Social used its iFrame Editor Facebook app to create a quiz for its Facebook page, with a surprise at the ...

Verizon Wireless selling data cap exemptions to content providers
(credit: Verizon Wireless ) Verizon Wireless, like AT&T before it, is now charging online content providers a fee to get their services exempted ...

Managed service providers succeed by offering security products
A new survey from IT management specialist Kaseya reveals a continued surge in overall growth for managed service providers (MSPs), especially ...

This social entrepreneur told us why businesses should see charities as service providers
... need to change their mindset and give more generously — not just out of social or corporate responsibility but as a main service provider for ...

Cisco Invests in SD-WAN Provider VeloCloud
Channel Partners Cisco Invests in SD-WAN Provider VeloCloud Channel Partners VeloCloud announced this week $27 million in new Series C financing, ...

IDG Contributor Network: What service providers won't tell you about their information security
In the course of my business, I frequently ask IT service providers questions about their information security practices, either as part of a ...

VPN Providers Shrug Off Netflix's Futile War on VPNs, Proxies -
... on VPNs to stop out of region viewing, just a few days after admitting that it was essentially impossible to block VPN use . "Once VPN providers ...

Cisco to Buy IoT Platform Provider Jasper for $1.4 Billion
The deal will enable Cisco to offer a more complete IoT portfolio as customers transition from selling products to selling services, officials ...

Resources last updated: 2/4/2016 5:45:09 AM