Hi, For two days I have been trying to itegrate my application (deployed to JBoss) with MS SQLSERVER 2000.
I have completed the following steps: 1) set properties in ms-sqlservice.xml (server/default/deploy). I have set the JNDI name (in every applicable place) and I have the correct Connection URL and properties. 2) I put the 3 jars for the MS SQL SERVER 2000 DRIVER for JDBC in the appropriate /lib dir (/server/default/conf and /server/all/conf). 3) I have updated all the standardjaws.xml and standardjbosscmp-jdbc.xml (with <type-mapping>MS SQLSERVER2000</type-mapping> and <datasource-mapping>MS SQLSERVER2000</datasource-mapping> respectively). I have checked my MSSQLServer for settings (The port is set to 1433 which I have specified in the ConnectionURL and TCP/IP is enabled on that port). I'm actually not running it over the network at this stage and just trying to get this to work on localhost. I keep getting the following error message: "uk.police.scottish.common.ejb.modelcache.ModelCacheException: Can't create a connection to the data-tier. nested: uk.police.scottish.common.util.UtilityException: Failed to get a DB connection nested: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.); - nested throwable: (org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.))" I really cant think (or just dont know) what else I should be doing. Please help!! Thanks :) View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3856304#3856304 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3856304 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
