Introduction to UniOLEDB

This article explains about UniOLEDB and how it can be connected with database
  • 1900

Introduction :

OLE DB is a low-level interface that enables Universal Data Access (UDA), Microsoft's solution to data access challenges in today's highly sophisticated and versatile business data environments. UniOLEDB harnesses this technology to provide applications in an enterprise network with direct access to UniData and UniVerse data stores. UniOLEDB takes advantage of OLE DB technology to expose data in UniData and UniVerse databases to OLE DB–enabled client applications.

UniOLEDB is not built on top of UniData ODBC or UniVerse ODBC. It does not use ODBC as a way to implement OLE DB. UniOLEDB is a native OLE DB provider that takes advantage of OLE DB technology. UniOLEDB expects data to be organized relationally in first normal form, data in UniData and UniVerse must be presented in a standard non-extended table format.

Setting up UniOLEDB :

An OLE DB consumer connects to UniOLEDB, which establishes connections to remote data sources and sends database requests to one or more UniData or UniVerse servers. Consumers access data sources that are mapped to UniData or UniVerse accounts through entries in the UCI configuration file on the client machine.

Syntax :

DATA SOURCE=datasource_name;LOCATION=location_name;USER ID=user_name;PASSWORD=password;
 

Ask Your Question 

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

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.