Common problem...Connecto to Oracle database

[Budd]

I don't know how to connect to oracle database by asp.net

Anyone have any simple or step for me to connect??
i have no idea.... i have search from google and get the code
But it seen i have miss some step ....

My case is....school have provided the oracle for me to connect
so i need to install oracle client for my pc??

 

[Guest]

Hello,

If you are using Visual Studio 2003:

--> You can use OleDb

for the connection string:
http://www.connectionstrings.com/

Sample:
http://www.csharphelp.com/archives/archive137.html
http://www.c-sharpcorner.com/Database.asp


If you are using 2005, I think there is an Oracle NameSpace (not 100 %
sure about this).

Good Luck
Braulio

--
/// ------------------------------
/// Braulio Díez Colaborador DNM
///
/// http://www.dotnetmania.com
/// My Site (.net Tips): http://www.bdiez.com
/// ------------------------------

 

[Jason Hales]

Yes you do need the Oracle client.

You can use the Oracle Data Provider for .NET (ODP.NET). Using the
OracleConnection class found in Oracle.DataAcess.dll

This might help
http://www.oracle.com/technology/sample_code/tech/windows/odpnet/howto/connect/index.html

 

[Budd]

do i need to oracle clients???

when i test the connection, it show the error that i didn't have oracle
client and compenet