Re: [R] Change database in SQL Server using RODBC

find a solution. Br. Frede Sendt fra Samsung mobil Oprindelig meddelelse Fra: Ira Sharenow Dato:30/06/2014 16.42 (GMT+01:00) Til: Peter Crowther ,R list Emne: Re: [R] Change database in SQL Server using RODBC Thanks for everyone’s feedback. library(RODBC) con = odbcConnect

Re: [R] Change database in SQL Server using RODBC

0/06/2014 16.42 (GMT+01:00) Til: Peter Crowther ,R list Emne: Re: [R] Change database in SQL Server using RODBC Thanks for everyone’s feedback. library(RODBC) con = odbcConnect("SQLServer2012") orders1 = sqlFetch(con,"dbo.orders") odbcClose(con) Allowed me to close the co

Re: [R] Change database in SQL Server using RODBC

Please post here using the plain text option in your email software because the HTML is not coming through undamaged. The first argument to the odbcConnect function is never SQL syntax... for SQL Server it is always a "Data Source Name" (DSN) that has been predefined in the ODBC administration

Re: [R] Change database in SQL Server using RODBC

Thanks for everyone’s feedback. library(RODBC) con = odbcConnect("SQLServer2012") orders1 = sqlFetch(con,"dbo.orders") odbcClose(con) Allowed me to close the connection properly. Thanks. However, I still cannot figure out how to connect to the second database and table. library(RODBC) >c

Re: [R] Change database in SQL Server using RODBC

On 30 June 2014 02:44, Ira Sharenow wrote: > I wish to query tables that are NOT in the default SQL Server 2012 database. > Now for the problem. I also want to read in the table dbo.sports. That > table is in the database sportsDB. I did not see any way to do so from > within R. Can you not use s

Re: [R] Change database in SQL Server using RODBC

Hi See inline below for my comments. Yours sincerely / Med venlig hilsen Frede Aakmann Tøgersen Specialist, M.Sc., Ph.D. Plant Performance & Modeling Technology & Service Solutions T +45 9730 5135 M +45 2547 6050 fr...@vestas.com http://www.vestas.com Company reg. name: Vestas Wind Systems A/