Related resources for OLE-DB
  • OLE DB errors in Power BI9/19/2023 5:01:25 AM. This article helps you in understanding causes and solutions for common OLE DB errors in Power BI.
  • Data Components in Visual Studio .NET: Part I10/30/2020 1:15:12 AM. In this article, I will help you in understanding using the Server Explorer for Adding a new Connection.
  • Understanding ADO.NET Components10/29/2020 4:28:12 AM. In this article I will explain about ADO.NET Components.
  • Working with Data Bound Controls10/29/2020 12:35:48 AM. Step by step tutorials teaches you how to use data-bound controls DataGrid, ListBox, and ComboBox controls .
  • Connection strings for IBM DB210/29/2020 12:13:52 AM. IBM DB2 primarily runs on Unix, Linux IBM I, z/OS, and windows server. It is a relational database management system that comes in a variety of versions, running on devices ranging from handhelds to m
  • SQL Server Integration Services (SSIS) - OLE DB Command Task in SSIS7/8/2019 7:06:12 AM. This is part 60 of the series of article on SSIS. In this article we are going to see how to use the OLE DB Command Task in SSIS packaging.
  • Linked Servers in SQL Server6/4/2019 2:04:36 AM. This article helps you to understand the concept of Linked Servers in SQL Server 2008, 2012. I will show with an example, how to connect the two different databases using Linked Servers in SQL Server
  • Writing a Generic Data Access Component3/7/2019 12:31:49 AM. I've received couple of emails people asking me how can they use a common data provider to access various types of data sources without loosing the power and flexibility of native data provider li
  • How to Insert a Date Into DateTime Column Using ADO.NET & C#1/16/2014 12:39:24 PM. In this article, we will show how to insert a date into a date column using ADO.NET and C#.
  • SQL Programming using .NET10/20/2012 4:14:10 AM. This program shows several data objects, some draw backs of each and some interesting things.
  • Connection Strings for SQL Server 20085/20/2012 1:58:34 AM. SQL Server 2008 includes better compression features, which also helps in improving scalability. It enhanced the indexing algorithms and introduced the notion of filtered indexes. It includes capabilities for transparent encryption of data (TDE) as well as compression of backups.
  • Using Dynamic Database Connections10/8/2010 10:53:02 AM. The DataLinksClass class in the Microsoft OLE DB Service Component Library can be used to dynamically create or modify a connection string during execution.
  • DataAdapter Properties and Methods in ADO.NET1/6/2010 11:14:49 PM. In this article I will explain about DataAdapter Properties and Methods in ADO.NET.
  • Understanding Connection Pooling in ADO .NET1/1/2010 8:36:33 AM. In this article I will explain Understanding Connection Pooling in ADO .NET
  • Oracle Connectivity in .NET8/31/2006 6:16:06 AM. This whitepaper takes you through different ways of database connectivity to Oracle database from .NET. This also talks about the advantages and disadvantages of all of these technologies.
  • Real Life SQL and .NET : using SQL with C#: Part X2/6/2006 1:15:23 AM. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.