title: Odbc Connection to .tps database not working
body: <p>I am trying to select some fields from .tps file but I am getting the following error:
  <a href="https://i.stack.imgur.com/yIR1K.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yIR1K.jpg" alt="enter image description here"></a></p>
  
  <p>This is my Code:</p>
  
  <pre><code> privatevoidbutton1_Click(objectsender,EventArgse)
  {
  stringcon=ConfigurationManager.AppSettings["WinDSS_Connection"];
  try
  {
  OdbcConnectionconn=newOdbcConnection(con);
  OdbcCommandcmd=newOdbcCommand();
  OdbcDataAdapterda=newOdbcDataAdapter();
  DataTabledt=newDataTable();
  conn.Open();
  cmd=conn.CreateCommand();
  cmd.CommandType=CommandType.Text;
  cmd.CommandText="SELECT Store_No,Store_Name,Store_City,Store_State FROM SYSMST";
  da.SelectCommand=cmd;
  da.Fill(dt);
  dgv1.DataSource=dt;
  conn.Close();
  
  }
  catch(Exceptionex)
  {
  MessageBox.Show(ex.Message.ToString());
  }
  }
  </code></pre>
  
  <p>My app.config </p>
  
  <pre><code>&lt;appSettings&gt;
  &lt;addkey="WinDSS_Connection"value="DRIVER=SoftVelocityTopspeeddriver(*.tps);DBQ=T:\Rambo\Store231WinDss\windss\DATA;Extension=tps;Oem=N;NullEmptyStr=N;"/&gt;
  &lt;/appSettings&gt;
  </code></pre>
  
  <p>how I have my driver configured on ODBC data source administrator </p>
  
  <p><a href="https://i.stack.imgur.com/XgQuw.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XgQuw.jpg" alt="enter image description here"></a></p>
  
  <p>When I use Top Scan and look at the same table there is one record in it, so why is it not displaying that result on the datagridview and what is this ISAM Table please help me out as I am out of options here.</p>