Database connection with asp.net 3.5 using c#

ODBC is older technology and ADO is newer; it is better to use ADO .Net.
 
There are things that Visual Studio can do for you to make things easier. I know that sometimes it is necessary to configure the VS Toolbox to make some tools available and I think that tools for Oracle are like that; in other words, I think that VS has some tools that you would not know about unless you configure VS for them.

Hi friend,

using System.Data.Odbc;

            OdbcConnection con = new OdbcConnection("");
            try
            {
                con.Open();
            }
            catch (System.Exception ex)
            {
                //Log your exception here for Connection could not created
            }
            OdbcCommand cmd = new OdbcCommand("",con);
            OdbcDataReader rdr= cmd.ExecuteReader();

Hope it helps you.

Thanks.

Please mark "Do you like this post?" if it helps you.

Hi see Here different ways of getting connection string.
Refer

Hi lakshmi,

Check the below link for more details:

http://www.connectionstrings.com/oracle