How to Generate a List of Supported ADO Properties

The following sample code displays a list of ADO Connection properties and their defaults in the VB Immediate window. The example uses the latest version of the IOM provider, as indicated by the value of the Connection object's Provider property. To specify a different provider, replace "sas.IOMProvider.9.2" with the appropriate ProgID (see How to Identify the SAS Providers).

Option Explicit
Sub Main()
    Dim obConnection As New ADODB.Connection
    Dim obRecordset As New ADODB.Recordset
    Dim p As ADODB.Property
    obConnection.Provider = "SAS.IOMProvider.9.2"
    For Each p In obConnection.Properties
        Debug.Print p.Name & " = " & p.Value
    Next p
End Sub

List of Properties for the IOM Provider

Password = 
User ID = 
Asynchronous Processing = 0
Data Source = 
Window Handle = 0
Locale Identifier = 0
Location = 
Mode = 19
Prompt = 4
Extended Properties = 
SAS Cell Cache Size = 10000
SAS Logical Name = 
SAS Machine DNS Name = 
SAS Port = 0
SAS Protocol = 0
SAS Server Type = 1
SAS Service Name = 
SAS Workspace Interface = 
SAS Workspace ID = 
SAS Workspace Init Script = 
SAS Metadata User ID =
SAS Metadata Password =
SAS Metadata Location =
SAS Repository ID =
SAS Repository Name =

List of Properties for the OLAP Provider

Password = 
User ID = 
Asynchronous Processing = 0
Data Source = 
Window Handle = 0
Locale Identifier = 0
Location = 
Mode = 19
Prompt = 4
Extended Properties = 
SAS Cell Cache Size = 10000
SAS Logical Name = 
SAS Machine DNS Name = 
SAS Port = 5451
SAS Protocol = 2
SAS Server Type = 2
SAS Service Name = 
SAS Workspace Interface = 
SAS Workspace ID = 
SAS Workspace Init Script = 
SAS Metadata User ID =
SAS Metadata Password =
SAS Metadata Location =
SAS Repository ID =
SAS Repository Name =

List of Properties for the Local Provider

Password = 
User ID = 
Data Source = 
Window Handle = 0
Location = 
Mode = 19
Prompt = 4
Extended Properties = 
SAS File Format =

List of Properties for the SAS/SHARE and Base SAS Providers

Password = 
User ID = 
Data Source = 
Window Handle = 0
Location = 
Mode = 19
Prompt = 4
Extended Properties = 
SAS Local Server = 0
SAS Executable = C:\Program Files\SAS\SASFoundation\9.2\sas.exe
SAS Parameters = -initstmt %sasodbc(sdplserv) -icon -nosplash
SAS Working Directory = C:\Program Files\SAS\SASFoundation\9.2\
SAS Server Access Password = 
SAS Server Release = 9