.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Win7 64bit showing my database as ReadOnly when Application Installed

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :.NET Framework
 

Hello ,

I have faced a very strange issues so far.. let me explain you all my situation..

I have an windows application.. it's developed in the .net framework 2.0 and back end with SQL Express 2005 , and I am attaching my database file while I install application on the machine.

My appliction works okay in all the operating system with 32 bit platform but when I tried to install it on the Win 7 , 64 bit it was giving me error with ReadOnly database and can't execute query.

I have checked all permission given to folder of my database in both 32bit and 64 bit win7, it looks same.. then what could be cause of such an error.. though when I tried to run it from vs in win7 64bit (Debug though visual studio), it was working correctly..

if you have any solution.. for this problem. let me know ..

thanks..

 

 

 

 

 

 


Thanks and Regards, Shailesh B. Davara sdavara.com


View Complete Post


More Related Resource Links

Win7 64bit showing my database as ReadOnly when Application Installed

  

Hello ,

I have faced a very strange issues so far.. let me explain you all my situation..

I have an windows application.. it's developed in the .net framework 2.0 and back end with SQL Express 2005 , and I am attaching my database file while I install application on the machine.

My appliction works okay in all the operating system with 32 bit platform but when I tried to install it on the Win 7 , 64 bit it was giving me error with ReadOnly database and can't execute query.

I have checked all permission given to folder of my database in both 32bit and 64 bit win7, it looks same.. then what could be cause of such an error.. though when I tried to run it from vs in win7 64bit (Debug though visual studio), it was working correctly..

if you have any solution.. for this problem. let me know ..

thanks..

 

 

 

 

 

 


Thanks and Regards, Shailesh B. Davara sdavara.com

Error while setting up application on Win7 using Visual Studio.NET 2003

  

Hi All,

Getting the below error while setting up application on Win 7 using visual studio.NET 2003.

Error:

cannot find the components for communiacting with the front page server extensions...

 

I understand by the error, i need to install Front page server extension, but not able to figure how to install using IIS 7.5.

I had XP machine with IIS 5.1, able to find the option.

 

Need your help in resolving this.

 

Thanks

Abdul 


Upsize Your Database: Convert Your Microsoft Access Application to Take Advantage of SQL Server 7.0

  

What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.

Michael McManus

MSDN Magazine June 2000


An example of packaging web application containing database upgrade SQL file

  
A few months ago, we have a blog talking about extending the web publishing pipeline to package database project deployed SQL file.  In this blog, I'll show step by step example of packaging web application with SQL Server database upgrade SQL file using Visual Studio 2010.  This way, we can generate a web package with incremental SQL script to certain database version.  The scenario may help distributions of a web upgrade package which needs to be installed on many different locations, each with their own SQL server database.   1. Create a Web Application Project 2. Add a new "SQL Server 2008 Database Project" to the solution 3. Prepare a development database, such as my test1 database as the following: 4. Right click our...(read more)

Creating an database search application in VS C#

  
Hello everyone, I wish to create a C# application that will have a form and a text box where I can enter a text, and then ask the application to search if this text exists in a database. If it exists, I want all the information associated with this text to be displayed in a datagrid view or list box. I am able to create a database in SQL Server and I can connect to my database from VS 2005 C#. If this is possible, how do I go about it? Many thanks in advance.

Database is looking as (Suspect/readonly/offline/emergency/)

  
Could not open FCB for invalid file ID 0 in database 'mssc_admin' and database is looking as (Suspect/readonly/offline/emergency/) Actually log file is not visibiling and I was trying to restore it.   PLease PLease help"SQLSERVER DBA" "INDIA"

Problem with Movie Database Application

  
Hi Im following MVC tutorials on ASP.net website..I have a problem at Movies database application found in http://www.asp.net/mvc/tutorials/create-a-movie-database-application-in-15-minutes-with-asp-net-mvc-cs  Listing 3 - Views\Home\Index.aspx----------------------------------------------------------------------------------------------I dont understand where "Model" refer to in this code <% foreach (var item in Model) { %>  Also im confusing with accessing the database fields using var item Please explaine me what is happening in this code.<% foreach (var item in Model) { %> <tr> <td> <%= Html.ActionLink("Edit", "Edit", new { id=item.Id }) %> | <%= Html.ActionLink("Details", "Details", new { id=item.Id })%> Movie Database Application

