Connection strings for databases, a practical list with categories

/ Technology / By

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; 
Persist Security Info=False; 

WITH PASSWORD 

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb; 
Jet OLEDB:Database Password=MyDbPassword; 

 

Azure 

STANDARD 

Server=tcp:[serverName].database.windows.net;Database=myDataBase; 
User ID=[LoginForDb]@[serverName];Password=myPassword;Trusted_Connection=False; 
Encrypt=True; 

WITH MARS (Multiple Active Result Set) 

Server=tcp:[serverName].database.windows.net;Database=myDataBase; 
User ID=[LoginForDb]@[serverName];Password=myPassword;Trusted_Connection=False; 
Encrypt=True;MultipleActiveResultSets=True; 

 

MySql 

STANDARD 

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; 

SPECIFIC TCP PORT 

Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername; 
Pwd=myPassword; 

MULTIPLE SERVERS 

Server=serverAddress1, serverAddress2, serverAddress3;Database=myDataBase; 
Uid=myUsername;Pwd=myPassword; 

USING ENCRYPTION 

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; 
SslMode=Preferred; 

 

SQLite 

BASIC 

Data Source=c:\mydb.db;Version=3; 

WITH PASSWORD 

Data Source=c:\mydb.db;Version=3;Password=myPassword; 

Oracle 

STANDARD 

Data Source=MyOracleDB;Integrated Security=yes; 

AUTHENTICATION 

Data Source=MyOracleDB;User Id=myUsername;Password=myPassword; 
Integrated Security=no; 

PROXY 

Data Source=myOracleDB;User Id=myUsername;Password=myPassword; 
Proxy User Id=pUserId;Proxy Password=pPassword; 

 

IBM 

DB2 STANDARD 

Server=myAddress:myPortNumber;Database=myDataBase;
UID=myUsername;PWD=myPassword; 

INFORMIX STANDARD 

Database=myDataBase;Host=192.168.10.10;Server=db_engine_tcp;Service=1492; 
Protocol=onsoctcp;UID=myUsername;Password=myPassword; 

 

 The complete database can be found on connectionstrings.com  

Share on Social Media