Displaying 2 results from an estimated 2 matches for "analoghistory".
2001 Nov 13
1
RODBC
...R
> library(RODBC)
library(RODBC)
> channel <- odbcConnect("SCADA2","ways1","LO&B*O",case="msaccess")
> channel
channel
[1] 0
And an abreviated table list is:
...
25 Runtime dbo AnalogHistory
TABLE
...
When I try to query the table, I get:
> test <- sqlQuery(channel,"select datetime, value from analoghistory where
tagname = 'a055-re-0020_ph_pv_flt' and datetime >= 'nov 1, 2001 2:00pm'")
> test
test
[1] "37000 201 [Microsoft][ODBC SQL Server...
2001 Nov 14
0
RODBC: Minor problem, I hope.
...> library(RODBC)
library(RODBC)
> channel <- odbcConnect("SCADA2","ways1","LO&B*O",case="msaccess")
> channel
channel
[1] 0
And an abbreviated table list is:
...
25 Runtime dbo AnalogHistory
TABLE
...
A abbreviated Column List is as follows:
> odbcColumns(channel,"AnalogHistory")
odbcColumns(channel,"AnalogHistory")
[1] 1
> sqlGetResults(channel)
sqlGetResults(channel)
TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME DATA_TYPE TYPE_NAME
1 Runtime...