Stack Overflow
Stack Overflow

Questions tagged [sql-server-express]

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.

1718 questions
0
votes
2 answers

Can't connect to Microsoft SQL Server 2012 Express with Visual Studio

I'm new to Visual Studio and SQL Server Express, so I'm sorry of my lack of knowledge. I have tried to connect in two ways and none of them works. I first wrote a element in web.config file.
Jesper Hellberg
  • 1
  • 1
0
votes
2 answers

SQL Server 2008 Express Clear Recent Connection List

I was trying to remove my recent connection list by deleting the mru.dat (in Application Data folder under windows xp) file as pointed out in numerous tutorial over the internet(I just googled it) but was unable to find it. How am I supposed to…
Soham Dasgupta
  • 5,061
  • 24
  • 79
  • 125
0
votes
1 answer

SQL Server express maintenance

I'm currently trying to develop a solution for data logging related to a SCADA application, using SQL Server 2012 Express. The SCADA application is configured to execute a stored procedure on SQL Server to push data in the db. The data flow imho is…
Kalibr
  • 105
  • 1
  • 9
0
votes
0 answers

SQL Query in Crystal Reports does not function properly

Using Microsoft SQL Server Express I'm fairly new to crystal reports and am trying to generate a report that looks like this: https://i.stack.imgur.com/euH2F.jpg Is it possible to create an SQL query which has these entries as some sort of array or…
ijustlovemath
  • 703
  • 10
  • 21
0
votes
1 answer

Iphone SQL Server Express data sync

I have asked this question before but not for sql server express. It seems that web services is not an option for syncing sql server express and iphone. Besides that it is not a necessity to sync within 3G or a Wifi connection. It is good enough to…
immuner
  • 243
  • 1
  • 7
  • 18
0
votes
0 answers

Error inserting/deleting records ASP.NET web application deployed on Windows server 2012

I developed an ASP.NET web application and it worked fine locally with IIS express. I created deployment package and installed the application on my Windows 2012 server. When developing the application, I was using an mdf file with localdb v11.0. On…
paulstomb
  • 21
  • 1
  • 4
0
votes
3 answers

SQL View Statement

I am trying to make a view that has 6 columns, and each row is the first 3 rows from 2 columns of another table. For Example: Asset Table Asset_ID Asset_Name 1 Kitchen 2 Bathroom 3 Bedroom 4 Bed 5 …
user3169698
  • 143
  • 5
  • 23
0
votes
1 answer

use sqlserver for local based app

I'm working currently on a windows form application which uses a Database, and i want to use MS SqlServer, now i need to know how to make it local based.. In other words : after publishing the app and install it on another device, it'll crash…
DoO37
  • 5
  • 2
0
votes
1 answer

Determining if .mdf needs an .ldf to attach

I want to be able to look at a .mdf before trying to attach it and determine if it will be possible to attach it without it's .ldf (this can be done if it was detached correctly). Currently, I am trying to attach the .mdf and if it was detached…
petejamd
  • 523
  • 1
  • 10
  • 14
0
votes
3 answers

Cannot open database "MyDb" requested by the login. The login failed. Login failed for user 'My-PC\\MrD'

I have been connecting to my local database (SQL Express) fine all day from my C# console application. I have made an update, where I create a database and table from within the C# code using ADO.NET When I do this, my normal connection string…
MyDaftQuestions
  • 4,487
  • 17
  • 63
  • 120
0
votes
1 answer

Error while trying to attach .mdf to a SQL Server Express 2008

The snapshot says is it all - I used to be able to attach a database, but after i detached today then tried to attach, i kept getting this error: http://img197.imageshack.us/img197/2574/attacht.jpg…
peace
  • 837
  • 2
  • 12
  • 18
0
votes
3 answers

Include SQL Server Express in setup project

I create project in Visual Studio. My app use .mdf files. I created a setup project using InstallShield. On my computer where I developed my app, setup works just fine! But when I install app on another machine I get an error you need install SQL…
Coffeeman
  • 285
  • 1
  • 6
  • 17
0
votes
1 answer

Advice needed: cold backup for SQL Server 2008 Express?

What are my options for achieving a cold backup server for SQL Server Express instance running a single database? I have an SQL Server 2008 Express instance in production that currently represents a single point of failure for my application. I…
Mike Chamberlain
  • 39,692
  • 27
  • 110
  • 158
0
votes
1 answer

How to display a field from SQL database in a message box

I have this already on VB: Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim con As New SqlConnection Dim cmd As New SqlCommand Try con.ConnectionString =…
Danny
  • 1
  • 2
0
votes
0 answers

Connect Remotely to SQL Server Express instance hosted on Google Compute Engine

I'm trying to access SQL Server Express installed on Windows Server 2012 on Google Compute Engine VM. I have assigned STATIC IP to the instance and also added an exception to the firewall in Windows for port 1433 as well as in via console area of…
Altaf Sunesara
  • 1
  • 1
1 2 3
…
99 100