I have Geoserver on Ubuntu 13.04. On another machine I have MS SQL-Server 2008 R2. Now I want to connect it together. Google says that its possible to connect to SQL-Server from Ubuntu using ODBC but Geoserver works through JDBC.

In Windows its easy, you just to need to download MS JDBC driver. But what do you do in Ubuntu?

  • down load the jar from the Microsoft site and add it to the lib directory.
    – Ian Turton
    Jul 24, 2013 at 8:16
  • @iant: What is lib directory. Im new with Linux. Now i just add jar in CLASSPATH variable in file /etc/environment. Its enough? And what i gonna do next?
    – Kliver Max
    Jul 24, 2013 at 8:18
  • that will probably work - but usually I would look in the GeoServer depoly and add it to WEB-INF/lib with the other jar files (exactly like you would on windows).
    – Ian Turton
    Jul 24, 2013 at 9:01
  • Yeah it was kind of stupid. For connect to SQL-Server gonna make a same like on Windows.
    – Kliver Max
    Jul 26, 2013 at 6:23

1 Answer 1


Simply download the MS JDBC jar from the Microsoft site and add it to WEB-INF/lib in whichever servlet container you are using to run GeoServer.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.