1 Reply Latest reply on Oct 18, 2002 1:55 AM by shivva

    Could not connect to SQL 7

    osama

      Hi all,

      I am trying to connect to Microsoft SQL 7 from Jboss 2.4.7 and I always get the following error:
      [13:50:24,598,XAConnectionFactory] Can't get an XAConnection
      java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

      Everything is working fine on Jboss 2.4.4 but it does not work on 2.4.7, the configuration that I put in the jboss.jcml is like the following:

      sun.jdbc.odbc.JdbcOdbcDriver



      TOTO
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

      jdbc:odbc:ODBCNAME
      1200000
      sa
      255
      password
      false
      true
      false
      true
      120000
      1800000
      false
      True
      1.0
      1


      Could anyone please help me solving this bug?

      Thanks,