Known Issues for the SAS/SHARE Provider
Reopening a connection fails on Windows 7.
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()
Copyright © SAS Institute Inc. All rights reserved.