System.Data.Odbc PlatformNotSupportedException

[esso23]

System.Data.Odbc v4.7.0
Platform: Windows Server 2019 version 1809 (build 17763.805)
Runtime: .NET Core 3.1 (Library with odbc dependency is .NET Standard 2.1)
Exception:

System.PlatformNotSupportedException: System.Data.ODBC is not supported on this platform.
   at System.Data.Odbc.OdbcConnection..ctor(String connectionString)
   at Connector.SysCfg.Odbc.OdbcSysCfgRepository..ctor(String dsnName) in D:\Sync\Repositories-Ipecon\paragon-platform\src\Connector.SysCfg\Odbc\OdbcSysCfgRepository.cs:line 28
...

Code:

mConnection = new OdbcConnection($"DSN={mDsnName};");

Additional info:
Just migrated from .NET Framework 4.6.1 to .NET Core 3.1 on the same machine. OdbcConnection worked fine on .NET Framework 4.6.1.
Application is x86.

[esso23]

Ok, I figured out it was because of the .NET Standard, which is not supported. I still see some problems with this though:
It's not the platform that is not supported. I was targeting win-x86 platform which is supported.
I had to go to dotnet/corefx repo, check the System.Data.Odbc.csproj to find out what's going on. On this line:

<GeneratePlatformNotSupportedAssemblyMessage Condition="'$(TargetGroup)' == 'netstandard'">SR.Odbc_PlatformNotSupported</GeneratePlatformNotSupportedAssemblyMessage>

I think the exception is misleading and should be changed to something else.

[ajcvickers]

@esso23 Please attach a small, runnable project or post a small, runnable code listing that reproduces what you are seeing so that we can investigate.

[ligf]

I also encountered a similar problem
The class library refers to odbc, and the console refers to the dll file, and it will prompt "System.Data.ODBC is not supported on this platform."

[roji]

This looks like it should no longer be relevant, as there won't be further versions of .NET Standard and libraries are expected to simply target .NET.

[ActionNamou]

Same issue here. I am new to c# and I was trying to make a connection to an sql table to fill a dataset like this

public static DataSet GetDataSetFromAdapter(DataSet dataSet, string connectionString, string queryString)
        {
            using (OdbcConnection connection =
                       new OdbcConnection(connectionString))
            {
                OdbcDataAdapter adapter =
                    new OdbcDataAdapter(queryString, connection);

                // Open the connection and fill the DataSet.
                try
                {
                    connection.Open();
                    adapter.Fill(dataSet);
                    MessageBox.Show("here u did it");

                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
                // The connection is automatically closed when the
                // code exits the using block.
            }
            return dataSet;
        }

Please let me know how we can fix this error.

[MicahKimel]

I am also having this issue in .net5.0, my code is similar to @ActionNamou

[roji]

@ActionNamou @MicahKimel which .NET version (TFM) are you targetting? Can you please share your csproj file?