State Management :: Roles Automatically Switch Up The Databases Connection String Upon Login?
Sep 3, 2010
I only made 1 other dynamic page before, without users. I do remember I setup a read-only user to the database and that was the user used in the connection string, simple.
In managing multiple users, does asp.net's membership & roles automatically switch up the databases connection string upon login? Do you setup hypothetical "groups" of user access permissions in your database (mysql) then associate that user to that group in membership & roles?
I'm just looking for a general idea of what to expect before I start reading.
I'm trying to create a sql script that will connect to 1 server, backup 2 dbs, then connect to another server and restore the dbs. know i could create an application easily, use sqlcmd too but I wanted to do it on SQL Server Management Studio. I'm running version 10.0.2531.0
I am using session on my online application if im wrong let me know when i wana remove session i will put this code
session.remove("userid")
and also im using session for user login when user login on that time i have create one session("user_rights")
if session("user_rights") is nothing then Response.Redirect("Logout.aspx") end if
but some time on working time session automatically or i dont know exactly session expire and on running time it go out i mean logout...and at that time if im doing something on my application all will be lose how can i make strong my session ... here is web.config code
I have an asp.net application consisting of two web pages and a web service. All components are part of the same project, i.e. I have a solution with only one project. The web service queries a server and fills the information it retrieves into container objects which are stored in the cache of the application. This done using the Cache.Insert method:
OnRemove is my handler that writes the reason into the log file in case the item is removed from the cache. Now from what I understand this example item should never be automatically removed from the cache. Basically this is what I want: It shall stay in the cache until I explicitely remove it. Once the cache is populated by the web service one of the web pages visualizes the cache content using html. The other web site contains a button to manually kick on the web service and one button to clear the cache content, i.e. remove everything in the cache. Unfortunately somehow the cache seems to get cleaned up once in a while. In irregular intervals all containers that are created by the web service and are stored in the cache are removed from the cache. I don't understand the reason for this. The only place in the code I remove something from the cache is when I manually press the clean cache button on one of the web pages.
What is strange is that all container objects in the cache are removed, not just a few. But this is not because the button that cleans the cache is pressed. I know this because a log entry is created whenever that button is pressed. To find out what is going on I attached the OnRemove handler which just logs the reason why a cache item is removed. In my case the reason is "Removed". I simply don't get it. How can I ensure that the cache just stays as it is? Items placed in there shall just stay there. Nothing shall be cleaned up automatically.
In my application, session value automatically set into null.In certain workflow only it will set as null (Normally It's able to access value). Example, at the time of login, I will set session values. While, user deleting some entries from drop down list of specifc page,client script will show message like selected entry deleted. After that, flow point will move to master page. There I have to access session variables. It's getting null value. I tried to debug with Quick watch, at the pageload of master page only value set into null (automatically).
I have a query which gets values from two tables which are in different databases.How can I write a SINGLE Connection String which connects to two databases? By the way I am using SQL Server Database
I am connecting to Oracle database from .net using OLEDB.
My Connection string :
[Code]....
I am using above ConnectionString to communicate with database. To make it work, I have to store password (don't want to do that) in session and use it every time I need to talk to db.
1) Is there any other connection string without username and password with oledb?
2) I use "Integrated Security" for MSSQL. How can I use the same with OLEDB - Oracle database?
I wrote a small socket client application talking to my asp.net server application.
On the asp.net side, I created a IHttpHandler. I want to send data back and forth on one HTTP request.
I tried the following code which run an infinite loop inside function ProcessRequest(). The client side opens a socket connection and send HTTP POST request.
I am not sure how asp.net work. In HTTP POST I have to specify Content-Length, I tried a small value, like 20, then asp.net handler can only get 20 bytes in the inputstream. I tried to use 4096000 bytes(close to the maximum IIS allowed), then the inputstream cannot get anything, it seems IIS is waiting for all data(4096000) to come from client side before it gives the handler a chance to read from the socket.
public class DeviceDataHandler : IHttpHandler { public void ProcessRequest(HttpContext context) { try { Stream inputstream = context.Request.InputStream; Stream outputstream = context.Response.OutputStream; /loop forever until exception is thrown while (true) { ProcessData(inputstream, outputstream); } } catch (Exception ex) { ZenLog.logError("DeviceConnector exception: " + ex.Message); } } public bool IsReusable { get { return true; } } }
I am trying to write a page to read the Excel file provided by the user. I know I can't use the FileUpload to get the full path of the file from the client PC. This give me the problem when I write the connection string for the Excel file:
[Code]....
Without the full path, I can't replace the Data Source by a variable and I definitely can't assume all users will have their Excel files named Book1.xls located in C:Doc all the time.
The Silverlight app has a link to a different group of reports. This *was* working fine but no more. In the following code you can see the 'Reports' part that it calls another page [URL] namely right here: WHat is happening is when the reports page is called, it goes into 'Session timeout ' right away.
i have a dropdownlist contaning years..now i want to connect my database by dropdown selection.if i select 2013 it will connect 2013 database ,if i select 2014 it connect 2014 so on..
i work with sql database i want to connect to sql server i dont have sql manegment who could i c the connection string the palce of the sql that wen i write these comand sqlconnection con = new sqlconnection("the connection string")
SelectedIndexChanged event doesn't fire for the first item of the DropDownList. For any other item SelectedIndexChanged fires, but not for the first one.Could someone, please, explain what kind of magic is it?(I use Visual Studio 2008)
In my asp.net +vb+access web i have made a login page and the code is as under
Dim connectString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:webauth.mdb" Dim con As OleDbConnection = New OleDbConnection(connectString) con.Open() Dim cmd As New OleDbCommand("select * from Users where userid =@userid and Password=@password", con) cmd.Parameters.AddWithValue("@userid", txtUserName.Text)
[Code] ....
I am getting error The connection was not closed. The connection's current state is open.
I have been searching internet in order to secure my connection string in the web.config file and setting the Login controls connection strings in runtime
TEverything about encrypting connection strings works fine on local machine. I can do it programmatically and on aspnet_regiis.exe
My questions are How can I set the connection string to any login control in runtime? How can I encrypt my connection string on my shared hosting ?How can I use aspnet.regiis.exe to encrypt my config file on shared hosting ? How to define the commands ?If I can find a solution to my 1st question, 2nd doesnt matter anymore.
I have a web site which uses one SQL database but the hosting company is very slow sometimes and I got database timeout, login and similar errors. Can I implement my code to use two databases simultaneously? I have stored procedures and the data is updated periodically.
EDIT:
Simply: When dbDefault is down and inaccessible I need to use dbSecondary so the web app keeps running. Ant these two databases must be always same.
EDIT:
Some errors:
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.Cannot open database "db" requested by the login. The login failed. Login failed for user 'root'.
Newb question: what is the standard practice for assigning roles to newly signed-on members. Is it usually manual or is there a way of automatically assigning roles. Being completely new to this, I am confronted by the issue of my site having three different roles that new members could fall into, but am unsure about how to assign each a role. I can't imagine having to go through the process manually if I have thousands of members.
