SQL Server with ODBC Driver and OLE DB Provider

In this article I will explain you about How to use SQL Server with ODBC Driver and OLE DB Provider.
  • 1585

Introduction

ODBC Driver and OLE DB provider are contained in the file sqlncli10.dll.

Coding

Standard for security

Driver={SQL Server Native Client 10.0};Server=tcp:[serverName].database.windows.net;Database=myDataBase;Uid=[LoginForDb]@[serverName];Pwd=myPassword;Encrypt=yes;


OLE DB

SQL Azure does not support OLE DB connections

 

You may also want to read these related articles : here

Ask Your Question 

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

Programming Answer here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.