1. K

    Visual Studio Community Edition sql connect string

    I am trying to connect to sql express which is integrated with Visual Studio Community Edition (2013). this is my code and connect string. Dim mycn As New Odbc.OdbcConnection Dim strcn As String = "Data Source=(localdb)\v11.0;AttachDBFilename=|DataDirectory|\sqlserver.mdf;Integrated...
  2. I

    Question sql connection when using sqlDataAdapter

    Hi, Im after some advice on how i go about opening my sqlConnection. At the moment when my program is first run i open the sqlConnection and this is made as a public object so i can reference throughout the program without having to close it untill i close the program. I thought this was fine...
  3. fweiner

    Question sql ce database path

    I have three projects that will work from one db. I am installing them seperately using clickonce. The db is part of one installation located in |DataDirectory|. How do set connectionstrings in the other projects so that they too can connect to the db?