How to use SQL Server native client OLEDB provider

This article tells how SQL Server native client OLEDB provider is connect to database
  • 1513

SQL Native client is a stand alone data access Application Programming Interface that is used for both OLEDB and ODBC. It combines both SQL OLEDB provider and the SQL ODBC driver into one native Dynamic Link Library while also providing new functionality above and beyond that supplied by the Microsoft Data Access Component. It is used to create new applications or enhance existing application. There are two types of SQL Server native client OLEDB provider

10.0 Native Client OLEDB provider

Connection string used to connect with database is as follows

Provider=SQLNCLI10;Server=server_add;Database=database_name;uid=user_name;pwd=password;

Connection string for creating trusted connection with the data base is

Provider=SQLNCLI10;Server=server_add;Database=database_name; Trusted_Connection=Yes;

Connection string to connect oledb provider to SQL Server instance

Provider=SQLNCLI10;Server=server_name\instance_name;Database=database_name; Trusted_Connection=Yes;

9.0 Native Client OLEDB provider

Connection string used to connect with database is as follows

Provider=SQLNACLI;Server=server_add;Database=database_name;uid=user_name;Pwd=password;

Connection string for creating trusted connection with database is

Provider=SQLNACLI;Server=server_add;Database=database_name;Trusted_Connection=Yes;

Connection string to connect oledb provider to SQL Server instance

Provider=SQLNCLI;Server=server_name\instance_name;Database=database_name; Trusted_Connection=Yes;

Ask Your Question

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2013 dotNetheaven. All rights reserved.