Which API should I use:
For .NET Framework in Visual Basic, C#, J# or C++ or any other managed language, – ADO.NET or OLEDB interface
For .ASP based application, a VB 6 COM application, or a C++ application that is already using COM or COM+ – OLEDB programming model. For ODBC or OLE DB to access SQL Server – SQL Native Client. For Java code targeting SQL Server, – JDBC.