Questions about database connection

Azzyloth Pakdemol

1. Is it possible to just share my program that is already installed in my computer so that the other who is/are connected to the wifi can use it?

2. How can i change my database string to permanent? Like after installing my C# application to another computer, i want to run it without changing the database string? Do i really need to use SQL server? What version of sql server is compatible with my visual studio ultimate 2013? Is there any compatibility on that or i can just use any version of sql server?

3. Is it possible to use SQL server using only wifi and not LAN? Do i really need to use windows server 2008/2012 or is it ok to use windows 7, 8.1 ,10?

Thank you in advance to those who will answer. Also, you can share links for tutorials about my questions above.

Here's my database connection on my C# program..

SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\HP\Documents\Visual Studio 2013\Projects\Coding\Coding\Coding.mdf;Integrated Security=True;Connect Timeout=30");

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Sawardekar8y ago
Accepted answer
Yes, you can use it in wifi. You dont need to have lan connection. But there are more chances of data loss. I have practically implemented it. Change your connection string to somthing like below,
ADMIN-PC\SQLEXPRESS;MultipleActiveResultSets=true;Trusted_Connection=Yes;Connect Timeout=300;Initial Catalog=xxxxData;User ID=sa;Password=*****;Integrated Security=False;
You dont need to have any server operating system.
Nilesh Sawardekar8y ago
If you want to publish your application.. I suggest, dont use localDB
Azzyloth Pakdemol8y ago
Do i need to change some settings on my program like in app.config? because your connection is sqlexpress. Mine is localDB