Questions tagged [sql-server-2016-localdb]
33 questions
6
votes
1 answer
DacServices.Deploy to SQL Server LocalDB 2016 failing - unable to connect
This call to DacServices.Deploy has been working great for SQL Server LocalDB 2014, but fails when SQL Server LocalDB 2016 is installed:
string dacConnectionString = $"Server=(localdb)\\mssqllocaldb; Integrated Security=true;…
crimbo
- 10,308
- 8
- 51
- 55
5
votes
2 answers
Why can't I see a localdb database created by a UWP (Desktop Bridge App) in the SQL Server Object Explorer?
Does UWP support LocalDB?
My investigations indicate there are some issues using localdb that I don't experience with SQL Server 2017 Development edition.
I managed to convert a winforms EF-Code First, xaf application to run as a UWP app with the…
Kirsten
- 15,730
- 41
- 179
- 318
5
votes
2 answers
SQL Server 2016 Express LocalDb - does anybody have a link to the download page?
The link to download page of SQL Server Express 2016 LocalDb (https://www.microsoft.com/download/details.aspx?id=52679) is no longer working.
I have searched left and right on the Download Center, and also lot of websites online for this, but it's…
Dr.Viper
- 411
- 2
- 5
- 17
5
votes
2 answers
How can I specify to use SQL Server LocalDb 2014 rather than SQL Server LocalDb 2016 in the connection string?
Our application uses SQL Server LocalDb 2014 as the database engine. The connection string we use is
"Data Source=(localdb)\MSSQLLOCALDB;Initial Catalog=OurDatabase;MultipleActiveResultSets=True;Integrated…
Dabblernl
- 15,831
- 18
- 96
- 148
4
votes
1 answer
Connecting to LocalDB Server in Navicat Premium
Recently I installed LocalDb Serer on my laptop. I am trying to establish a connection between Navicat and LocalDB server. But unable to get the correct Host Name/IP Address for the LocalDB server.
I noticed by default LocalDB server always creates…
Bikash Behera
- 434
- 5
- 12
3
votes
2 answers
Connecting to localdb from pyodbc
Tried all sorts of variations to connect from python pyodbc to my local SQL Server
Also tried doing the \ escape
'Server=(LocalDB)\\MSSQLLocalDB;'
'UID=domain\\uname;'
but still get this error
I am able to connect to the same localdb from…
AtuD
- 83
- 2
- 11
3
votes
1 answer
Can't connect to Localdb but can using namedpipe
I am really suck with connecting my app to a database. I am trying to connect to a database using (localdb)\MSSQLLocalDB in the connection string and I get this error:
A network-related or instance-specific error occurred while establishing a…
SANM2009
- 1,918
- 2
- 12
- 30
3
votes
1 answer
Change the default version of MSSqlLocalDB for Visual Studio 2015
I am working on a C# project with SQL Server. For development, we use LocalDB instance of SQL Server. If something is changed in the database, we check-in the .mdf/.ldf files into TFS. The connection is made using MSSqlLocalDB.
The problem
After…
Bimal
- 350
- 1
- 7
- 21
2
votes
2 answers
SQL query is duplicating rows and using these rows in my aggregate functions
Hello sorry this might be a long one, I have a strange problem that has popped up. I'm trying to create an accounting like app in which several columns are aggregated by the group they belong to. However several of these columns could contain…
Michael
- 59
- 4
1
vote
0 answers
LocalDB requires SQL Server 2016 LocalDB
I have written an addin for my company using a local database. I am now in the stage of deploying it to other users using a setup so I can set the prerequisites. So far so good.
The issue I am having is that for some reason the database requires SQL…
lonnebol
- 67
- 1
- 7
1
vote
1 answer
SQL Server LocalDb ProjectsV13 Connection Failure
Using SQL Server 2016 (localdb)\ProjectsV13, I created a database - let's call it MyDatabase. All was fine and dandy until I decided I no longer needed it...
So in SSMS 2016, while connected to (localdb)\ProjectsV13, I right clicked on MyDatabase…
Scott Software
- 499
- 2
- 4
- 17
1
vote
1 answer
Entity Framework C# - DbGeometry POLYGON doesn't work
i have a problem with WKT and DbGeometry working together.
When i use POINT as geometry like this example it works good.
DbGeometry myGeometry1 = DbGeometry.FromText("POINT (30 10)");
DbGeometry myGeometry2 = DbGeometry.PointFromText("POINT (30…
Digitarca Lab3
- 13
- 3
1
vote
1 answer
ClickOnce Custom Prerequisite for SQL Server Express 2016 LocalDB?
I'd like to set LocalDB 2016 as pre-requisite when publishing my WPF application. But when I check default pre-requisites in Project Properties, only one available is for SQL Server 2012 Express LocalDB.
Any idea why there is no newer one, since…
IgorMF
- 144
- 1
- 11
1
vote
3 answers
no local server type "database engine" were found (V 2016)
I don't know many things about SQL server, today I install the SQL Server Management Studio 2016 and want to create a local Database. after search in the internet find this link from microsoft. in step 4 of this tutorial found this error when want…
Ashkan
- 1,357
- 4
- 16
- 37
0
votes
1 answer
SQL Server Local DB Stability Issues (Spring 2023)
We have a WPF .NET desktop application that uses SQL Server Local DB as its database. Our application is installed on hundreds of computers and has been released for about six years now.
We started running into multiple issues this Spring with…
adamjhilton
- 362
- 3
- 9