Morning All,
i trying to connect to connect to a Microsoft SQL Server with DBI package.
The table have 17million rows.
I receive the error:
Error in result_fetch(res@ptr, n) :
nanodbc/nanodbc.cpp:2695: HY018: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()). [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.
Warning message:
In dbClearResult(rs) : Result already cleared
i test
- connection and it's ok
- i saw the table also with Rstudio connection interface
- i read a small sample and took in R in a data.frame or tibble
but i can read all rows, when i try to take more than 100k rows i receive the error above
Can anyone help me or give me some advice?
thanks in advance
have a nice day
MC
R INFO
R version 4.0.4 (2021-02-15)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 19041)
Matrix products: default
locale:
[1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United States.1252 LC_MONETARY=English_United States.1252
[4] LC_NUMERIC=C LC_TIME=English_United States.1252
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] dbplyr_2.1.0 tictoc_1.0 forcats_0.5.1 stringr_1.4.0 dplyr_1.0.5 purrr_0.3.4 readr_1.4.0 tidyr_1.1.3
[9] tibble_3.1.0 ggplot2_3.3.3 tidyverse_1.3.0 DBI_1.1.1
loaded via a namespace (and not attached):
[1] Rcpp_1.0.6 cellranger_1.1.0 pillar_1.5.1 compiler_4.0.4 tools_4.0.4 odbc_1.3.1 bit_4.0.4 lubridate_1.7.10
[9] jsonlite_1.7.2 lifecycle_1.0.0 gtable_0.3.0 pkgconfig_2.0.3 rlang_0.4.10 reprex_1.0.0 cli_2.3.1 rstudioapi_0.13
[17] haven_2.3.1 withr_2.4.1 xml2_1.3.2 httr_1.4.2 fs_1.5.0 generics_0.1.0 vctrs_0.3.6 hms_1.0.0
[25] bit64_4.0.5 grid_4.0.4 tidyselect_1.1.0 glue_1.4.2 R6_2.5.0 fansi_0.4.2 readxl_1.3.1 modelr_0.1.8
[33] blob_1.2.1 magrittr_2.0.1 backports_1.2.1 scales_1.1.1 ellipsis_0.3.1 rvest_1.0.0 assertthat_0.2.1 colorspace_2.0-0
[41] utf8_1.2.1 stringi_1.5.3 munsell_0.5.0 broom_0.7.5 crayon_1.4.1
MSSQL SERVER INFO
Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 4 2021 02:12:36 Copyright (C) 2019 Microsoft Corporation