GENiALi's Blog

inDE Original

0TweetsRetweet

For those who still don't know it.
http://www.ConnectionStrings.com/

This Web site has just once again helped me.
ConnectStrings to various DB's are listed here.

Here an example of the SQL Server (.NET):
[...]

• Standard security:
  
  "Data source = Aron1; initial catalog = pubs; user ID = sa; password = asdasd;"
  -or-
  "Server = Aron1; database = pubs; user ID = sa; password = asdasd; Trusted_Connection = false"
  (both connection strings produces the same result)
  
• 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))