×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

VS 2015 project - connecting to SQL Server database

VS 2015 project - connecting to SQL Server database

VS 2015 project - connecting to SQL Server database

(OP)
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

RE: VS 2015 project - connecting to SQL Server database

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!

RE: VS 2015 project - connecting to SQL Server database

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.

RE: VS 2015 project - connecting to SQL Server database

(OP)
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

RE: VS 2015 project - connecting to SQL Server database

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close