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.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3949803#3949803
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3949803
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
