[R] non-interactive connection to SQL Server

From: Moshe Olshansky <m_olshansky_at_yahoo.com>
Date: Wed, 13 Feb 2008 21:19:21 -0800 (PST)


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.



R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Thu 14 Feb 2008 - 05:22:56 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 14 Feb 2008 - 07:30:13 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive