Solved

Installing SQL Server support files in a Visual Studio 2008 Installer project

Posted on 2010-08-26
1
265 Views
Last Modified: 2013-11-27
I have creating a .NET 3.5 application using Visual Stuido 2008.  I have made use of some features contained in the Microsoft.sqlserver.Smo Dll and want to ensure that my application will run on the target machine which may or may not have SQL Server 2008 installed (most likely it will not as these are client PCs).

I have created a Visual Studio 2008 Installation project which correctly lists the dependancies and installs the product correctly however I am not sure if just because the dependancy is listed in the installation project that the relelvant SQL server files are being installed.

Can anyone tell me if this is the case or if not how I can ensure that correct version of these files can be included in my setup project and installed along with the application.

In a similar way, my application uses .NET 3.5 and this is listed as a dependancy - will the installer install .NET 3.5 if required.

Sorry about the basis questions but I have always used InstallShield previously but no longer have a license so am trying to see if the in-built installer is sufficient for my requirements.
0
Comment
Question by:ChrisMDrew
1 Comment
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
Comment Utility
>>which may or may not have SQL Server 2008 installed (most likely it will not as these are client PCs).<<
My understanding is that you will require a SQL Server license installed on any workstation that uses SMO.

You can download the distributable package here:
Microsoft SQL Server 2008 Feature Pack, August 2008
http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Converting C# Objects into JSON file 7 36
AutoHotkey ActiveX Component Error 8 55
IN with @variable 5 16
Mssql SQL query 14 24
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now