Net connection SQL database code Daquan

I. SQL server connection code example

　　ODBC

Standard Security:

"Driver = {SQL Server}; server = aron1; database = pubs; uid = sa; Pwd = asdasd ;"

　　Trusted connection:

"Driver = {SQL Server}; server = aron1; database = pubs; trusted_connection = yes ;"

　　Prompt for username and password:

　　Oconn. properties ("prompt") = adpromptalways
Oconn. Open "driver = {SQL Server}; server = aron1; database = pubs ;"

　　Oledb, oledbconnection (. NET)

　　Standard Security:

"Provider = sqloledb; Data Source = aron1; initial catalog = pubs; user id = sa; Password = asdasd ;"

　　Trusted connection:

　　"Provider = sqloledb; Data Source = aron1; initial catalog = pubs; Integrated Security = sspi ;"
(Use servername \ InstanceName as data source to use an specifik sqlserver instance, only sqlserver2000)
Prompt for username and password:
Oconn. provider = "sqloledb"
Oconn. properties ("prompt") = adpromptalways
Oconn. Open "Data Source = aron1; initial catalog = pubs ;"

　　Connect via an IP Address:

　　"Provider = sqloledb; Data Source = 190.190.200.100, 1433; network library = dbmssocn; initial catalog = pubs; user id = sa; Password = asdasd ;"
(Dbmssocn = TCP/IP instead of named pipes, at the end of the data source is the port to use (1433 is the default ))
Sqlconnection (. NET)

　　Standard Security:

"Data Source = aron1; initial catalog = pubs; user id = sa; Password = asdasd ;"

　　Trusted connection:

"Data Source = aron1; initial catalog = pubs; Integrated Security = sspi ;"
(Use servername \ InstanceName as data source to use an specifik sqlserver instance, only sqlserver2000)

　　Connect via an IP Address:

"Data Source = 190.190.200.100, 1433; network library = dbmssocn; initial catalog = pubs; user id = sa; Password = asdasd ;"
(Dbmssocn = TCP/IP instead of named pipes, at the end of the data source is the port to use (1433 is the default ))
Declare the sqlconnection:

　　II. C # connect to the Code instance

Using system. Data. sqlclient;
Sqlconnection osqlconn = new sqlconnection ();
Osqlconn. connectionstring = "My connectionstring ";
Osqlconn. open ();

　　Iii. Connecting VB. NET to SQL database code instance

Imports system. Data. sqlclient
Dim osqlconn as sqlconnection = new sqlconnection ()
Osqlconn. connectionstring = "My connectionstring"
Osqlconn. open ()