How to use SQL Server native client OLEDB provider
This article tells how SQL Server native client OLEDB provider is connect to database
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