Connect to Nexus DB using ODBCConnection in dotnetcore

Question

Connect to Nexus DB using ODBCConnection in dotnetcore

I am trying to connect to NexusDB using in namespace . I can run the same code on my machine using a running console application . I have a NexusDB V3.09 driver installed on my machine. ODBCConnection System.Data.Odbc .NetFramework 4.6.1

Below is my code:

string conns = "DRIVER={NexusDB V3.09 Driver};Transport=TCP;SERVER=NexusDB@ipAddressValue;PORT=16000;DataBase=DBName;";

        using (var conn = new OdbcConnection(conns))
        {

            string maxNumberQuery = "SELECT MAX(NUMBER) FROM CLIENT";
            OdbcCommand oCmd = new OdbcCommand(maxNumberQuery, conn);
            conn.Open();
            result = (int)oCmd.ExecuteScalar();

        }