Connection strings per databases, una pratica lista per categorie

Una pratica lista con le stringe di connessione più usate e divise per categorie:

---

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;

---

 

Il database completo lo potete trovare su connectionstrings.com