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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error while exporting data of Outlook to sqlserver 2
Transaction Scope and DTC Needs? 5
SqlConnection problem. How config user name and password? 3
SqlExpress & C# problem in an ASP.NET web site 2
Connection failure: SqlServer does not exist or access denied. 3
Messages from stored procedure 1
How does ADO.NET handle transactions when the connection is broken 1
SqlConnection and Static Properties 4

Back
Top