Hi all,
we need to use geonetwork with sql server 2005 (and integrate it in .NET app).
setup\sql\create-db-mysql.sql works as it is with sql server.
Driver is sqljdbc.jar which u cab download here:
http://msdn.microsoft.com/data/ref/jdbc/
Tested the connection, ok.
In config .xml, resource should be like:
<resource enabled="true">
<name>main-db</name>
<provider>jeeves.resources.dbms.DbmsPool</provider>
<config>
<user>user</user>
<password>passwd</password>
<driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver>
<url>jdbc:sqlserver://gisdev/geonet_test;user=user;password=passwd</url>
<poolSize>4</poolSize>
</config>
</resource>
I tried to both - do a manual post install (creating db, populating it with minimum datas), edit config.xml and
- do a server install, giving mysql as db and modyfing <driver> and <url> just before db setup.
In both cases there seems to be connection problems (in the first case I have a generic error when giving credentials or serching for data via web, in the second case I have a clean java "Error" message box after copying the driver in lib dir).
Didn't look in the jeeves.resources.dbms.Dbms, however I suppose there's a problem there (and where are the sources for the package? I didn't find them, in sourceforge jeeves site).
Could someone look into this (SQL Server 2005 Express is downloadable for free; in the sqljdbc install dir, there is docs and sample app to test connection).
Thanks
Piero
--
Il contenuto di questo messaggio e' confidenziale e la lettura non
autorizzata dello stesso viola i diritti di privacy del mittente e del
destinatario.
Se avete ricevuto questo messaggio per errore siete pregati di
rimuoverlo dal Vostro sistema.