Mssqlserver connection Daquan SQLServerconnectionstringsSQLODBCconnectionstringsStandardSecurity: & lt; br & gt; & quot; Driver {SQLServer}; ServerYour_Server_Name; DatabaseYour_Database_Name; UidYou mssql server connection Daquan
SQL Server connection strings
SQL ODBC connection strings
Standard Security: <br> "Driver = {SQLServer}; Server = Your_Server_Name; Database = Your_Database_Name; Uid = Your_Username; Pwd = Your_Password ;"
Trusted connection: <br> "Driver = {SQLServer}; Server = Your_Server_Name; Database = Your_Database_Name; Trusted_Connection = yes ;"
SQL OLE DB connection strings
Standard Security:
"Provider = SQLOLEDB; Data Source = Your_Server_Name; Initial Catalog = Your_Database_Name; UserId = Your_Username; Password = Your_Password ;"
Trusted connection:
"Provider = SQLOLEDB; Data Source = Your_Server_Name; Initial Catalog = Your_Database_Name; Integrated Security = SSPI ;"
SQL OleDbConnection. NET strings
Standard Security:
"Provider = SQLOLEDB; Data Source = Your_Server_Name; Initial Catalog = Your_Database_Name; UserId = Your_Username; Password = Your_Password ;"
Trusted connection:
"Provider = SQLOLEDB; Data Source = Your_Server_Name; Initial Catalog = Your_Database_Name; Integrated Security = SSPI ;"
SQL SqlConnection. NET strings
Standard Security:
1. "Data Source = Your_Server_Name; Initial Catalog = Your_Database_Name; UserId = Your_Username; Password = Your_Password;" <br> 2. "Server = Your_Server_Name; Database = Your_Database_Name; UserID = Your_Username; Password = Your_Password; Trusted_Connection = False"
Trusted connection:
1. "Data Source = Your_Server_Name; Initial Catalog = Your_Database_Name; Integrated Security = SSPI ;"
2. "Server = Your_Server_Name; Database = Your_Database_Name; Trusted_Connection = True ;"
Database odbc connection method
MySQL connection strings
MySQL ODBC connection strings
Open connection to local MySQL database using MySQL ODBC 3.51 Driver
"Provider = MSDASQL; DRIVER = {MySQL ODBC 3.51 Driver}; SERVER = localhost; DATABASE = Your_MySQL_Database; UID = Your_Username; PASSWORD = Your_Password; OPTION = 3"
MySQL ole db & OleDbConnection (. NET framework) connection strings
Open connection to MySQL database:
"Provider = MySQLProv; Data Source = Your_MySQL_Database; User Id = Your_Username; Password = Your_Password ;"