[SOLVED] SQLLocalDB.exe info - returns error code 15100, etc

SQLLocalDB.exe info - returns error code 15100, etc

I'm trying to work on a version problem with LocalDB. The command "sqllocaldb i" seems to work.

C:\WINDOWS\system32>sqllocaldb i

MSSQLLocalDB

ProjectsV12

But, when I ask for something specific, I get only errors. (I'm on Windows 10)

C:\WINDOWS\system32>sqllocaldb i MSSQLLocalDB

FormatMessageW failed. Error code returned: 15100

FormatMessageW failed. Error code returned: 15105

Solution

Thanks for the reply Paul. I have also removed all older SQL installs, but to get information on a particular LocalDB server instance using the SqlLocalDB.exe utility, I had to install the 2017 version. For instance I can now get information on an instance of SQLLocalDB (2016 version) that I created and called 'TAS_LocalDB_V13' using the command -

SqlLocalDB i TAS_LocalDB_V13

But, since there are now two versions of SQLLocalDB installed, there are two executables named SqlLocalDB.exe. The one that will run depends on the system environment path variable. I had to edit the path variable so that the path to SqlLocalDB.exe appearing first in the list was the 2017 version (which works).

Note - even though the i command in 2016 version does not work, other important commands like 'c' to create a server instance do work.