troubleshooting Question

VB.Net - The provider is not compatible with the version of oracle client

Avatar of Wilder1626
Wilder1626Flag for Canada asked on
Visual Basic.NETOracle Database
8 Comments1 Solution18 ViewsLast Modified:
Hi again.

I'm facing an issue where i'm trying to connect to Oracle Home client 11g 32 bits.

I'm getting below error:

the provider is not compatible with the version of oracle client


I took from from the new Install Oracle folder ODP.NET / BIN / 2x the Oracle.DataAccess.dll
Then, i pasted in the folder bin\Debug\net5.0-windows, where the exe his situated.

Then i added the reference inside the project as below




After all this, i'm getting the error: The provider is not compatible with the version of oracle client


The error i have is on:
cmd As New OracleCommand(sql)

Open in new window


The code i have is below;
Private Sub Button4_Click(sender As Object, e As EventArgs) Handles Button4.Click
 
        Dim oradb As String = "Data Source=datasource;User Id=user;Password=password;"
        Dim conn As New OracleConnection(oradb)
        Dim connect As Object = Nothing

        Try
            conn.Open()
            ' connect.Enabled = False


            Dim sql As String = "Select name from client'"

            Dim cmd As New OracleCommand(sql)
            cmd.CommandType = CommandType.Text

            Dim dr As OracleDataReader = cmd.ExecuteReader()
            dr.Read()

            departments.Items.Add(dr.GetString(0))

        Catch ex As Exception

        End Try
    End Sub
End Class

Open in new window


What do i need to look at to fix the problem?

I'm pretty new to Visual Studio 2019.

Thanks for your help.
ASKER CERTIFIED SOLUTION
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 8 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 8 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004