How to connect to MSSQL database from .NET Core project on os x?

M

mr_blond972017-07-23 22:34:42

ASP.NET

mr_blond97, 2017-07-23 22:34:42

There is a project on ASP .NET Core that connects to MSSQL database.
The project connects to the database on os windows and gives an error "error: 25 - Connection string is not valid" on os x. On os x, it is possible to connect to the database through the DataGrip client. Also on os x it is possible to connect via telnet to port 1433.
Connection string:
"DefaultConnection": "Data Source=xxxx\\SQLEXPRESS,1433;Database=basename;User Id=sa;Password=userpassword;Pooling=False"
How to connect to MSSQL database from .NET Core project on os x?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

D

d-stream, 2017-07-23
@mr_blond97

30 seconds of googling brings up https://github.com/aspnet/EntityFramework/issues/6791

K

Konstantin Tsvetkov, 2017-07-24
@tsklab

Connection string

To test the connection string, create an empty (0 bytes) test.udl file . Run it, set up the connection (with verification). Use the line from this file.