Questions tagged [sql-server-2012-localdb]

SQL Server 2012 Express LocalDB is local database that is come along with the SQL Server 2012 installation, it can be used for developers to work out with SQL Server 2012.

38 questions
0
votes
1 answer

Using Sync Framework in Visual Studio 2013

Does anyone have a walkthrough or video on how to use Sync Framework in VS 2013? I've seen nice examples using VS 2010 but some important items like local database cache object have been deprecated. For what I have read is that LocalDB will be…
0
votes
1 answer

Error: 51 - An instance name was not specified while connecting to a Local Database Runtime

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote…
Harsha V Chunduri
  • 394
  • 1
  • 4
  • 17
0
votes
3 answers

Left outer join in SQL Server 2012 LocalDB not working?

Using SQL Server 2012 (LocalDB), I have three tables: BESEXT.COMPUTER BESEXT.ANALYSIS_PROPERTY BESEXT.ANALYSIS_PROPERTY_RESULT These contains following info: BESEXT.COMPUTER: Mapping between ComputerIDs and ComputerNames BESEXT.ANALYSIS_PROPERTY:…
romatthe
  • 1,447
  • 3
  • 17
  • 33
0
votes
0 answers

fetch data from tableAdapter

Using Visual Studio 2012 I have a sql database with a table(name of table: gTable). I have "gTabletableAdapter". I have wrote some query in gTabletableAdapter and now I can use them from Form1.cs like…
Meysam Valueian
  • 661
  • 1
  • 5
  • 21
-1
votes
2 answers

How can I start my sql server?

Hi Please I stopped my sql server in order to attach a database and unknowingly I closed the sql studio and now i cant connect to the instance again because I can't start the server
-1
votes
1 answer

how to put sysdate as a default value for a date attribute in SQL Server LocalDB

I'm using ASP.NET, I want to put the value sysdate (like in Oracle) as a default value for a date column in my SQL Server LocalDB. I've tried to put SYSDATE and SYSDATETIME but it doesn't work. Here is my table definition : CREATE TABLE…
-1
votes
1 answer

Program works on local machine, but not on others [SQL Server localdb]

I've been creating a local off-line program in c#, following tutorials and learning as I go. I learned to create SQL Server databases and connect to them through the model first tutorial on MSDN. My application is working at the moment but only on…
-2
votes
1 answer

sql insert not working vb.net 2012

I was trying my best to insert records to a db. I am not getting the records added nor it shows some error. Please help me. I am using localdb with Visual studio 2012. Imports System.Data.SqlClient Imports System.Data Public Class tax_configure …
Ayoob Khan
  • 1,536
  • 2
  • 15
  • 13
1 2
3