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
1 answer

Deploying and setting up SQL Express 2008

Looking into installing an instance of SQL Express for an app. I want to have a separate installer. (I need to run some Transact-SQL stuff afterwards) I've been referencing this article. It is recommended that you ship the Express package…
petejamd
  • 523
  • 1
  • 10
  • 14
0
votes
1 answer

How to copy connected mdf database file (SQL Server Express)

I am using SQL Server 2008 R2 Express with Dataset tables (drag and drop tables from database into dataset window) all connected to my c# application via table adapter components from toolbox that means I have no SQL connection codes into my form…
user3157565
  • 1
  • 5
0
votes
1 answer

Distributing SQL Server Express

I have a windows service that hosts a WCF service which uses a sql server express database. I also have a setup project to intall the windows service. What are the steps I need to take to make sure SQL Server Express installs silently and that the…
cmaduro
  • 1,672
  • 3
  • 21
  • 40
0
votes
1 answer

Get error "could not load file or assembly microsoft.sqserver..." in ASP.NET SQL Server 2014 Express

I'm trying to add my .MDF file (DB) to my ASP.NET project. I connect the .mdf in my project to my external .mdf file. Everything is ok until I want to see the tables, and then I get this error: enter link description here I have SQL Server 2014…
Eliad
  • 140
  • 1
  • 11
0
votes
1 answer

Hosting ASP.NET Web App on IIS DB connection problems

I have used IIS before, but I've never used a database and I've never done a web app. I did the same steps for putting a site onto IIS and everything works EXCEPT for when I go to a page that has a DB connection on it. I've tried a lot and this is…
Chetdu
  • 136
  • 1
  • 2
  • 12
0
votes
2 answers

SQL Server Express, Database Deploy with C# Form

I made an application, and there is a problem with deploying a Form with SQL. Actually, somehow I made to deploy, but there is an error with app launching. I installed app on other PC and this is what the part of problem said: "a database with the…
Никола Р.
  • 33
  • 1
  • 11
0
votes
1 answer

Code first migration for a SQL Server CE database file

MigrateDatabaseToLatestVersion is used. The database that is stored within SQL Server Express is updated. When opening a local stored .sdf file (SQL Server CE database) with a valid path and file name, this file is not updated.…
mnemonic
  • 1,605
  • 2
  • 17
  • 26
0
votes
1 answer

How to insert data in Windows Form Application using c# in VS 2013?

I have been trying to insert Data in my Local Database Table using c# in Visual Studio 2013 since long but not able to succeed. What is the role of Data Dictionary? I am getting an exception a first chance exception of type…
Harsh Mehta
  • 1
  • 1
  • 1
  • 1
0
votes
1 answer

logparser TO_TIME output not matching the sql time datatype

Following is the QUERY from logparser : logparser -i:Textline "SELECT TO_DATE(TO_TIMESTAMP(TRIM(EXTRACT_SUFFIX(text,0,'TIMESTAMP')),'M/d/yyyy'))AS DATE, TO_TIME(TO_TIMESTAMP(TRIM(EXTRACT_TOKEN(text,0,'(')),'H:mm:ss')) as TIME from 'C:\xxxx.log'…
Vaibhav Mhala
  • 33
  • 1
  • 8
0
votes
1 answer

Migrate SQL Server Express database to SQL Server 2005

I created an ASP.Net MVC 2 project, but I want it to use a SQL Server 2005 database instead of the express version. Is there a way to force VS 2010 to create the database in SQL 2005, or at least migrate the schema to the new database? Thanks!
PBG
  • 8,944
  • 7
  • 34
  • 48
0
votes
2 answers

How to construct SQL query

I am working to implement a data connection between my C# application and a SQL Server Express database. Please bear in mind I have not worked with SQL queries before. I have the following relevant…
Max
  • 4,345
  • 8
  • 38
  • 64
0
votes
3 answers

.NET 3.5 SP1 required for EF SaveChanges

I have my .NET project target set to .NET 4 Full. It works well in Windows 7, 8 and 10. When I try to use it in Windows XP while .NET 4 and SQL Express 2008 R2 is installed, a call to DbContext.SaveChanges() throws an exception saying This…
Mohsen Afshin
  • 13,273
  • 10
  • 65
  • 90
0
votes
1 answer

How can i filter a datetime column using a where clause

I need to filter a datetime column which is named Departure. I need the filter to return all prices <=100 and where the departure date is between 2105-03-14 and 2015-03-17 and the departure time on these dates is from 1pm onwards. I tried the code…
frustrationmultiplied
  • 439
  • 8
  • 18
0
votes
3 answers

C# application connects to SQL Server remotely first two times but crashes the third

I have a SQL class that reads and writes data to a remote SQL Server database. When I start up the application, it connects and reads 2 tables but as soon as it tries to read the 3rd table, the application throws an exception : A network-related…
TommyB
  • 5
  • 6
0
votes
0 answers

sql express visual interface in visual studio 2013

I am using a SQL express databases in Visual studio 2013.But when i connect to sql express, open server explorer and trying to create a table, i see visual interface sql server db .Any adуas?
Denis1
  • 1
  • 2
1 2 3
…
99 100