StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POConnecting to MS SQL Server from R on Mac/Linux
text
Body
copied!<p>I'm trying to connect to an Microsoft SQL Server from R on Mac/Linux, and I have problems with RJDBC. When I've downloaded both Microsoft's driver and JTDS, but none of the following lines work:</p> <pre><code>library(RJDBC) drv <- JDBC("com.microsoft.sqlserver.jdbc.SQLServerDriver", "/Users/victor/Downloads/sqljdbc_3.0/enu/sqljdbc4.jar") drv1 <- JDBC('net.sourceforge.jtds.jdbc.Driver', "/Users/victor/Downloads/jtds-1/jtds-1.3.0.jar") </code></pre> <p>Each one return the following error message:</p> <pre><code>Error in .jfindClass(as.character(driverClass)[1]) : class not found </code></pre> <p>I suspect the issue may be with the wrong Java version: my default java is </p> <pre><code>$ java -version java version "1.7.0_11" Java(TM) SE Runtime Environment (build 1.7.0_11-b21) Java HotSpot(TM) 64-Bit Server VM (build 23.6-b04, mixed mode) </code></pre> <p>but I also have Jave 1.6 installed on my machine. I have SquirrelSQL installed and it connect to MS SQL Server without any problem using JTDS driver; the Java version that SquirrelSQL runs under is 1.7.0.11.</p> <p>I have run <code>R CMD javareconf</code> with the following result:</p> <pre><code>$ R CMD javareconf Java interpreter : /usr/bin/java Java version : 1.7.0_11 Java home path : /Library/Java/JavaVirtualMachines/jdk1.7.0_11.jdk/Contents/Home/jre Java compiler : /usr/bin/javac Java headers gen.: /usr/bin/javah Java archive tool: /usr/bin/jar Java library path: JNI linker flags : -framework JavaVM JNI cpp flags : -I$(JAVA_HOME)/include Updating Java configuration in /Library/Frameworks/R.framework/Resources Done. </code></pre> <p>and removed/installed again RJDBC and rJava packages, and still nothing works.</p> <p>I guess I'm stuck right now, as I'm not very familiar with Java/RJDBC and their interaction. Searching google found several people with similar problems by no solution.</p> <p>Any tips on how to make JDBC behave, or any other way to connect to MS SQL Server from R, will be highly appreciated!</p> <p><strong>UPDATE 1</strong>. Well, the first statement seems to work now - I'm getting a connection and can query the database without any problems. Not sure what fixed the problem - may be I needed to restart my mac/R session. The second statement still doesn't work, with the same error message.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload