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 »