"noninteractive" meaning you supply name and password?
In code? I know nothing about OLE DB, but AFAIK you should set that name/password pair in the ODBC properties, no?
Or are you trying to set name and pass on the fly for a good reason?
Many fears are born of stupidity and ignorance -
Which you should be feeding with rumour and generalisation.
BOfH, 2002 "Episode" 10