Database diagram support objects cannot be installed...

  
I can't make a diagram on our server(Win2003 x64,SQL 2005 Enterprise x64 sp2 3054). I have tried to login as an admin and create a new db, but get the same message - 'Database diagram support objects cannot be installed because this database does not have a valid owner. To..' Also tried to make a diagram from the ReportServer db.   Any suggestions?

showing modalpopup and saving data to database simultaneously using ajaxtoolkit and javascript

  
hi,i have a button ,i want that when i click on that button the data should be saved in the database as well as at the same time a modal popup should display the customerid .i have written the code as <asp:button id="save1" runat="server" onclick="Button4_Click" style=""z-index:" mode="hold" xmlns:asp="#unknown" /> left: 740px; position: absolute; top: 304px" Text="save"/> <asp:panel id="panel" runat="server" xmlns:asp="#unknown">  /asp:Panel> <ajaxtoolkit:modalpopupextender id="MPE" runat="server" targetcontrolid="save1" xmlns:ajaxtoolkit="#unknown"> PopupControlID="panel" DropShadow="true" BackgroundCssClass="modalBackground/> protected void Button4_Click(object sender, EventArgs e) { string id = TextBox1.Text; string name = TextBox2.Text; string cn = "Data Source=hcl;Initial Catalog=mydata;Integrated Security=True"; SqlConnection con = new SqlConnection(cn); SqlCommand cmd = new SqlCommand("insert into customer values (@id,@name)", con); con.Open(); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@id", id); cmd.Parameters.Add("@name",name); cmd.ExecuteNonQuery(); con.Close(); CUSTID.Text = id.ToString(); MPE.Show(); }

Looking for Clarification - Using a SQL Database MDF in an ASP.Net Application

  
I am looking to understand how to use Database files with ASP.Net web application projects. Very similar questions were posted, but I couldn't find quite the clarification I am looking for, so here's another post. I've been programming with ASP.Net for a while, but have always been in an environment where I had a full SQL server setup, and the databases were not file format. For the purposes of this project I am trying to keep it in .MDF format so that I can pass it on easily to my customer and let them do what they wish with it. The project is in Visual Studio 2010, a simple ASP.Net 4.0 MVC2 application that is to use EF 4.0 for persistence. Background Issue First thing I did was add a database to App_Data folder. It shows up on Server Explorer and I can manually add tables via Visual Studio - this should mean that the connection string and permissions and such fine I would think. So, next step. I created an Entity Diagram, built everything "model first" and used the Model to generate the database schema. Using the connection string in web.config, the generated SQL code runs, and says at the bottom of VS, "Disconnected". I go to the Server Explorer, and sure enough there's a red X next to the DB file. I expand the MDF, the little black arrow comes back, showing me I am connected. I try to run it again... and it does the same... "Disconnected"

ClickOnce problems with IIS/Win7 64bit due to ResponseHeader CR/LF

  
Hi, my ClickOnce application is running fine on XP/IIS6 and several other Window Versions. On Win7-64bit it does not work. The CR/LF-problem was solved in the application itself, but ClickOnce seems to have the same problem that we had.   Any idea? Klaus INFO ZUR PLATTFORMVERSION Windows : 6.1.7600.0 (Win32NT) Common Language Runtime : 4.0.30319.1 System.Deployment.dll : 4.0.30319.1 (RTMRel.030319-0100) clr.dll : 4.0.30319.1 (RTMRel.030319-0100) dfdll.dll : 4.0.30319.1 (RTMRel.030319-0100) dfshim.dll : 4.0.31106.0 (Main.031106-0000) QUELLEN Bereitstellungs-URL : http://dell01/gnsl/SimpleLauncher.application?launchfile=http://dell01/gnclient/launch/allgemein.xml&project=http://dell01/gnclient/projects/ini_eckernfoerde.xml FEHLERZUSAMMENFASSUNG Es folgt eine Zusammenfassung der Fehler. Details zu diesen Fehlern werden später im Protokoll aufgelistet. * Die Aktivierung von http://dell01/gnsl/SimpleLauncher.application?launchfile=http://dell01/gnclient/launch/allgemein.xml&project=http://dell01/gnclient/projects/ini_eckernfoerde.xml führte zu einer Ausnahme. Folgende Fehlermeldungen wurden entdeckt: + 'http://dell01/gnsl/SimpleLauncher.application?launchfile=http://dell01/gnclient/launch/allgemein.xml&project=http://dell01/gnclient/projects/ini_eckernfoerde.xml' konnte nicht gedownloadet werden. + Der Server hat eine Protokollverletzung ausgef

