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
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
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
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
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
On Behalf Of Ira Sharenow
> Sent: 30. juni 2014 03:45
> To: r-help@r-project.org
> Subject: [R] Change database in SQL Server using RODBC
>
> I wish to query tables that are NOT in the default SQL Server 2012 database.
>
> At work I am using SQL Server 2012 and Windows 7. I te
I wish to query tables that are NOT in the default SQL Server 2012 database.
At work I am using SQL Server 2012 and Windows 7. I tested the following
on my home set up of Server 2012 and Windows 7. I am using RStudio.
I wish to connect to several SQL Server 2012 databases from R.
This page help
7 matches
Mail list logo
