How to use trusted connection in ODBC driver

In this article I am going to explain about how to create connection string with trusted connection in SQL server native client 10.0 ODBC Driver.
  • 4822

Introduction

A trusted connection is similar to windows authentication. It is used for security purpose. To create connection string  with trusted connection in SQL server native client 10.0 ODBC Driver provider we need to put provider, your server address, your database name, set the state of Trusted connection to true.

Syntax:

Driver={SQL Server Native Client 10.0};Server=urServerAddress;Database=urDataBase;Trusted_Connection=yes;

Further Readings

You may also want to read these related articles :

Ask Your Question 

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

Programming Answers here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.