Re: Programmatically get OLDDB Version (and other properties)

This page might help;

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjconnectionpme.asp

There is a Provider and Version property that are wrapped by the Delphi ADO
implementation.

I suggest for ADO specific intel you look into the ADO Programmers
References on msdn;
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmscadoapireference.asp

hth,

brian


--
Got a big event coming up? Let us
help coordinate your event. For more
visit www.kissemgoodbye.com
"Clayton Arends" <nospam_claytonarends@xxxxxxxxxxx> wrote in message
news:46717ad9$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Does anyone know how to generically and programatically determine the
OLEDB
driver version of an open ADO connection? If this is possible then I
would
also like to retrieve other properties about the driver. A list or link
to
where I can find this information would be appreciated.

I have scoured Google looking for the answer to what I thought was a
simple
problem. I have found some answers that say to check for the following
properties (neither exist):

OLE DB Version
Provider Version

Using a test Oracle connection I retrieved the following list of
properties:

Password
Persist Security Info
User ID
Data Source
Window Handle
Locale Identifier
Prompt
Extended Properties
OLE DB Services

I also connected to a test Jet database. It has many more properties and
includes the set of above properties.

TIA,

- Clayton




.

Relevant Pages

  • Re: Recommended data access model
    ... This is from MDAC 2.8 SDK. ... "The Role of ADO in MDAC ... The Microsoft Data Access Components provide data access that is ... easy-to-use interface to OLE DB. ...
    (comp.databases.ms-access)
  • Re: Table adapter ???
    ... ADO was a lightweight COM layer built on top of OLE DB. ... ADO and OLE DB updates came in downloads of the MDAC pack (Microsoft Data ... It also came with a OLE DB provider for ODBC which meant ...
    (microsoft.public.data.ado)
  • Re: ADO
    ... OLE DB, you need to usually use C++ as you are calling API's directly. ... Eventually, ADO will no longer be supported, and ADO.NET is the way forward ... >> Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: ADO
    ... OLE DB is a data access paradigm designed to provide an object interface to ... OLE DB data "providers". ... The original question asked which is better: ADO or OLE DB. ...
    (microsoft.public.data.ado)
  • Re: CADORecordBinding ... adDate
    ... That's ado ENUM reference "adDBTimeStamp". ... So, speaking from and OLE DB perspective, which is where I am when I do ... >> The sample in MSDN states using a DBDATE variable, ...
    (microsoft.public.data.ado)