5 Replies Latest reply on Jun 8, 2005 12:19 PM by Stephen Frye

    [Microsoft][SQLServer 2000 Driver for JDBC]Error establishin

    Greg Shepherd Newbie

      Hi,

      For two days I have been trying to itegrate my application (deployed to JBoss) with MS SQLSERVER 2000.

      I have completed the following steps:

      1) set properties in ms-sqlservice.xml (server/default/deploy).
      I have set the JNDI name (in every applicable place) and I have the correct Connection URL and properties.

      2) I put the 3 jars for the MS SQL SERVER 2000 DRIVER for JDBC in the appropriate /lib dir (/server/default/conf and /server/all/conf).

      3) I have updated all the standardjaws.xml and standardjbosscmp-jdbc.xml (with <type-mapping>MS SQLSERVER2000</type-mapping> and <datasource-mapping>MS SQLSERVER2000</datasource-mapping> respectively).

      I have checked my MSSQLServer for settings (The port is set to 1433 which I have specified in the ConnectionURL and TCP/IP is enabled on that port).

      I'm actually not running it over the network at this stage and just trying to get this to work on localhost.

      I keep getting the following error message:

      "uk.police.scottish.common.ejb.modelcache.ModelCacheException: Can't create a connection to the data-tier.
      nested:
      uk.police.scottish.common.util.UtilityException: Failed to get a DB connection
      nested:
      org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.); - nested throwable: (org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.))"

      I really cant think (or just dont know) what else I should be doing.

      Please help!!

      Thanks :)