DBI General Network error to Microsoft SQL Server - nanodbc/nanodbc.cpp:2695

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


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

[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


Microsoft SQL Azure (RTM) - 12.0.2000.8   Feb  4 2021 02:12:36   Copyright (C) 2019 Microsoft Corporation 

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.