You must first install SAS ODBC driver. The connection string can be
found on SAS web site.
http://www.sas.com/rnd/eai/oledb/dbs001.htm gives some info.
The provider to use depends how data is accessed. There are 3
providers
SAS IOM Data Provider
SAS Local Data Provider
SAS/SHARE Data Provider
for local data, use something like
obConnection.Provider = "SAS Local Data Provider"
obConnection.Properties("Data Source") = "C:\My Documents\SAS Files"
obConnection.Properties("SAS File Format")="V8"
obConnection.Open
On Mon, 26 Mar 2001 12:34:15 +0200, "alfred.puth"
Quote:
>I need to connect to a SAS dataset in my VB code. I normally connected to
>Microsoft Access and this is the first time I need to connect to a different
>database.
>Is there anyone that has the code for the connection to a SAS dataset.
>Thanks
>Alfred
SAS connection string