libname budget oledb provider=jet provider_string='Excel 8.0' datasource='d:\excel80\Y2Kbudget.xls';
UDL_FILE="C:\WinNT\profiles\me\desktop\MyDBLink.UDL"
.
This option does not support SAS filerefs. SYSDBMSG is not set
on successful completion. For more information, see Microsoft documentation
about the Data Link API. This option overrides any values that are
set with the INIT_STRING=, PROVIDER=, and PROPERTIES= options.
init_string='Provider=SQLOLEDB;Password=dbmgr1;Persist Security Info=True;User ID=rachel;Initial Catalog=users; Data Source=dwtsrv1';
OLEDB: Provider=SQLOLEDB;Password=dbmgr1; Persist Security Info=True;User ID=rachel; Initial Catalog=users;Data Source=dwtsrv1;
OLEDB:
prefix and
any initial spaces before the first listed option. There is no default
value. However, if you specify a null value for this option, the OLE
DB Provider for ODBC (MSDASQL) is used with your default data source
and its properties. See your OLE DB documentation for more information
about these default values. This option overrides any values that
are set with the PROVIDER= and PROPERTIES= options. To write the
initialization string to the SAS log, submit this code immediately
after connecting to the data source:
%put %superq(SYSDBMSG);
not set (see Locking in the OLE DB Interface)
|
|
not set (see Locking in the OLE DB Interface)
|
|
libname mydblib oledb user=username password=password datasource=dept203 provider=sqloledb properties=('initial catalog'=mgronly); proc print data=mydblib.customers; where state='CA'; run;
libname mydblib oledb user=username password=password datasource=v2o7223.world provider=msdaora prompt=yes; proc print data=mydblib.customers; where state='CA'; run;