What You Need to Know about SAS Connections

In most cases, you can use the SAS providers for OLE DB to perform the tasks that are described in the OLE DB specification. The only difference is the connection information. This chapter contains the following connection information that is specific to the SAS providers:
  • how to identify each provider.
  • a list of ADO connection properties for each provider.
  • sample code that illustrates three ways to open an ADO Connection object. The sample code uses the ProgIDs and connection properties that are discussed in this chapter.
  • an explanation of what the Data Source URI format is and how to use it when making connections. The Data Source URI format is the recommended way to specify connection information if you are running SAS 9.2 or newer and accessing data with a 9.2 or newer SAS Workspace Server or SAS OLAP Server.
Tip
Refer to the information in this chapter when you are writing your application.