This article describes how to create a new connection to SQream via the RODBC driver.
This article assumes you have R installed on Windows. The Linux version should be similar, but requires installation of the unixODBC package.
In the R console, type
If this succeeds, skip to the next step. Otherwise, install by typing
and then type
again to verify that the install succeeded.
Below is a sample connection flow. Make sure to edit in the correct DSN, as you configured with the Windows ODBC Data Sources tool. In the example below, we connect to an existing DSN named sqream64.
Please note the configuration flag believeNRows=F - this is an important flag, and the ODBC driver will not work properly without it.
In this case, we're checking against a table 't' that has a few int-type columns columns, named xint, xtinyint and so on.
> library("RODBC") > ch <- odbcConnect("sqream64",believeNRows=F) > sqlQuery(ch,"select top 5 * from t") xint xtinyint xsmallint xbigint 1 1 82 5067 1 2 2 14 1756 2 3 3 91 22356 3 4 4 84 17232 4 5 5 13 14315 5
If something else appears or you get an error, please contact SQream support.