Page 1 of 1
ASP.NET DataSet Connection String with Impersonation
Posted: Mon 21 Jun 2010 17:28
by Emily
I am using ASP.NET DataSets and want to use impersonation, i.e. not set userID or password. I know the web server can identify the user, but my connection string must be wrong.
this.connection.ConnectionString = "Persist Security Info=True;Data Source=ServerX;";
Can you please help me?
Posted: Tue 22 Jun 2010 14:37
by Shalex
Integrated Security connections (OS authentication) is available in the OCI mode (Direct=false;) only, because this is a feature of Oracle Server itself via Oracle Client. The only setting you should set in dotConnect for Oracle is to specify
this.connection.ConnectionString = "Data Source=ServerX;";. The rest of settings should be made in Oracle Server and Oracle Client. Please refer to Oracle documentation. For example, here is a walkthrough:
http://www.oracle-base.com/articles/mis ... cation.php.
Posted: Wed 12 Oct 2011 13:46
by wijjkey
I'm using a DataSet to retrive data from a Database and access the values of the columsn returned. I then want to set the Text of various labels to the values of the columns. To do this I use to code below
appID.Text = dsAppData.Tables[0].Columns[0].ToString();
appName.Text = dsAppData.Tables[0].Columns[1].ToString();
gripsID.Text = dsAppData.Tables[0].Columns[2].ToString();
The problem is that it sets the text of the labels to the column names and not the values. Am I using the wrong code? Thanks
Posted: Fri 14 Oct 2011 08:45
by Shalex
Try using this code:
Code: Select all
appID.Text = dsAppData.Tables[0].Rows[0][0].ToString();
appName.Text = dsAppData.Tables[0].Rows[0][1].ToString();
gripsID.Text = dsAppData.Tables[0].Rows[0][2].ToString();
You can find an example of working with data of OracleDataTable here:
http://www.devart.com/dotconnect/oracle ... Table.html