How to use Microsoft OLEDB

This article describes how users can use Microsoft OLEDB.
  • 1362

Introduction :

Microsoft OLEDB is a set of OLE\COM interfaces that provide application with uniform access to data stored in diverse information sources. The OLEDB architechture defines OLEDB consumers and OLEDB providers. An OLEDB consumer is any system\application that uses OLEDB interfaces, an OLEDB provider is a component that exposes OLEDB interfaces.

User can connect it with datasource either by TCP/IP connection or APPC connection

Syntax :

Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=xxx.xxx.xxx.xxx;Initial Catalog=catalog_name;Package Collection=package_name;Default Schema=schema_name;User Id=user_name;Password=password

 

Provider=DB2OLEDB;APPC Local LU Alias=alias_name;APPC Remote LU Alias=remote_alias;Initial Catalog=catalog_name;Package Collection=package_name;Default Schema=schema_name;User Id=user_name;Password=password;

Ask Your Question

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

Programming Answers here

Categories

More Articles

© 2013 dotNetheaven. All rights reserved.