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) >con2 = odbcConnect("[sportsDB].dbo.sports") Warning messages: 1: In odbcDriverConnect("DSN=[sportsDB].dbo.sports") : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: In odbcDriverConnect("DSN=[sportsDB].dbo.sports") : ODBC connection failed >con2 = odbcConnect("[sportsDB].[dbo].sports") Warning messages: 1: In odbcDriverConnect("DSN=[sportsDB].[dbo].sports") : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: In odbcDriverConnect("DSN=[sportsDB].[dbo].sports") : ODBC connection failed >con2 = odbcConnect("[sportsDB].[dbo].[sports]") Warning messages: 1: In odbcDriverConnect("DSN=[sportsDB].[dbo].[sports]") : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: In odbcDriverConnect("DSN=[sportsDB].[dbo].[sports]") : ODBC connection failed >con3 = odbcConnect("SQLServer2012") >orders3 = sqlFetch(con3, "sportsDB.dbo.sports") Error in odbcTableExists(channel, sqtable) : âsportsDB.dbo.sportsâ: table not found on channel On 6/30/2014 1:34 AM, Peter Crowther wrote: > On 30 June 2014 02:44, Ira Sharenow <irasharenow...@yahoo.com> 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 sportsDB.dbo.sports to reference the table? > > In general, table reference syntax is [ [ [ serverName '.' ] > databaseName '.' ] [schema ] '.' ] tableName, where the names need > only be surrounded by [...] if they are not valid SQL Server > identifiers. Many people may suggest you reference > [sportsDB].[dbo].[sports]; this is unnecessary verbiage. > > Cheers, > > - Peter > [[alternative HTML version deleted]]
______________________________________________ R-help@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.