❔ 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;");
from that picture what may be?
5 Replies
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.
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
Well, you need to use the one that matches your chosen database
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
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
Was this issue resolved? If so, run
/close - otherwise I will mark this as stale and this post will be archived until there is new activity.