Workshop set up the databases fails in Sqlcmd

[clausndk]

Hello Adam and others

I have a problem setting up my machine for the workshop, at the step: Set up the databases:
https://github.com/Particular/Workshop#set-up-the-databases

Running the command:
PS C:\Code\Workshop> .\exercises\scripts\Setup-LocalDBInstance.ps1
Creates the following error:
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Data source name not found and no default driver specified.

I have the following listed in "Apps and Features":

Script output:

My Windows setup:

Can anybody help?

[adamralph]

Hi @clausndk, have you installed the latest versions of LocalDB and SQLCMD? I was also having problems on one machine, but after installing the latest versions of everything, it all worked.

I think, from your screenshots, you have the latest versions, but I just want to make sure.

BTW - SQLCMD also requires ODBC Driver 13.1 (or, presumably, later) to be installed, so it may be worth checking if you also have the latest version of that. (I'll raise a PR to get that added explicitly in the set up instructions.)

[clausndk]

Success! ODBC Driver 13.1 helped :)

[dvdstelt]

lol, this was still open in edit mode. I wanted to post this but totally forgot.

@clausndk I had the same experience @adamralph mentioned. I just installed my machine freshly and had not set up the workshop database before.
I installed the ODBC 13.1 drivers, sql commandline utilities and it worked flawlessly. I haven't installed any SQL (Express) or anything, except Visual Studio 2017.

[adamralph]

@clausndk that's good to know, thanks!

I think it's probably better if we just say "install SQLCMD and the ODBC driver" rather than "check if you have SQLCMD and install it (and the ODBC driver) you don't". I'll raise a PR to change the set up instructions.