VS 2015 project - connecting to SQL Server database

[JScannell]

I've been struggling with this dilemma and don't know what the answer is. I have created a VS 2015 windows form project and that connects to a remote SQL Server database. I know how to do the development but have a huge question about deploying the run time to another person's PC. Will it be necessary for me to install SQL Server on the end user's PC in order for them to be able to run the code that queries the SQL database? The database is located on a remote server somewhere. I have the proper connect string to it and it works on my PC both in VS debug and as a compiled application.

But, I have SQL server installed on my computer but my end users don't.

I have .net framework 4.0 installed and have references to several of the System.xxx.dlls including System.Data.dll which allows me to Import System.Data.SqlClient into my project. That allows me to create all of the SqlXxxx objects I need.

So, do I have to anything special on my end users' computers to enable them to run my application?

Thanks in advance,
Jerry

Jerry Scannell

 

[jebenson]

The .NET Framework has data providers built in, including the SQL client. As long as your app will run, it should be able to connect to the SQL Server.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

 

[SaltyTheFrog]

Well, in my opinion, you need to connect to the database some how and if it is only on your computer than you will need the other computer to be able "talk" to it. There are a variety of ways to do that. Unless I'm really missing the mark if you want a database on your computer to be available to another computer it needs networked or installed on the other computer with some way to keep them in sync.

 

[JScannell]

SaltyTheFrog,

The SQL server isn't on my PC. It is installed on a server somewhere. The connection string that I use points to that server location.

The question I asked pertains to what may need to be installed on my client's computer in order for him to be able to run my software after I install it on his PC.

JEBENSON basically answered it by saying that as long as the .net framework is installed on my client's computer, they will be OK.

Thank you JEBENSON for the answer.

Jerry

Jerry Scannell

 

[SaltyTheFrog]

OK...Good luck. When you said "I have SQL server installed on my computer but my end users don't." I thought that was the case.