We are indeed planning to drop support for 32-bit R in the v1.2 release of RStudio -- sorry for the trouble.
Would it be tractable for you to port your code to use the odbc package instead, or are you relying on 3rd-party code that itself makes use of RODBC?