Resources

Connecting to a Specific SAS/SHARE Server Version

In this recipe, you learn how to prepare the SAS/SHARE Data Provider to access a specific version of the SAS/SHARE Server. Sample code for the ADO recipe is included.

Applies to: SAS/SHARE Data Provider
Implement using: ADO or OLE DB

Overview

By default, the SAS/SHARE provider uses the SAS 9.1 server access method. However, you can explicitly request access to a Version 7 or Version 8 SAS/SHARE server.

For example, when you are writing to the ADO interface, you set the "SAS Server Release" property to the server version value. The following code specifies the Version 6 SAS/SHARE server.


obConnection.Provider = "sas.ShareProvider.1"
obConnection.Properties("SAS Server Release") = 7
obConnection.Open


Details

When writing to the ADO interface, the value of the "SAS Server Release" property determines which access method the provider uses to communicate with the SAS/SHARE server. The property is set on the Connection object because the connection is bound to a specific server.

Values for the "SAS Server Release" property are integer numbers that correspond to the version number of the server being accessed: 7, 8, or 9. The default value is 9. The value 8 is valid for both Version 7 and Version 8 server. You only need to explicitly set the "SAS Server Release" property if you are accessing a SAS/SHARE server other then SAS 9.1.

When writing to the OLE DB interface, the access method is set with the DBPROP_SAS_SERVERRELEASE property. This property is a member of the DBPROPSET_SAS_DBINIT property set.


See Also:

Connecting to a Remote IOM Server
Connecting to a Remote SAS OLAP Server with the IOM Provider
Connecting to a Remote SAS/SHARE Server