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 '13 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 '13 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 '13 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 '13 at 6:23

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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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