Connecting to SQLBase Chapter 4 Introducing SQLBase OLE DB Data Provider This chapter contains an overview of SQLBase OLE DB Data Provider functionality and software requirements.It also discusses Active X Data Objects (ADO) and how the SQLBase OLE DB Data Provider works with the ADO standard.Recommended reading To make the best use of OLE DB, we recommend that you read .About SQLBase OLE DB Data Provider Built upon OLE DB technology, SQLBase OLE DB Data Provider lets programmers access SQLBase functionality from a variety of supported visual programming tools.
SQLBase OLE DB Data Provider name When you configure a programming tool to use the Provider, you may need to enter a provider name.Data source name Some programming tools may prompt you for a data source name.For SQLBase OLE DB, the data source name is the name of the SQLBase database itself (for example, ISLAND).In MSDN, search for those method or interface names to get more detail on the overall transaction process. The first parameter of the ITransaction Local:: Start Transaction method is isolation level. ADO's primary benefits are data source independence, high speed, ease of use, low memory overhead, and a small disk footprint.Use one of the supported levels shown in Isolation level mapping. Since ADO is independent of the data source, you do not have to know all the intricacies of the database to take advantage of the provider.