ODBC does not show tables when I connect in R Studio

[grislepak]

I have the similar problem making ODBC connection within R-Studio

ODBC connection is showing "(No Tables)" when I connect in R Studio.

Hello -- I'm having some trouble making an ODBC connection to my data sources within R Studio. install.packages("odbc") install.packages("DBI") library(odbc) library(DBI) con <- dbConnect(odbc::odbc(), myDSN, uid = myUID, pwd = myPWD) In the "Connections" tab, it shows that I'm connected to the DSN. When I drill into the connection it shows"(No Tables)". Similarly, when I try: dbListTables(con) character(0) I tried the same code within R and could see all of my tables as I would expect to see them using dbListTables(con). I tried other ways to connect to this data source and they are all working. I'm running R version 4.1.2 and R Studio version 2021.09.2+382. Thanks very much …

library(DBI)
library(odbc)
Con <- dbConnect(odbc::odbc(), "******", uid = "****", PWD = "*****")

The code work perfect on the old computer (Windows 10, R-Studio version 4.1.3) but on the new machine with Windows 11 and R-Studio version 4.2.2 it don't show any tables in the connected database.

Tried to add encoding parameter. No result.

All odbc settings are the same. I found out only one difference.
The new R-Studio has the following

> str(l10n_info())
List of 5
 $ MBCS           : logi TRUE
 $ UTF-8          : logi TRUE
 $ Latin-1        : logi FALSE
 $ codepage       : int 65001
 $ system.codepage: int 65001

but the old shows the following

> str(l10n_info())
List of 5
 $ MBCS           : logi FALSE
 $ UTF-8          : logi FALSE
 $ Latin-1        : logi TRUE
 $ codepage       : int 1252
 $ system.codepage: int 1252