Re: [R] non-interactive connection to SQL Server

2009-01-30 Thread jt123
Moshe, Thanks so much for the added comment, I had fallen into the exact same little syntax pitfall. Your clarification really helped! Jack Moshe Olshansky-2 wrote: > > Yes, it does - thank you! > The only thing I forgot (and it took me a while to > find this out) was to separate the fields

Re: [R] non-interactive connection to SQL Server

2008-02-14 Thread Moshe Olshansky
Yes, it does - thank you! The only thing I forgot (and it took me a while to find this out) was to separate the fields by semicolon, i.e. the correct command is: odbcDriverConnect("driver=SQL Server; database=dataBaseName; wsid=myComputer; server=dataBaseServer; uid=moshe; pwd=moshe") --- Prof Br

Re: [R] non-interactive connection to SQL Server

2008-02-13 Thread Prof Brian Ripley
On Wed, 13 Feb 2008, Moshe Olshansky wrote: > 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 f