Newbie - connection to SQLServer via network

  • Thread starter Thread starter Jenny
  • Start date Start date
J

Jenny

Hi group,

how can I define an SQLConnection to SQLServer over network
instead of setting a local file via
Dim connection As New SqlConnection....

Cheers
Jenny
 
Hi Jenny

You should pass a connection string to SqlConnection object.
There are several ways:
- do it manually in code (see www.connectionstrings.com for details)
- at design time click on ConnectionString row in Properties window
- drag server from Server Explorer window
 
Back
Top