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