SQL Client Connectivity SDK and Client Tools SDK DOCUMENTATION?? - by JBurgess

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 381445 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 11/12/2008 8:41:43 AM
Access Restriction Public


The SQL 2008 install, "Features Selection" screen lists 2 items we can find no documentation for:

SQL Client Connectivity SDK
Client Tools SDK

Shouldn't there be a clear explanation of these, with a list and explanation of the items in these SDKs??  
Sign in to post a comment.
Posted by Jeromeyers on 3/6/2015 at 9:29 AM
Wow, depressing. What really gets me is that I can't even get any info on Google. It's like a blindspot in the world.
Posted by Boris Hristov on 10/21/2014 at 4:41 AM
I would also want to see those described in more detail! In what scenarios would I need to have Client Tools SDK and SQL Client Connectivity SDK on my machine where the instance is living? If I am using this same machine for development purposes? When? And how can such "descriptions" be called "descriptions". For me a description is something like this:

Includes a set of technologies for copying and distributing data and database objects from one database to another and synchronizing between the databases for consistency. You can use replication to distribute data to different locations, and to remote and mobile users over local and wide area networks, dial-up connections, wireless connections and the Internet.

Obviously there is a way to actually do a proper description in this window.
Posted by piers7 on 6/29/2014 at 6:51 PM
Not fixed! The sum content for the added doco (apparently, see http://msdn.microsoft.com/en-us/library/ms143786.aspx) is this:

Client Tools SDK - Includes the software development kit containing resources for programmers.
SQL Client Connectivity SDK - Includes SQL Server Native Client (ODBC/OLE DB) SDK for database application development

That's *woeful*, and pretty much just expands the component name, rather than adding any actual _information_, such as:
- what components (managed, native etc...)?
- for what types of developers?
- in what scenarios?

Do I really have to diff two SQL installs to work out what this feature actually adds?

@Pawan - if the STrace library is needed by the client tools, it wouldn't be an optional install, surely.
Posted by Pawan Gonnakuti on 12/19/2011 at 1:48 PM
SQL Client Connectivity SDK and Client Tools SDK provided the Wrapper objects for COM components.

Client Tools SDK Provide wrappers classes for DTSRuntime and similar components that you can use to Execute a .dtsx (SSIS) package on demand. Most of the People install Integration Service to perform similar task.

Also SQL Client Connectivity SDK plays a key role in providing Microsoft.SQLServer.Diganostics.STrace library used by Client Tools.

Now, you can use this Wrapper classes to run a SSIS package from within your WCF/WebService/Windows Service or any other .Net App without calling a SQL Agent Job.

there are probably more uses to this library and would be great if someone added to my comment.
Posted by Microsoft on 10/10/2011 at 11:54 PM
Thanks everyone for your feedback on the missing description about the SQL Server features. We have added description on the Feature Selection Setup screen, and explanation on the F1 help topic "Feature Selection".

I am closing this for now, and please feel free to reopen if you have any further questions around this.

Chaitanya Medikonduri
SQL Server Technical Writer
Posted by Microsoft on 9/21/2011 at 5:35 AM
Please check the latest UI screens for SQL Server Denali CTP3 Installation. Please let us know if this answers your question
Posted by TheHose on 4/26/2011 at 10:11 AM
How about an explanation before we get ready to install, Yea I don't think we will get to Mars
Posted by djlucas on 8/24/2010 at 8:27 AM
We'll never get to Mars.
Posted by Karthika [MSFT] on 4/28/2010 at 2:32 PM
This feature installs the files needed to develop a SQL Server Native Client application.

We will be adding this explanation in the future F1 help files for the dialog page.

Please let us know if this helps answer your question.


Posted by Karthika [MSFT] on 4/28/2010 at 10:47 AM
This issue was closed by mistake as there were duplicates tracking the same issue. We apologize for the inconvenience. We will post a message shortly in the sql express forum as requested.

Thank you for your patience and we are extremly sorry for the inconvenience.

Posted by JBurgess on 4/28/2010 at 8:02 AM
Closed as "fixed" with no further explanation - typical Microsoft arrogance.
Posted by thisisfutile1 on 4/21/2010 at 11:35 AM
April 21, 2010 and still waiting...
Posted by Ivan Pankov on 12/25/2009 at 2:26 PM
I have exactly same question, what is SQL Client Connectivity SDK? Can you post an answer here, so at least we can get an answer before "the future version of SQL Server documentation"? :)
Posted by Kolik Software on 11/23/2009 at 2:12 AM
Microsoft, is it really such a big problem to write a short description here?
Posted by NetSplinter on 1/21/2009 at 12:52 PM
This question is also going unanswered in the forums: http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/72f8d636-05d1-44c5-b63b-0b12191de3e4/
Posted by Karthika [MSFT] on 12/21/2008 at 10:48 AM
Thank you for your feedback. We will investigate this issue and address it in the future version of SQL Server documentation.

Posted by minx10 on 12/10/2008 at 5:04 PM
I just installed SQL Express 2008, and saw the option for SQL Client Connectivity SDK. I didn’t know whether I needed this or not. So, to be safe, I just added it to the pending installation list. I only like to install what is essential. Having a description on the install options would have helped to determine whether to install it or not.