Example DB Connection Strings

MySQL: host=IPAddress;user=username;passwd=password;db=db_name

SQL Server: Driver={SQL Server Native Client 11.0};Server=hostnameinstance;Database=AdventureWorks2012;Uid=username;Pwd=password

SQL Server with Windows credential management (aka Trusted Connection): Driver={SQL Server Native Client 11.0};Server=hostnameinstance;Database=AdventureWorks2012;Trusted_Connection=Yes

SQL Server alternate tcp format: \”DRIVER={SQL Server};Server=tcp:listener-hostname,1433;database=example;\”

MS Access: \"Driver={Microsoft Access Driver (*.mdb)};DBQ=Path\\to\\db.mdb\"

See http://connectionstrings.com for more info on ODBC connection strings (for SQL Server).

Oracle (SID): “host=computer.department.com;user=username;password=examplepassword;SID=ORCL”

Oracle (Service name): “host=computer.department.com;user=username;password=examplepassword;port=1521;service_name=DB01”

Oracle (DSN): “user=username;password=examplepassword;dsn=xxxx”