mssql server 连接大全
sql server connection strings
sql odbc connection strings
standard security: driver={sqlserver};server=your_server_name;database=your_database_name;uid=your_username;pwd=your_password;
trusted connection: 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; 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;
数据库odbc连接方法
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.51driver}; 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;