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.
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