1 Reply Latest reply on Jun 8, 2006 11:32 AM by fabio di biase

    JNDI Problems with sql server 2000

    fabio di biase Newbie

      Hi to everyone,
      i'm trying to connect to sql server 2000 db via jndi, the data source file is this:


      <local-tx-datasource>
      <jndi-name>sqlDSAuth</jndi-name>
      <connection- url>jdbc:microsoft:sqlserver://DOMWC02:1433;SelectMethod=cursor;DatabaseName=josso</connection-url>
      <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
      <user-name>sa</user-name>
      sa
      <!-- sql to call when connection is created
      <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->

      <!-- sql to call on an existing pooled connection when it is obtained from pool
      <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->

      </local-tx-datasource>



      I'm using this driver:

      msutil;
      msbase;
      mssqlserver;

      the error then i've recive at the connection from jboss log is:

      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.)

      Who's the problem?

      Thanxs in advance,
      Fabio.