rsqlserver

rsqlserver copied to clipboard

Connection strings such as - `server\instance` - `(localdb)\v11.0` - `domain\username` are all valid for SQL Server however R requires that `\` are escaped and .NET does not. eg. ```r dbConnect("SqlServer",...

ruaridhw

Error in textConnection(message) : invalid 'text' argument

4

when i use the function:dbWriteTable to writetable into sqlserver,there is something wrong with it: 1.write the data less than 999 rows,it's ok,not the error :`Error in textConnection(message) : invalid 'text'...

datalee

@agstudy, I've tried reproducing [your example](https://stackoverflow.com/a/21914199/7312238) of NULL type handling and found two regressions: 1. After the `dbWriteTable` call, the uploaded table contains NULLs in the *value* column but **not**...

ruaridhw

Error - Potentially on conversion of fields while fetching.

6

I am assuming that it is trying to convert the fetched fields into another data-type, rather than the data type per the database. In the code below, paidAmt is of...

jfontestad

Update [benchamarking](https://github.com/agstudy/rsqlserver/wiki/benchmarking) to include: - [ ] the cran package [RSQLServer](RSQLServer). - [ ] odbc package

agstudy

Error - Potentially on NULL int fields.

1

I also have the following error: ``` Error in clrCall(sqlDataHelper, "Fetch", stride) : Type: System.ArgumentException Message: Cannot widen from source type to target type either because the source type is...

jfontestad

Error in while (!dbHasCompleted(res)) { : argument is of length zero

4

``` dbHasCompleted(res) Error in clrNew("rsqlserver.net.SqlDataHelper", res) : Type: System.InvalidOperationException Message: Invalid attempt to call FieldCount when reader is closed. Method: Int32 get_FieldCount() Stack trace: at System.Data.SqlClient.SqlDataReader.get_FieldCount() at rsqlserver.net.SqlDataHelper..ctor(SqlDataReader reader) in...

jfontestad

Use Wercker for testing?

1

I see that the [Travis-CI builds](https://travis-ci.org/agstudy/rsqlserver/builds) are failing because the .travis.yml file is missing, and I'm guessing you removed it because Travis wasn't accommodating the rClr installation is missing? If...

wibeasley

Mac OS compatibility

4

Hi! Do you have any idea whether this will work on MacOS? You mentioned a possible linux version using mono in the readme, has this been done? Otherwise, any advice...

jstray

Not really an issue perse, but your documentation suggests this is only for Windows OS, right?

4

data-steve