I did not realize you needed to use the rest of Access such as the Query designer, form designer, etc. As I'm almost certain you are aware ODBC will let you easily attach to an Access mdb. I thought you were looking for a tool simply to open and query the database. Using R as a development platform for the queries (and any stored procedures/views I need to produce) is impractical, thus my search for a better tool. Once the data is in R, I crunch it and do things with it.
#Razorsql for linux download#
Once I have a query (queries) providing the necessary info, I run these through R (using the appropriate connection RODBC, RMySQL, etc.) to actually download the data. My workflow looks like this - I develop a few queries, to access to client data I need.
I don't even mind using tools like sqsh, but I would like to find one that is flexible enough to connect to multiple databases, so I only have to become familiar with one tool.
#Razorsql for linux drivers#
This is an effective solution, in that most databases include ODBC drivers for Windows and Access can then use these connections to run queries against the foreign data set, but I would like to find a tool that doesn't require me to start a Windows VM, just to run a query. Of course, Access uses Windows' ODBC system to connect to various databases but the only way for me to (practically) use Access is to run it as a virtual machine (KVM in my case). On my current system, using Access requires me to use a VM. I assume you are referring to my earlier statement that I would prefer to not use a VM. Please note, this is being done by ODBC not VM.
#Razorsql for linux how to#
Thoughts? If you suggest dbext - any links on how to configure it? But for some reason, Vim refuses to use it. 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.
0 kommentar(er)