problem rename sharepoint 2010 search service application admin database

  
Hi all, i have a problem that hopefully someone has an answer to.  i am not too familiar with sharepoint so please excuse my ignorance. we have sharepoint 2010 on a windows 2008r2 server.  everything seems to work fine.  but as you know, the default database names are horrendous.  i have managed to rename all of them, except for the "search service application" admin database. the default is: Search_Service_Application_DB_<guid> the other 2 databases (crawl and property) were renamed without a problem. we are following the article from technet on how to rename the search service admin db (http://technet.microsoft.com/en-nz/library/ff851878%28en-us%29.aspx).  it says to enter the following command: $searchapp | Set-SPEnterpriseSearchServiceApplication -DatabaseName "new database name" -DatabaseServer "dbserver" however, i get an error about identity being null.  no big deal, i add the -Identity switch and the name of my search service application.  but the real problem comes the error it throws:   Set-SPEnterpriseSearchServiceApplication : The requested database move was aborted as the associated search application is not paused. At line:1 char:54 + $searchapp | Set-SPEnterpriseSearchServiceApplication <<<<  -Identity "Search Service Application" -DatabaseName "ShareP

Questions on Multi-Tenant Data Architecture for SQL Server Database and ASP.NET application

  
My company wants me to make the same asp.net application and sql server database be sharable amongst different clients. Clients will use the database for their own business use, will have their own data, we will have our own data. How can I share the same SQL Server database amongst different clients having same ASP.NET application (but somehow be able to differentiate which client user is logging in) ? Do I need to use ApplicationID and how will I detect at login which one to use ? I know I will need to add another field in all tables to differentiate client's data from ours.  

ASP.NET MVC2 Empty Web Application creates ASPNETDB database when I try to add user to my own databa

  
I created ASP.NET MVC2 Empty Web Application, I added my own database called 'Database1' and I added to this database Microsoft users, permissions etc. tables but when I create user in ASP.NET Configuration - it creates in catalog /App_Data database called 'ASPNETDB' and adds users to this database - I don't want that - I have my own database for that - what is going on ??In Web.config my ASP.NET MVC application I have only one connectionString - my own:<add name="Database1Entities" connectionString="metadata=res://*/Models.Model1.csdl|res://*/Models.Model1.ssdl|res://*/Models.Model1.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" /> so what is going on ? How can I add users to my database 'Database1' ?

Suppose we are building a web-based application to retrieve and enter information into a database.

  
Please help me out with thisSuppose we are building a web-based application to retrieve and enter information into a database.  The user-interface invokes web services.  Which architecture  would use for the application.

how to change the web application Database connection form Windows authentication to SQL Server acco

  
Hi, I have a web application created and Database connection authentication was given as Windows authentication. how can i change it to a SQL server account in MOSS 2007. Thanks in advance.

Login to Database from Application

  
Hello, On my SQL Server I have the Security and Logins section.  I usually do the following to access the database from my application: 1 - Create a database on dbo scheme; 2 - Create a Login; 3 - Create a Database Role in the Database and grant the following permissions:      select, insert, update, delete, execute on schema::dbo 4 - Create a Database User and associate it to the Database role and to the Login  Then on my MVC application I use a Connection String with the login to access the database. Can I access the database without the login? Should I make this in some other way? Thank You, Miguel
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend