none
Connect to Oracle 8i from .Net 4.0 RRS feed

  • Question

  • Wanted to connect to Oracle database 8i from C# .net 4.0 Visual Studio 2010 that is on a 64 bit Windows 2008 r2.

    I was able to connect to newer version of Oracle using ODP.net But when it comes to 8i i get the error message that it is not supported anymore.

     

    I tried to install Oracle9i Client  but i was getting an error message as "OUI Cannot determine the platform of the system". Is it because Oracle 91 cannot be installed on 64 bit Windoes 2008 ?

    My question is what should i do to connect to Oralce 8i to read data ?

     

     

     


    Biju Jacob
    Wednesday, November 9, 2011 8:47 PM

Answers

  • AFAIK, there is no version of ODP.NET for Oracle 8i. I don't even believe that Oracle supports 8i anymore. The oldest version supported by ODP.NET is 9.2.

    You can use the built-in System.Data.OracleClient, but keep in mind it's being deprecated and may not be included in versions of the .NET Framework after 4.0.

    EDIT: I forgot to mention that you can also use System.Data.OleDb or System.Data.Odbc with the respective Microsoft or Oracle OLEDB/ODBC drivers.

    http://www.connectionstrings.com/oracle


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Thursday, November 10, 2011 3:54 PM

All replies

  • AFAIK, there is no version of ODP.NET for Oracle 8i. I don't even believe that Oracle supports 8i anymore. The oldest version supported by ODP.NET is 9.2.

    You can use the built-in System.Data.OracleClient, but keep in mind it's being deprecated and may not be included in versions of the .NET Framework after 4.0.

    EDIT: I forgot to mention that you can also use System.Data.OleDb or System.Data.Odbc with the respective Microsoft or Oracle OLEDB/ODBC drivers.

    http://www.connectionstrings.com/oracle


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Thursday, November 10, 2011 3:54 PM
  • Hi Biju,

    I'm using Devart's dotconnect to connect to our old 8i oracle.

     

    http://www.devart.com/dotconnect/oracle/

    Works like a charm :) 

    Tuesday, January 3, 2012 1:44 PM
  • The best way to connect an Oracle 8.1.7.0 and higher is through Instant Client. Download Instant client 10.2 from Oracle site:

    http://www.oracle.com/technetwork/topics/winx64soft-089540.html,

    Copy all extraxted files in the same folder where .NET  assemblies resides and use Oracle* classes located in System.Data.OracleClient. This work for me in .NET 4 application running in Windows 2008 x64 R2and Oracle DB 8.1.7.0 server.

                    using (OracleConnection connection = new OracleConnection(textBox1.Text))
                    {
                        connection.Open();

                        OracleCommand command = new OracleCommand(textBox2.Text, connection);

                        OracleDataAdapter dataAdapter = new OracleDataAdapter(command);

                        DataSet dataSet = new DataSet();

                        dataAdapter.Fill(dataSet);

                        if (dataSet.Tables.Count > 0)
                        {
                            dataGridView1.DataSource = dataSet.Tables[0];
                        }
                        else
                        {
                            MessageBox.Show("No se obtuvieron tablas");
                        }
                    }



    La vanguardia es así ...



    • Proposed as answer by Niko78 Thursday, September 20, 2012 6:50 PM
    • Edited by Niko78 Thursday, September 20, 2012 6:55 PM
    Thursday, September 20, 2012 6:50 PM