Below is a list of examples of database connection strings to use with various SQL Server data providers (ODBC, OLE DB, OleDbConnection (.NET), SqlConnection (.NET)) in your application.
1. ODBC Connection String
Driver={SQL Server}; Server=database_host; DATABASE=database_name; Uid=database_user; Pwd=database_user_password; |
2. OLE DB, OleDbConnection (.NET) Connection String
Provider=sqloledb; DATA SOURCE=database_host; Initial Catalog=database_name; USER ID=database_user; Password=database_user_password; |
3. SqlConnection (.NET) Connection String
DATA SOURCE=database_host; Initial Catalog=database_name; USER ID=database_user; Password=database_user_password; |