Sladescross's Blog

Blogging about Sharepoint related stuff

SSIS Container Hierarchy April 17, 2014

Filed under: Container,Container Hierarchy,Hierarchy,SSIS — sladescross @ 1:33 pm


SUS and Data Feeds April 16, 2014

Filed under: Data Feeds,NHS,SUS — sladescross @ 3:59 pm


OnPipelineRowsSent April 15, 2014

Filed under: Pipeline,Rows,SSIS — sladescross @ 4:29 pm


Analysis Services – Vision & Roadmap Update – Analysis Services and PowerPivot Team Blog – Site Home – MSDN Blogs

Filed under: BI,Roadmap — sladescross @ 7:49 am


SYSSSISLOG Squeeze the Asset for Reporting April 9, 2014

Filed under: Logging,SSRS,SYSSSISLOG — sladescross @ 4:08 pm


Unused and Missing Indexes DMV April 1, 2014

Filed under: DMV,Index,Missing,Optimisation,Performance,Unused — sladescross @ 4:51 pm


SQL Client and SQL Client Native

Filed under: ADO,Connection String,ODBC,Provider,SQL Client,SQL Native Client — sladescross @ 10:55 am

SQL Native client surfaces OLE DB and ODBC providers for SQL Server
SQLClient surfaces an ADO provider for SQL Server.

SQL Native Client is a new data access method from Microsoft. It boasts its own dynamic link library. This extends the capabilities of ADO on the SQL Server. This article explores two aspects of this method.

First, the methods of connection and command objects when the ADO accesses the database with the SQL Native Client provider are described with an example.

Provider=SQLNCLI.1;Integrated Security=SSPI; Persist Security Info=False;
Initial Catalog=Northwind; Data Source=Hodentekmysorian;
Use Procedure for Prepare=1;Auto Translate=True; Packet

The .NET Data Provider for ODBC access to data sources that are connected to using an ODBC driver.

The ODBC .NET Data Provider is an add-on component to the .NET Framework. It provides access to native ODBC drivers the same way that the OLE DB .NET Data Provider provides access to native OLE DB Providers A .NET Framework data provider also serves as a bridge between a data source and an ADO.NET DataSet. For data sources exposed by using ODBC. Uses the System.Data.Odbc namespace.

Sample Code

using System.Data.Odbc;
OdbcConnection myConnection = new OdbcConnection();
myConnection.ConnectionString = myConnectionString;
//execute queries, etc

Bridging to SQL Native Client 10.0 ODBC Driver


Driver={SQL Server Native Client 10.0};Server=urServerAddress;Database=urDataBase;
Uid=urUsername;Pwd=urPassword; DSN

strConnect = _T(“DSN=MyDSN;Uid=MyUsername;Pwd=MyPassword;”);



Get every new post delivered to your Inbox.

Join 63 other followers