Displaying 1 result from an estimated 1 matches for "oga_dev".
Did you mean:
ifa_dev
2008 Oct 23
0
RODBC and RDCOM
I got a table on SQL Server, which has columns EquationId (int) and
Formula (varch(900)).
I need to select Formula with certain EquationId, for example,
Select Formula from OGA_DEV.dbo.Equation where EquationId = 3
I tried to work within RGui using RODBC:
> library(RODBC)
> conn = odbcConnect("SQL Server")
> odbcQuery(conn, "Select Formula from OGA_DEV.dbo.Equation where
EquationId = 3")
[1] 1
> results = sqlGetResults(conn)
> close(conn)...