topic Re: Problems with SQL base connecting in ArcGIS GeoEvent Server Questions

Problems with SQL base connecting

GeorgeFrolov — Fri, 10 Feb 2012 06:21:53 GMT

Hello, I have a geoportal with Tomcat 6.0, SQL Server 2008, Arcgis Server 10.

In one theme in this topic was discussed the same problem with connecting to SQL Server. I try all things, that was suggested there, but the problem was not resolved.

Geoportal.xml is

<Context docBase="geoportal" path="/geoportal" debug="0" reloadable="true" crossContext="true">
    <Resource name="jdbc/gpt" auth="Container" type="javax.sql.DataSource"
              driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
              url="jdbc:sqlserver://ROSSTAT:1455;databaseName=geoportal"
              username="gptadmin"
              password="11111"
              maxActive="20"
              maxIdle="10"
              maxWait="-1" />
</Context>

My SQL tcp/ip parameters is
[ATTACH=CONFIG]11865[/ATTACH]
[ATTACH=CONFIG]11866[/ATTACH]

Please help me solve this problem.

Re: Problems with SQL base connecting

Anonymous User — Sun, 12 Feb 2012 23:34:39 GMT

Original User: jhaodo

Have you added the sqljdbc4.jar file to the tomcat lib folder?

Try testing the connection using ArcCatalog via Add OLE DB connection.

Re: Problems with SQL base connecting

CliveReece — Mon, 13 Feb 2012 13:28:55 GMT

Good suggestion on the jdbc driver jar file. May I also cross-reference you to this link on the Geoportal Server forum: http://sourceforge.net/projects/geoportal/forums/forum/1096644/topic/5008622