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 ()