How do I get data after creating ladp oledb connection

See more:

C#

Hello,

I am able to create an OLEDb connection. However, I am not able to retrieve data. I ran the same query in using 'SQL Developer' and it had data.

Please advise.

Thank you.

What I have tried:

I am able to create an OLEDb connection with the following codes:

      var cfg = ConfigurationManager.AppSettings;

      string dirSvr = cfg["ldapServer"];
      string context = cfg["ldapContext"];
      string svcname = cfg["ldapSvcName"];

      string ldapAdress = $"LDAP://{dirSvr}/{context}";
      string query = $"(&(objectclass=orclNetService)(cn={svcname}))";
      string orclnetdescstring = "orclnetdescstring";

        DirectoryEntry directoryEntry = new DirectoryEntry(ldapAdress, null, null, AuthenticationTypes.Anonymous);
        DirectorySearcher directorySearcher = new DirectorySearcher(directoryEntry, query, new[] { orclnetdescstring }, SearchScope.Subtree);

        SearchResult searchResult = directorySearcher.FindOne();
        byte[] value = searchResult.Properties[orclnetdescstring][0] as byte[];

        string descriptor = "";
        if (value != null)
        {
          descriptor = Encoding.Default.GetString(value);
        }
        else throw new Exception("LDAP response was empty");

        string s = "Min Pool Size=1;Max Pool Size=10;Provider=OraOLEDB.Oracle;Pooling=true;User ID=usr;Password=pwd"; Data Source=" + descriptor + ";";
        OleDbConnection con = new OleDbConnection(s);

string strSQL = "Select * from users";

      con.Open(); //success
      OleDbDataAdapter oDA = new OleDbDataAdapter(strSQL, con);
      DataSet ds = new DataSet();
      oDA.Fill(ds);
      con.Close();