windows authentication connection string

code as follows: Server = Myserveraddress;database = MyDataBase; Trusted_Connection = True; 4. Connect a trusted connection to a Windows CE device Usually a Windows CE device cannot be authenticated and logged in a domain. In order for a CE device to use SSPI or trusted connections and authentication, you c

From: http://hi.baidu.com/zpylh_hust/blog/item/8d4ac68b85498b789e2fb496.html Adomdconnection object: This connection and ADO. net is very similar, mainly responsible for connecting to the target library. but there is a difference, that is, from this object, you can obtain allCubeBody and dimension information, which is different from the objects we normally connect to the database. Remember to read the nbearCodeThe structure of the database table

string for this wave. In a string variable, describe the server address, database name, and integrated security (that is, whether Windows authentication is used) that is required for the connection string. If the SQL Server servi

; Connect a trusted connection to a Windows CE deviceTypically, a Windows CE device cannot be authenticated and logged on in a domain. In order for a CE device to use SSPI or trust connection and authentication, you can use the following

One, the first connection string to connect to SQL Server:is for SQL SERVER and Windows for the database authentication mode,The connection string is:CString strconn;strconn = "Provider = sqloledb.1;\Persist Security Info = true;\

already confused. The connection string is automatically decrypted when ASP. NET is needed, or if you need to make some changes, such as changing the password, you can manually enter the following code to decrypt it.Aspnet_regiis–pdf connectionStrings C:\Websites\BegAspNet2DbNote that by default, the encryption process uses a key for a machine that is based on an encryption algorithm. The decryption proces

, the above is the two simplest connection string, now let us specifically analyze:(1)DataSource: Specifies the name of the data server to which you want to connect. The writing format is typically "data server name/instance name".DataSource can also be replaced with SERVER,ADDRESS,ADDR. If the database server is local, the entry can be written "." Directly. or "(local)" does not include quotation marks.If

, authentication is performed using the current Windows account credentials.The recognized value is true, false, yes, no, and SSPI (strongly recommended) equivalent to True. Multipleactiveresultsets ' False ' If true, the application can maintain multiple active result sets (MARS). If False, the application must process or cancel multiple result sets in one batch before executing any oth

C # database connection string set(1) Common connections:1. Use the sqlconnection object: A. SQL VerificationPublic void sqlconnectionopen (){Sqlconnection conn = new sqlconnection ();Conn. connectionstring = "User ID = sa; Password =; initial catalog = northwind; datasource = localhost; Connect timeout = 20 ";Conn. open ();} B. Windows

Label:Let's take a look at the default connection SQL Server database configuration You need to use ConnectionString when instantiating SqlConnectionStringBuilder. such as: sqlconnectionstringbuild builder = new Sqlconnectionstringbuild (connectionString); First, Data SourceThe DataSource property of the SqlConnectionStringBuilder, corresponding to the data source in connectionstring, "data source" can be replaced by the following