I have set up my website to use ASP.NET Membership. it all works fine when trying to use it on my development machine but when I put it on the web server and try to log in, I get this error :
"Failed to update database "C:INETPUBWWWROOTAPP_DATAASPNETDB.MDF" because the database is read-only. "
I am currently working on visual studio 2008 , sql express 2005, i have copied .mdf and .ldf files , after i copied these files and try execute some existing stored procedure but exception is coming like " Failed to update database xxxxxxxxxxxxxxxxx.MDF" because the database is read-only", I dont knw what's wrong with this , i have executed same stored procedure in old .mdf and .ldf database , and its working fine . but in copied .Mdf , not working.
View 10 RepliesI have hosted a website with database using windows server, when I run normal pages are running the data stored are being fethched and can be seen but for edit,save and delete button it gives error below
Failed to update database "C:HOSTINGSPACESRWTINDIARWTINDIA.COMWWWROOTAPP_DATALAKSH_DB.MDF" because the database is read-only.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Failed to update database "C:HOSTINGSPACESRWTINDIARWTINDIA.COMWWWROOTAPP_DATALAKSH_DB.MDF" because the database is read-only.Source Error:
Line 46:
Line 47: SqlCommand cmd = new SqlCommand(qry, conn);
Line 48: cmd.ExecuteNonQuery(); Line 49:
Line 50:
Source File: c:HostingSpaces
wtindia
wtindia.comwwwrootPrincipal.aspx.cs Line: 48
What i do? Ihave checked all the folders and its properties all folders have all rights then also it is giving error ....
This is a very common error as evidenced but the very large number of problems and suggested solutions on the web. I finally got around it last week but can't remember what was the step that did it. At that time, I was building a web application rather than a web site. Is that the difference? As you can see, it is no longer in the APP_DATA folder and is named membership.mdf rather than aspnetdb.mdf. I ran aspnet_regsql.exe to create it and actually had it working and was updating it successfully. But for other reasons, I had to scrap the application and decided to re-create it from scratch as a web site rather than a web application. I had been using Visual Studio 2008 to build the web application but am now using Visual Web Developer 2008 Express Edition to build the web site. Unfortunately, the Visual Studio application will no longer open so I can't verify that the web application still works. Can anybody help? (Please!!!) BTW, ASPNET and NETWORK SERVICE both have full control over the membership.mdf.
View 1 RepliesI am using sql membership table to create users and role allocation etc. it is working absolutely fine.now i have added webparts in page which also working good but when i click to minimize the webparts it gives me below error. My question is I have sql membership table in my database then webparts is using mdf files from app data.
Failed to update database "E:WWWROOTAPP_DATAASPNETDB.MDF" because the database is read-only.
how to use update using ADO.NET dataadapters.
View 2 RepliesWhen send mail and receiver open the mail and click the link at that time call another page and update a data base with data....
View 1 RepliesI need to browse excel file and update the neccessary tables based on some ID. It is basically updating employees in bulk.
View 7 RepliesI migrated my asp application to asp.net . When i run I got an error like this.
"System.Runtime.InteropServices.COMException: Cannot update. Database or object is read-only." I am using access db. I can't find out the solution .
I have a comment page where I am using multiple validators and have a validator group. Eveyrhting else on the page is working correct through testing. Everytime I submit my form the validator flags the recaptcha is not correct. When I run this I get the following errors in chromes java script counsole. Would one of them be why I am not able to validate the reCaptcha correctly?
Uncaught SecurityError: Failed to read the 'contentDocument' property from 'HTMLIFrameElement': Blocked a frame with origin URL...from accessing a frame with origin URL... The frame requesting access has a protocol of "http", the frame being accessed has a protocol of "https". Protocols must match.
Contact_Us:152 Uncaught TypeError: Cannot read property 'success' of null.
I have Temporary table. I want to generate the Update statement by using this temporary table. Then temporary table data length can have more then 5000. So I need to generate the update statement in dynamically and stored in variable. I have tried this logic but dynamically generated update statement length is getting exceed. So my update statement is getting failed. I do not know how to achieve. how to overcome this issue? I have shown the piece of code which I tried
DECLARE @strFieldName varchar(max)
DECLARE @strFieldData varchar(max)
DECLARE @strUpdateSql varchar(max)
DECLARE @strUpdateSql1 varchar(max)
[Code]....
Cannot open user default database. Login failed. Login failed for user X
View 3 RepliesI'm using this for connection to SQL Server 2005 [Windows authentication]
<add key="ConnectionString" value="Data Source=MALIKsqlexpress;Initial Catalog=gainpeace;Integrated Security=SSPI"></add>
but it generates an error
Cannot open database "gainpeace"
requested by the login. The login
failed. Login failed for user
'MALIKASPNET'.
I have a code block that contains around 320 lines of code. Everything runs fine when i debug it until i reach the section that updates a sql datasource. I am using:
sqlDScc.UpdateParameters("friendlyName").DefaultValue = friendlyName
I have 38 lines of update parameters before i call the sqldscc.Update When i put a break point before the update parameters all the values are correct at the break point at the end all the values are "Property Valuation Failed"?. I'm not using any response.end, response.redirect or server.transfer
[Code]....
I am building an MVC application with C# as my language which is hosted on Widows 7 IIS. A call to Add a new member to the database works, but when attempting to save the change I get the following error:
Cannot open user default database. Login failed.
Login failed for user 'IIS APPPOOLmyApplication'
The SQL table was added just by adding it within VS.
Here is my connection string:
<add name="yafnet" connectionString="Data Source=localhost;Initial Catalog=Scirra;User Id=Gullanian;Password=12345;" providerName="System.Data.SqlClient" />
And I get:
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'Gullanian'.
I've created the database 'Scirra'. I've also attempted to add a login, but nothing seems to work. Logging into SQL management via Windows Authentication is the only way I can gain access to my DB's.
Ideally I just want to create a user, and that user having full control of DB. So I can run scripts etc.
Here's a few details:
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework 2.0.50727.4952
Operating System 6.1.7600
Idk why it says v2 for asp.net, all my application pools are set to 4.0.
I'm using an Oracle database(10g) which contains a stored procedure called Foo. Foo takes 2 datetime as IN parameters and 1 cursor as OUT parameter. I've been trying to make the connection and the query to the database with the OleDbCommand, but since Foo needs a cursor I have no choice but to use a OracleCommand(right?).When I try to connection to the database I get the following error : "OCIenvCreate has failed return code -1". I've gived the correct permissions to ASPNET user for the oci.dll file so that it can read and execute it. Unfortunately, I still get the same error and I'm lost.Here is what cause the error
OracleConnectionStringBuilder conBuilder = new OracleConnectionStringBuilder();
conBuilder.DataSource = dataSrc;
conBuilder.UserID = user;
[code]...
In my website i have used a database file named TRAVEL12.mdf, which is present in APP_DATA folder and some how by default a databse file named aspnetdb.mdf is also present in APP_DATA folder , althogh I have not made it......
Now, my problem is that sometimes when I tries to insert some data at any table(that table is in TRAVEL12.mdf database) error shown that login failed to access the default database aspnetdb.mdf for the user...........
Then I deleted the database aspnetdb.mdf, but now also sometime error shown that login failed to access the default database for the user......
as i mentioned that error occurs sometimes not every time which is also a confusion to me!!!.........
I can't understand why this happening??? I am working with TRAVEL12.mdf and I have used it's connection string in my code as a argument of SqlConnection class, so what is the role of default database here!!!
I have a page that have
[Code]....
[Code]....
And The ImageViewer Page Have
[Code]....
when i click the button for the first time it worked and the debugger go to the load of the Image Viewer page ,and when
i click the button again, it does not go to the image viewer page load at all (some kind of cache),of course if i remove the update
panel it will work perfectly, but i need it with update panel , the above code is a smplified test version of what i trying to do,
i need to read binary image with update panel(orginally i dont have a physical image, only binary)
i want to update the data of a database through a gridview update button
how can i attach a dataconvertion like this
[Code]....
i got a problem to update my database which i bounded to datagrid. The problem is, i want to update my database only by clicking one update button at the bottom.. when the user click it, all the fields will be updated to database.
View 3 RepliesI'm using VSTS 2K8 and I've set up a Unit Test Project. In it, I have a test class with a method that does a simple assertion. I'm using an Excel 2007 spreadsheet as my data source.
My test method looks like this:
[Code]....
As indicated in the method decoration attributes, my Excel spreadsheet is on my local C:/ Drive. In it, the sheet where all of my data is located is named "Sheet1".I've copied the Excel spreadsheet into my project and I've set its Build Action = "Content" and I've set its Copy to Output Directory = "Copy if Newer".
When trying to run this simple unit test, I receive the following error:
The unit test adapter failed to connect to the data source or to read the data. For more information on troubleshooting this error, see "Troubleshooting Data-Driven Unit Tests" (http://go.microsoft.com/fwlink/?LinkId=62412) in the MSDN Library. Error details: ERROR [42S02] [Microsoft][ODBC Excel Driver] The Microsoft Office Access database engine could not find the object 'Sheet1'. Make sure the object exists and that you spell its name and the path name correctly.
I've verified that the sheet name is spelled correctly (i.e. Sheet1) and I've verified that my data sources are set correctly.Web searches haven't turned up much at all.
[Code]....
I recently upgraded a WinXP machine that had been running VWD 2005 to a Win7 machine using VS 2010. The application targets .Net 2.0, but since the upgrade, I cannot get VS to connect to my database and this is the first time I've tried working on the site since upgrading, so no changes have been made to any code (with the exception of trying to change my connection string so I can connect). The specific error is:Cannot open database requested in login 'dbName'. Login fails. Login failed for user 'SqlLogin'The sql database is on another machine and I was assigned the login/password; I know the login works because I can connect to it with SQL Server Management Studio. Having read several posts and still having trouble, I tried to do a couple things. First I modified my web.config connection string, which looks like this:
[Code]....
When that did not work, I deleted the connection string from the web config and dragged a sqldatasource control onto a page and tried to use the connection string builder while in design mode. Then the error I got was:The database db1 does not exist or you do not have permission to see it. Would you like to attempt to create it?I'm not sure I understand that there is a problem at all, except that I upgraded the OS/IDE. I'm using IIS 7.5 on my local machine to serve the development site while connecting to the development sql server on the other machine. Since I can't use the IIS aspnet account on the remote sql server and my assigned login is verfied working through sql management studio, what else can I do to get my developement site working again?
i logged in to my sql server using remote server ip, user name and password,
then by mistake i set my database offline on server, by right clicking on database then tasks then take offline, it's taking time
then i cencel it, but after some time i seen that my database is offline,
now i trying to take it online, but i can't it giving error that
"Set offline failed for database 'mydbname' "
i also try to take it online using query but it's also giving error that "User not have permission to take database online or database does not exist"
everything is on server and it has lot of data, so tell me that how can i bring it online
In domain control panel it also showing error even i can't delete and restore it or backup it, because it's offline
I have been able to successfully read a row of data from an SQL table using two column parameters. Now I would like to update this row with new information. Is this possible since the reader does not specify which row was read with the 'reader.Read();' command?
View 7 Replies