C#

classy_dog wrote:

The account that is being used is setup for an applicaiton by using a sql server
login. The account also has some kind of rights to windows.

classy_dog wrote:

and/or tell me what you think can be wrong?

classy_dog wrote:

Is there somehow a way for an account that has sql server authenication to also
have access to windows?

classy_dog wrote:

I did find out that the username and password for both windows and sql server
are the same name and value

classy_dog wrote:

Since the value for connecting to the database comes from an app.config file, is
there any way to comment out that connection string information and the vale and
the application still works? I would think this would be possible if integrated
security=true in the app.config file

classy_dog wrote:

I would think if integreated security is not set, and a user name and password
is supplied, then the sql server login would be true, correct?

antrock101 wrote:

da1 = new System.Data.SqlClient.SqlDataAdapter(sql, con);

da1 = new System.Data.SqlServerCe.SqlCeConnection(sql,con);

public partial class Form1 : Form
  {
      public OpenFileDialog dialog = new OpenFileDialog();
      System.Data.SqlServerCe.SqlCeConnection con;
      System.Data.SqlServerCe.SqlCeDataAdapter da1;
      DataSet ds1;



      public Form1()
      {
          InitializeComponent();
      }

      private void btn_sel_Click(object sender, EventArgs e)
      {

          //dialog.Filter = "*.sdf";
          dialog.ShowDialog();
          MessageBox.Show(dialog.FileName);
          loadconnection();

      }

      private void btn_close_Click(object sender, EventArgs e)
      {
          Application.Exit();
      }

      public void loadconnection()
      {
          con = new System.Data.SqlServerCe.SqlCeConnection();
          con.ConnectionString = "Data Source=" + dialog.FileName + ""; //opening dialog (selected file)

          con.Open();


          ds1 = new DataSet();
          string sql = "SELECT * From tbl_games";
          da1 = new System.Data.SqlServerCe.SqlCeDataAdapter(sql, con); // Modified this line
          da1.Fill(ds1, "Name");

          con.Close();
      }
  }