Hi,

I’m using a libname statement to connect to a Netezza server through SAS.

LIBNAME ntz oledb init_string="Provider=nzoledb; User ID=myuserid;Password=mypassword; Initial Catalog=mycatalog;Data Source=mysource;" schema=myschema;

What’s bothering me is that the statement seems to require my userid and password, which obviously I don’t feel comfortable leaving in my code and I wouldn’t want to delete and retype every time. That was not the case for SQL.

LIBNAME sqlsrv oledb init_string="Provider=sqloledb; Integrated Security=SSPI;Persist Security Info=True; Initial Catalog=mycatalog;Data Source=mysource" schema=myschema;

Is there any way I can have SAS pull my Windows credentials instead of having to type id and password in the libname statement?

Thanks,

G