Installing jdbc driver to access MS SQL 2005

1 message Options
Embed this post
Permalink
Manolo Frias

Installing jdbc driver to access MS SQL 2005

Reply Threaded More More options
Print post
Permalink
Hello,

I am testing whether geonetwork fits into our organization. We are working with ESRI products. All our metadata is stored as xml in MS SQL Server 2005.

The first thing I came across is about the installation. If I understood right I need to install a jdbc driver to access our MS SQL Server. Where can I find detailed instructions to do that?

So far I have downloaded the driver and copied sqljdbc4.jar into this directory:

C:\Program Files\geonetwork\web\geonetwork\WEB-INF\lib

Then in GAST:

JDBC Driver: sqljdbc4.jar
URL: jdbc:sqlserver://myserver\mydbname
Username: myusername
Password: mypassword

Am I in the right path? Should I also go to control panel / ODBC Data Source Administrator and add the driver from there?

Thank you!
Manolo