The ODBC connection does work I use it with R all the time. Using JDBC doesn't appear to be an option with dbext but I'm not married to the idea of continuing to use JDBC. Nor can I get it to do a connection through anything else. I've tried using Vim's dbext but I can't seem to figure out how the heck it connects to a working ODBC connection. I hate switching tools, thus I'm not looking for a 'xyz' is best for Oracle but won't connect to squat else.

The ability to connect to MySQL/Postgres is desirable, especially for when I'm working on something at home where I get to choose the database system in use. My question is this - What generic/universal database front-ends/shells are people using? Connectivity to Oracle/SQL Server are an absolute must-have. And then it takes forever to reload things when I exit and come back in. It will randomly disconnect or get dropped. I like the flexibility/dependability of using JDBC (I have a very nice collection of JDC drivers and I know how to use 'em) but I'd like to find a lighter/saner tool.Įspecially with SQL Server (which is very common, unfortunately) SQuirrel is weird. I have used the SQuirrel SQL Client for the last couple of year, but it is slowly driving me batty. These are usually running either Oracle or SQL Server but I see a smattering of MySQL and I saw Postgres once (Yay!). My job requires me to regularly connect to other people's database servers.

Razorsql vs squirrel