Displaying 2 results from an estimated 2 matches for "odbccolumns".
2001 Nov 13
1
RODBC
I'm tryuing to get the RODBC package to work with a MS Sql database
(Wonderware's InSQL). I'm able to connect to the database using the
following:
version
_
platform i386-pc-mingw32
arch x86
os Win32
system x86, Win32
status Under development (unstable)
2001 Nov 14
0
RODBC: Minor problem, I hope.
...nnel <- 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 dbo AnalogHistory DateTime 11 datetime
2 Runtime...