Member Avatar for ravi.kant.984349 
Dear All !
    I have developed a Software for a Hospital using vb.net 2005 & Sql Express.  Now i want to connect this data through lan. What connection string should i give. Please suggest. Below is my current connection string which i have used for it.

Dim conn As New SqlConnection()
conn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Data\Sadar_Hospital.mdf;Integrated Security=True;User Instance=True"
  • 2 Contributors
  • 1 Reply
  • 98 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

You just replace ".\SQLEXPRESS" with the name of the new server. Depending on the security setup you may have to change to a username/password authentication. If authentication will be based on the windows domain username then you can use the existing Integrated Security.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.