Has somebody measured performance differences between "real" SQL Server database and a SQL Server Express user instances (attached .mdf database file)? What was the conclusion? Was the .mdf database file fast enough for your application? ...
Folks, I have an ASP.NET v2.0 website (not web application) where the root directory is public, but the "Admin" subdirectory requires authentication. Everything about the setup is very generic - I used a connection string defined in the root web.config, and the standard AspNetSqlMembershipProvider provider, and I'm using the ASP.NET Lo...
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization stuff and at this point don't know how t...
I'm trying to create a user using the SQL membership provider on SQL Express. When I use the TransactionScope it prompts to DTC with no apparent reason, how can I avoid it? Here is my example code: using (var ts = new TransactionScope()) { MembershipCreateStatus status; Membership.CreateUser(username, password, null, null, null...
Tried this in as connection string connectionString="Server=.\SQLEXPRESS; AttachDbFilename=E:\Database\dnn49.mdf;Database=dnn49; Trusted_Connection=Yes;" but i get an error Unable to open the physical file "E:\Database\dnn49.mdf". Operating system error 5: "5(Access is denied.)". Cannot attach the file 'E:\Databas...
I just installed SQL-Server Express 2005 on my machine and I am trying to create a Service-based Database for a C# application. But when I try to create it I end up with the following error message: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be cl...
Hi guys, I'm deploying my Web project and in the requirements I mention that I need SQL Express Edition SP2 (x86) as you can see by the picture below Problem is when the client has already Microsoft SQL Server 2005 Express Edition SP3 (this on a 64 bit machine) when we try to install I get this error Questions: even thought I t...
I have an adp project in MS Access 2003 with an SQL Server Express 2008 as backend. Everything works fine, except when there is an error on the SQL side, e.g. duplicate indices. the current dataset just doesn’t get updated/inserted, no error message whats-o-ever, but I know it’s not updated, because if I do a select on the server I stil...
I am able to create a database connection when I use ASP (vb) but when I switch my document type to ASP.NET (vb), my add database connection is grayed out. How can I add a SQL database connection while using ASP.NET (vb)?? PS - it is the "+" symbol that is grayed out.. it works fine when I switch the document type to ASP vb. Thanks, Ah...
Is it possible to use the App_Data folder in conjunction with SQL Server 2005? When I try it specifies Express even though I have changed the Tools>Options>Database>Data Connections to the correct server. I have downloaded SQLEXPR32_x86_ENU.exe Version 10.0.1600.22 file locally and have gone through 7 installs and deinstalls with a var...
Is there a free solution for using Linq and MySQL? Can one use Visual Studio Express, Linq, and MySQL together? ...
I am backing up a SQL Server Express database and then restoring on another machine. For some reason the asp.net membership data is not getting transferred. Do I need to do something different. Does ASP.NET membership data not get backed up? ...
If I have a new install of SQL Server Standard on one machine, can I easily import my database from SQL Server Express on another machine? I was planning to detach the db transfer the file and attach on new machine. Is this the easiest way? What about permissions? Will this work? ...
I added some tables to my DB, and refreshing the model didn't work. So I deleted my .edmx file completely. I then recreated the model according to my updated DB, but the same tables were still missing. I'm not really sure why, but for some reason it won't load certain tables into the model. I looked at the XML .edmx and the tables ar...
We are looking at creating a custom ASP.NET application for a client, however they are a nonprofit and thus budget is limited. We typically develop ASP.NET web and desktop apps to connect to a central SQl Server 200X database, ie with a full version of SQL Server, running on networked Windows Server. In this case we won't have a full v...
I have done some research online but i cant seem to find a proper answer. I am trying to restore a SQL server 2008 backup onto a sql express 2008 system (Live environment backup to Development environment) The problem is i keep getting a "SQL Server cannot process this media family" error code 3241. Any ideas??? Thanks ...
Ok, I'm using SQL Server Express 2008 and .Net 3.5 (c#) I have a couple of datetime fields in the database and am trying to make an edit to a row (Using Linq-to-Sql) I receive the error "Row not found or changed." I have spent some time getting the generated SQL and it seems that the issue is caused by the milliseconds attached to the ...
I have a WCF service that is deployed on a machine. This WCF service can be configured to either SQL Server or SQL Server Express. NOTE : The SQL database location can be other machine other then where WCF service is deployed. I put following information in XML file: user id password ServerName MachineName In case of SQL Server Ex...
After I change the option as UserInstance="False", then the error starts to happen. Because I want to use full-text search, the option change is required. BUT, it stopped to work. Is there any way to make it work again? I'm running Application Pool as Network Service with full control. ...
Hi I have a weird problem that i can't figure out a solution for: I've made a little WPF app written in C# that uses an attached SQL Server Express .mdf database which i then manipulates through LINQ. I have a ListView on the form which datacontext is set to .DataContext = dr.FindAllBuyOrders() which returns an IQueryable BuyOrder obj...