[R] non-interactive connection to SQL Server

[Moshe Olshansky]

Hi everyone,

I am afraid that I have already asked this question in
the past (or at least I knew an answer to it) but I am
unable to do it now.
I have an SQL Server data base. I used the GUI
interface of odbcDriverConnect to create a .dsn file
for this data base and every time I want to connect I
invoke odbcDriverConnect() which opens GUI from which
I choose my .dsn file and the connection is
established. 
Now I want to do this automatically (without GUI) and
all my attempts fail. If I remember correctly the dsn
must be a string containing all the connection details
but it does not work for me.

Could anybody help, please!

Thank you!
Moshe.