RODBC 1.3-16 is missing

Question

I am trying to install RODBC

install.packages('RODBC')

and getting back error:

Retrieving 'https://cran.rstudio.com/src/contrib/RODBC_1.3-16.tar.gz' ...
Warning messages:
1: curl: (22) The requested URL returned error: 404 Not Found 
2: curl: (22) The requested URL returned error: 404 Not Found 

The URL above is indeed returns page not found. I really need 1.3-16 version since I am installing it on R 3.6.0.

Any work around?

Answer 1

The most updated version of the package is 1.3-17. From official CRAN documentation (link):

RODBC: ODBC Database Access An ODBC database interface.

Version: 1.3-17 Depends: R (≥ 4.0.0)

Install version 4.X.X of R and try again to install it using install.packages function.

If you want to stay on an older R version, use this approach to install previous package version:

require(devtools)
install_version("RODBC", version = "1.3-16")

> Downloading package from url:
> https://cran.rstudio.com/src/contrib/Older/RODBC_1.3-16.tar.gz
> Installing package into
> ‘C:/Users/212717174/Documents/R/win-library/3.6’ (as ‘lib’ is
> unspecified)
> * installing *source* package 'RODBC' ...
> ** package 'RODBC' successfully unpacked and MD5 sums checked
> ** using staged installation
> ** libs
> 
> *** arch - i386 c:/Rtools/mingw_32/bin/gcc  -I"C:/PROGRA~1/R/R-36~1.2/include" -DNDEBUG -I.         -O3 -Wall  -std=gnu99 -mtune=generic -c RODBC.c -o RODBC.o c:/Rtools/mingw_32/bin/gcc -shared -s -static-libgcc -o RODBC.dll
> tmp.def RODBC.o -lodbc32 -LC:/PROGRA~1/R/R-36~1.2/bin/i386 -lR
> installing to
> C:/Users/212717174/Documents/R/win-library/3.6/00LOCK-RODBC/00new/RODBC/libs/i386
> 
> *** arch - x64 c:/Rtools/mingw_64/bin/gcc  -I"C:/PROGRA~1/R/R-36~1.2/include" -DNDEBUG -I.         -O2 -Wall  -std=gnu99 -mtune=generic -c RODBC.c -o RODBC.o RODBC.c: In function 'cachenbind': RODBC.c:672:8: warning: cast to pointer from integer of
> different size [-Wint-to-pointer-cast]
>         (SQLPOINTER) (unsigned long) thisHandle->rowArraySize, 0 );
>         ^ c:/Rtools/mingw_64/bin/gcc -shared -s -static-libgcc -o RODBC.dll tmp.def RODBC.o -lodbc32 -LC:/PROGRA~1/R/R-36~1.2/bin/x64
> -lR installing to C:/Users/212717174/Documents/R/win-library/3.6/00LOCK-RODBC/00new/RODBC/libs/x64
> ** R
> ** inst
> ** byte-compile and prepare package for lazy loading
> ** help
> *** installing help indices   converting help for package 'RODBC'
>     finding HTML links ... done
>     RODBC-internal                          html  
>     RODBC-package                           html  
>     odbc                                    html  
>     odbcClose                               html  
>     odbcConnect                             html  
>     odbcDataSources                         html  
>     odbcGetInfo                             html  
>     odbcSetAutoCommit                       html  
>     setSqlTypeInfo                          html  
>     sqlColumns                              html  
>     sqlCopy                                 html  
>     sqlDrop                                 html  
>     sqlFetch                                html  
>     sqlQuery                                html  
>     sqlSave                                 html  
>     sqlTables                               html  
>     sqlTypeInfo                             html  
> ** building package indices
> ** installing vignettes
> ** testing if installed package can be loaded from temporary location
> *** arch - i386
> *** arch - x64
> ** testing if installed package can be loaded from final location
> *** arch - i386
> *** arch - x64
> ** testing if installed package keeps a record of temporary installation path
> * DONE (RODBC)

Tested on this R version:

R.version
               _                           
platform       x86_64-w64-mingw32          
arch           x86_64                      
os             mingw32                     
system         x86_64, mingw32             
status                                     
major          3                           
minor          6.2                         
year           2019                        
month          12                          
day            12                          
svn rev        77560                       
language       R                           
version.string R version 3.6.2 (2019-12-12)
nickname       Dark and Stormy Night