Microsoft SQL Server Express is a freely downloadable and distributable version of Microsoft's SQL Server relational database management system. It is targeted for embedded and smaller-scale applications, having a number of technical restrictions.
Questions tagged [sql-server-express]
1718 questions
0
votes
1 answer
how can I generalize my code to rename column names via asp.net
I create a web form that contains: Dropdownlist, texbox and rename button.
The general idea is that Dropdownlist contains list of column names of one table in my database.
Then the user select one of these names and enter the new name in the…
rose khan
- 5
- 4
0
votes
1 answer
Telerik Open Access error on string with 8000 characters
I'm trying to save 8,000 characters to a SQL Server Express database table, and this may be smaller or larger in the future, and I'm getting an exception saying that the data will be truncated.
I've already set the column to varchar(max) and don't…
makerofthings7
- 60,103
- 53
- 215
- 448
0
votes
1 answer
VB.net Getting Scalar to save a value to a variable
I've been looking through the forums with no luck. I am trying to retrieve a value from a database and store it to a variable. The closest I got was following This. Here is my Code:
Dim dblAircraftHourlyRate As Double
Dim intAircraftID As…
VB noob
- 3
- 3
0
votes
1 answer
SQL EXPRESS Cant save changes to table
I have a big problem. I want to change something in my table from char to nchar (same size) and I'm getting this error:
Anyone know what to do about that?
Jan Macháček
- 612
- 7
- 11
0
votes
1 answer
SQLEXPRESS user login error
I'm trying to fire a web application from my local pc and it throws the error "Login failed for user DOMAIN\USER" (please note that I didn't type my actual values for the DOMAIN and USER in the above error).
I connect to SQLEXPRESS
Database is…
user2574948
- 247
- 1
- 3
- 16
0
votes
1 answer
Entity Framework and SQL Server Express bottlenecks
I have stumbled upon this slow performace problem using my local installed SQL Server 2008 Express.
(For complete background see my other SO post: EF query against Database View is very slow)
Instead, when I use SQL Server 2005 as the backend, I…
spiderman
- 1,565
- 2
- 16
- 37
0
votes
1 answer
VS Running SQL query against local database
I am trying to execute SQL query on a local databse that I created inside visual studio (service based database option). However when I click "Execute" I get the "Connect to Server" message and it asks for server name.
I have no idea what to enter,…
Chebz
- 1,375
- 3
- 14
- 27
0
votes
1 answer
Microsoft Access to SQL Server Express
I'm trying to develop a solution that manages a database of structural materials . So I'm using C# for the solution . Now , I want to connect it with a SQL Database(the structural material database) and I choose to use Microsoft SQL Server Express…
IrishDog
- 460
- 1
- 4
- 21
0
votes
3 answers
SQL Server Express ConnectionString not working
I am trying to connect to a local SQL Server Express database and I got it working inside a console application but now when I try to do it for a Windows service it doesn't work. I don't know what the problem is. The connection string that worked on…
user345453
- 52
- 1
- 10
0
votes
1 answer
How to insert into a Service-based Database
public partial class Form1 : Form
{
SqlConnection cn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Dimmer\Documents\Visual Studio 2013\Projects\Manage components\Manage components\Database1.mdf;Integrated…
Dim
- 3
- 1
- 3
0
votes
2 answers
Data access in ASP.NET: In-memory collection vs database
I'm new to ASP.Net, MVC and the Entity Framework.
I'd like to understand the best practice for small databases. For example, say at Contoso University we know there are only going to be a few hundred or a few thousand students and courses. So all…
Toby Sharp
- 2,029
- 3
- 19
- 21
0
votes
4 answers
What SQL Server (Express) logins are needed for an ASP.NET MVC site?
For ASP.NET webforms, I have always needed the following server login: [machine_name\ASPNET].
Questions
Is this requirement the same for ASP.NET MVC? If not, what do I need?
Does it matter what version of SQL Server I'm using? (Currently, I'm…
devuxer
- 41,681
- 47
- 180
- 292
0
votes
1 answer
asp.net mvc 4 local database to sql database after publish
I have built a mvc 4 intranet application that uses a local db to store info.
Now that i want to deploy it on a server entries are not saving to the database.
I have tried everything i can think of with no luck.
Is there a way to tell the…
Ernie
- 49
- 1
- 9
0
votes
2 answers
Prevent duplicate entry in database
private void Save_Click(object sender, EventArgs e)
{
string strconn = @"Server=.\SQLEXPRESS;initial catalog=PharmacyV2;integrated security=true;";
SqlConnection conn = new SqlConnection(strconn);
//SqlCommand cmd…
Engy Roshdy Louis
- 15
- 4
0
votes
2 answers
SQL Server Express data storage
Does MS SQL Server Express save one database per file (like SQLite, which I cannot use)?
I am asking because I want the users of my app to be able to easily exchange databases.
So, several files would make the whole procedure too hard, which is why…
user1598019