Known Issues for the SAS/SHARE Provider

When an ADO connection object is opened, closed, and then reopened, the connection fails. SAS has noticed that the "Data Source" property is cleared when a connection object is closed in a Windows 7 operating environment.

To reuse a connection object, set the user-specified properties again before calling the open method.

Dim obConnection As New ADODB.Connection
obConnection.Provider = "sas.ShareProvider"
obConnection.Properties("Data Source") = "C:\v9data"
obConnection.Properties("SAS File Format") = "V9"
obConnection.Open()
...
obConnection.Close()
' Set the connection properties again before the call to Open()
obConnection.Properties("Data Source") = "C:\v9data"
obConnection.Properties("SAS File Format") = "V9"
obConnection.Open()
...
obConnection.Close()