How to Retrieve Version Information for a Provider

Retrieve Version Information for the Provider Implementation

You can use either of these methods in order to retrieve version information for the provider implementation:

After an ADO Connection object is open, use the "Provider Version" property from the Connection object Properties collection. The version appears in the form MM.mm.rr.bbbb where MM is the major release number, mm is the minor release number, rr is the revision number, and bbbb is the build number.
If a Connection object is not open, then use the provider's .DLL file. Here are the steps:
1. In Windows Explorer, navigate to your C:\Program Files\SAS\SASProvidersForOLEDB\9.3\ folder. The 32-bit versions of the providers are in the 32-bit directory. On 64-bit machines, the 64-bit versions are in the 64-bit directory.
2. Right-click on the .DLL file associated with the provider that you want to check. Here are provider .DLL files for SAS 9.3:
  
  sasaorio.dll for the IOM provider and the OLAP provider
  
  sasafloc.dll for the local data provider
  
  sasafshr.dll for the SAS/SHARE provider and the Base SAS provider
3. Select Properties from the pop-up menu.
4. In the Properties dialog box, click the Version tab to see the version number.

Retrieve Version Information for a Server

After an ADO Connection object is open, use the "DBMS Version" property in the Connection object Properties collection. The version appears in the form MM.mm.rrrrfMMDDYY where MM is the major release number, mm is the minor release number, rrrr is the maintenance release number, f is for Performance Image, and MMDDYY is the port date.

Note: The local provider does not have an associated server. If you request the server property from the local provider, it returns the provider implementation version.

Retrieve Version Information for the ADO Interface

After an ADO Connection object is open, use the Connection object "Version" property.

Sample Code to Retrieve Version Information for a Provider, a Server, and the ADO Interface

The following Visual Basic code shows you how to retrieve version information for a provider, a server, and the ADO interface. The code assumes that an ADO Connection object is open.

Dim strProviderVersion As String
Dim strServerVersion As String
Dim strADOVersion As String
If obConnection.State = adStateOpen Then
	strProviderVersion = obConnection.Properties("Provider Version")
	strServerVersion = obConnection.Properties("DBMS Version")
	strADOVersion = obConnection.Version
End If