Resources

SAS IOM Data Provider ADO/OLE DB Recipes

The following table provides a list of IOM Data Provider recipes and their descriptions.

This recipe... Explains how to do this...
Opening an ADO Connection Object Open an ADO Connection object. Lists required and optional connection properties for each of the SAS Data Providers.
Making Connections by Using the Microsoft Data Link API Use the Microsoft Data Link API to prompt users for OLE DB connection information at run time and to provide persistent connection information for the SAS Data Providers.
Controlling Data Access Permissions with a Connection Set permissions on your data source.
Reusing an Existing IOM Workspace Associate a running SAS workspace object with an ADO Connection object.
Assigning a Libref to Use with the IOM Provider Assign a libref when using the IOM Data Provider to open or create a table. Explains how to execute a LIBNAME statement through an ADO or OLE DB Command object and how to use the AssignLibref method from the IOM DataService class.
Connecting to a Remote IOM Server Establish a connection to a remote SAS IOM Server. Explains how to set properties on the ADO Connection object and how to create a SAS workspace using the SAS Integration Technologies Workspace Manager.
Identifying a Data Set to Open Specify a data set depending on which SAS provider you are using.
Opening a Password-Protected Data Set Open a data set that requires a password.
Padding Character Data with Blanks Force the SAS Data Providers to preserve trailing blanks.
Updating Records Perform recordset updates, including how to handle batch updates.
Reading a SAS/ACCESS Data Set Access third-party data stores that are available through your licensed SAS/ACCESS engines.
Implementing a Locking Strategy Lock records that you are updating to prevent data loss.
Creating and Deleting Data Sets Create and delete data sets. Explains how to use SQL CREATE TABLE and DROP TABLE statements; how to use Microsoft ActiveX Data Object Extensions for DDL and Security (ADOX); and how to use the OLE DB ITableDefinition interface.
Executing SQL Queries and Commands Execute SQL queries and commands.
Reading Missing Values from a Data SetTest for missing values.
Writing Missing Values to a Data SetWrite missing values to a data set.
Using Formats When You Read Data Obtain access to SAS formatting features when reading data.
Using Informats When You Write DataObtain access to SAS informatting features when writing data.
Applying User-Written Formats and InformatsOpen data sets that include user-written formats and informats created using the SAS FORMAT procedure.
Displaying Metadata Specific to SASDisplay metadata that is specific to SAS data sets.