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)
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
' 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()
Catch ex As Exception
What do i need to look at to fix the problem?
I'm pretty new to Visual Studio 2019.
Thanks for your help.