Leonardo

Connection strings for databases, a practical list with categories

A practical list with the most used connection strings divided into categories:    Microsoft SQL Server 20xx  STANDARD SECURITY  Server=myServerAddress;Database=myDataBase;User Id=myUsername;  Password=myPassword;  TRUSTED CONNECTION  Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;  CONNECTION TO AN INSTANCE  Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername; Password=myPassword;  CONNECTION VIA IP ADDRESS  Data Source=190.190.200.100,1433;Network Library=DBMSSOCN; Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;  ASYNCHRONOUS PROCESSING  Server=myServerAddress;Database=myDataBase;Integrated Security=True; Asynchronous Processing=True;  WITH MARS (Multiple Access Result Set)  Server=myServerAddress;Database=myDataBase;Trusted_Connection=True; MultipleActiveResultSets=true; Access  STANDARD SECURITY  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb; …

Connection strings for databases, a practical list with categories Read More »

Share on Social Media
Scroll to Top