Re: ADO Version Overview
- From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
- Date: Tue, 15 Nov 2005 19:01:24 -0000
> I am confused about the various MDAC versions. On My server there seem to
be
> many versions from 2.1 to 2.8 are all of these avalivle for use?
What makes you think there are multiple versions installed on your server?
> Or as a
> newer one is installed it is the one that interacts with the application
such
> as and aspx page getting data from SQL Server?
>
> Is the a tool to manage or remove older versions?
I don't think the older versions are installed. ADO object are COM objects
and each successive version of MDAC is backwardly compatible with the older
versions. The result is that if you had an App that was compiled with MDAC
2.5, and it needed to open a 2.5 Recordset, that is no problem even if MDAC
2.8 is installed. A 2.8 Recordset exposes a 2.5 Recordset interface (and all
previous Recordset interfaces) and it is the 2.5 interface that the App uses
(of the 2.8 Recordset). The same is true for Connection & Command objects.
> Is there a way to tell which ones are being used?
See above.
> Is there a way to determine what Providers are in specific MDAC versions?
AFAIK, the providers that come with MDAC are
Microsoft provider for Oracle
Microsoft provider for SQL Server
Microsoft provider for ODBC drivers
That is it
For Microsoft Jet 4.0 provider (for Access) you have download separtely
Stephen Howe
.
- Prev by Date: How to sort Scandinavian letters using recordsets
- Next by Date: Re: ADO Version Overview
- Previous by thread: How to sort Scandinavian letters using recordsets
- Next by thread: Re: ADO Version Overview
- Index(es):
Relevant Pages
|
|
