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...
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...
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?