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.
Hi to everyone,
i'm solved the problem installing sql server 2000 SP3
Thanxs,
best regards,
Fabio.