1 Reply Latest reply on Jun 8, 2006 11:32 AM by fabdib

    JNDI Problems with sql server 2000

      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.