ODBC and SAS Working Directory

[ross47]

I'm trying to get a list of SAS datasets from a working directory other than the SAS install directory.  This is the connect string that I use:

Provider=SAS.BaseSASProvider;Data Source=local;SAS Executable=C:\Program Files\SASHome\SASFoundation\9.4\sas.exe;SAS Parameters=-initstmt %sasodbc(local) -icon -nosplash;SAS Working Directory=D:\MySASDatasetFolder

The OpenSchema method of the ADODB Connection object only returns tables for datasets in the SAS Executable directory.

How can I return tables for datasets in the D:\MySASDatasetFolder directory?

[ross47]

I'm trying to get a list of SAS datasets from a working directory other than the SAS install directory.  This is the connect string that I use:

Provider=SAS.BaseSASProvider;Data Source=local;SAS Executable=C:\Program Files\SASHome\SASFoundation\9.4\sas.exe;SAS Parameters=-initstmt %sasodbc(local) -icon -nosplash;SAS Working Directory=D:\MySASDatasetFolder

The OpenSchema method of the ADODB Connection object only returns tables for datasets in the SAS Executable directory:

_ConnectionPtr m_Conn;
m_Conn.CreateInstance(__uuidof(Connection));

_bstr_t connString(getConnectionString());
_bstr_t username(getUsername());
_bstr_t password(getPassword());

m_Conn->Open(connString, username, password, adModeUnknown);

_RecordsetPtr OSchema = m_Conn->OpenSchema(adSchemaTables);

How can I return tables for datasets in the D:\MySASDatasetFolder directory?  I suspect that it is a problem with my connect string but can't locate suitable documentation for confirmation.