Which oracle Data provider should I use for C#/VS 2005 ASP 2.0?

Question

User921007156 posted

Hi All,

I have to make my first database connection to Oracle Version: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production, and I wanted to know. What is the best Data provider should I use, using VS 2005 ASP 2.0/C#?

Thanks.

Matt

Answer 1

User1759999623 posted

I would initially try to use the latest 11g provider from Oracle.  If this doesn't work (likely because it's too new for ASP.NET 2.0), then I would try using either the ODBC or OLEDB provider from .NET and try to connect to your Oracle database that way.

Answer 2

User269602965 posted

Lastest ODP.NET fully supports ASP.NET 2.0/3.5 communicating with either Oracle 10g or 11g, 32-bit or 64 bit database.

You will have to install the 32-bit ODP.NET CLIENT in a new Oracle home on the web server or application server if you are running 32-bit compiled applications.

If the database is 64-bit and on the same machine as the web server, you can still use the ODP.NET 32-bit CLIENT install in a new Oracle home and run 32-bit applications.

 

Answer 3

User921007156 posted

I'm having a diffucult time trying to make a database connection from my application. I can connect fine using other database tools, but get errors when try to open a connection within my ASP C# application. The following is one example of the code I'm trying to run.

<--Web Config
<connectionStrings>
        <add name="Oracle_Test" connectionString="Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=Matt;Password=Long;Data Source=TestDV;OLE DB Services=-4"/>
<- Web Config

using System.Data.OleDb;
string cnstring = ConfigurationManager.ConnectionStrings["Oracle_Test"].ToString();
System.Data.OleDb.OleDbConnection m_OracleDBConn = new OleDbConnection(cnstring);
m_OracleDBConn.Open();

// Code

// Close Database
m_OracleDBConn.Close();
m_OracleDBConn.Dispose();

Error Message I'm getting now: Unspecified error: E_FAIL(0x80004005)

Thanks.

Answer 4

User1759999623 posted

Fix your cnstring line:

string cnstring = ConfigurationManager.ConnectionStrings["Oracle_Test"].ConnectionString;

Answer 5

User921007156 posted

I fixed the cnstring line, and I still get connection errors.

Answer 6

User1759999623 posted

Where is the error message occurring?

Answer 7

User921007156 posted

I get the following error message.

[OleDbException (0x80004005): MU???| ????T?]
       System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +968297
       System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +86
       System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +29
       System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +4861516
       System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
       System.Data.OleDb.OleDbConnection.Open() +40

Answer 8

User1759999623 posted

Have you tried using the ODP.NET classes instead of using the System.Data.OleDb classes?

Answer 9

User921007156 posted

No, where can I get an example?

Answer 10

User1759999623 posted

Start here:

http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

Answer 11

User702049738 posted

have you seen this thread below...it  will solve your current problem

http://forums.asp.net/t/1723010.aspx/1?establishing+an+oracle+connection+in+asp+net