OLE DB Database Connectivity with R
Asked Answered
M

0

1

I am trying to connect to an iHistorian Database. This database is a product of GE and it records process control information. Anyway, this database is configured with OLE DB drivers. I am curious if there is a way to connect to this database with R. Currently, R has a package called RODBC, but this package only connects to ODBC. Any suggestions would be helpful.

Thanks

Mechling answered 26/6, 2013 at 20:42 Comment(2)
Unfortunately you may be out of luck, seeing as OLE DB is now a deprecated API. I'd be surprised if iHistorian didn't support ODBC though, as it's pervasive and cross-platform.Woodenware
Hi Hong, unfortunately after looking through manuals and computer files. iHistorian is only using OLE DB. I was curious whether I can embed C++/# code in my R code and use the OLE DB connection from the embedded code to get data. Or is this too much of a stretch?Mechling

© 2022 - 2024 — McMap. All rights reserved.