So, a weird thing is happening to my colleague. We have a similar setup, but once she gets connected to one of our SQL Servers, she doesn't see our databases or tables. She sees this: [35] [16] When she runs sql queries within an Rmarkdown file, they execute fine. What could be the problem? cc…

As @edgararuiz mentioned, the encoding for your driver must match the encoding for your driver manager. For help, see the bottom of the page on troubleshooting connections : Why does my database catalog only show the first letter of each table? The character encoding in the driver manager (UnixODBC)…

Hey @taras , I believe this is either an issue with encoding, or mismatched R package versions. Can you share with me the function call used to connect to the database, and also the sessionInfo()? Thanks

FWIW I had this issue yesterday on my Mac. I could connect but I got these same weird one letter tables. Looked exactly like what @taras shows above. My situation ended up being conflicting installs of unixODBC and some interplay between the database access packages (DBI, and odbc). I had to remove…

What a time to be alive! We'd be bored out of our minds if we didn't have these struggles.

[image] taras: We'd be bored out of our minds if we didn't have these struggles. we'd probably play sports or interact with our families or something ridiculous like that...

I now suffer from the same problem and will probably have to follow JD's process to troubleshoot. Will let y'all know once I come out alive on the other side.

[image] jdlong: My situation ended up being conflicting installs of unixODBC and some interplay between the database access packages (DBI, and odbc). I had to remove one of my conflicting unixODBC installs (Homebrew in my case). Which left me with a MacPorts install of unixODBC that seemed to be…

Thank you @nathan ! It solved the problem! I missed this solution in the troubleshoot FAQ, but I'm thankful you showed it to me!

If your question's been answered (even if by you), would you mind choosing a solution? (See FAQ below for how). Having questions checked as resolved makes it a bit easier to navigate the site visually and see which threads still need help. [image] FAQ: How do I mark a solution? Gu…

Hm... I was pretty sure I did that right away!... (Both liked and marked as solution) Oh well, I guess I'm tripping. It's fixed now!

Posit Community

"Connections" pane shows weird results when connecting to a server

RStudio IDE

sql, database, odbc

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled