C#•3y ago

❔ Azure data studio connection string.

i'm using linux so i use Azure data studio as sqlserver management studio. but i can't know the connection string that i will use in ado, when using sqlconnection, i tried that:

var con=new SqlConnection("Server=localhost;Database=mydeb;User Id=sa;Password=25509;");

var con=new SqlConnection("Server=localhost;Database=mydeb;User Id=sa;Password=25509;");

var con=new SqlConnection("Server=localhost;Database=mydeb;User Id=sa;Password=25509;");

var con=new SqlConnection("Server=localhost;Database=mydeb;User Id=sa;Password=25509;");
from that picture what may be?

Angius•9/14/23, 10:17 PM

https://www.connectionstrings.com/

ConnectionStrings.com - Forgot that connection string? Get it here!

All connection strings in one place. Find the syntax for your database connection using ADO.NET, ADO, ODBC, OLEDB, C#, VB, VB.NET, ASP.NET and more.

AAngius https://www.connectionstrings.com/

eidOP•9/14/23, 10:46 PM

thanks, but there r a lot of string connection i can't know which one i should use, i mean i want one that has all the parameters in my picture, the way of paramters is working good with me, but i need it in the shape of string connection to add the right string connection in my sqlcomandconnection in ado

Angius•9/14/23, 10:47 PM

Well, you need to use the one that matches your chosen database

Angius•9/14/23, 10:48 PM

Then you input your server where it says "server", your username where it says "username", your database name where it says "dbname", and so on

eidOP•9/14/23, 10:52 PM

from the awesome link u send , i tried one of the strings, i tried that and add the params of my picture:
Server=localhost;Database=default;User Id=sa;Password=1243455;
but there is params i don't know what the equivalent string to it, like encrypt:mandatory(true),server group <default> and trusted server certificate:true

Accord•9/15/23, 11:09 PM

Was this issue resolved? If so, run

/close

/close

otherwise I will mark this as stale and this post will be archived until there is new activity.

❔ Azure data studio connection string.

Similar Threads

Similar Threads

Similar Threads