I have this working now. Looks like l started with an older version of mssql-service.xml which l hacked with information l found on the jboss forums. Ive restarted with a newer version of the file which of course behaves correctly. Thanks.
>-----Original Message----- >From: Jamie Burns [mailto:[EMAIL PROTECTED]] >Sent: Friday, July 05, 2002 12:03 PM >To: [EMAIL PROTECTED] >Subject: [JBoss-user] Setting up an MSSQL datasource on JBoss3 > > >Setting up an MSSQL datasource on JBoss3Hi. > >I have run into a brick wall trying to setup MS SQLSever 2000 as my DB >for >JBoss3.0. I cant see what l am missing and am looking for help from >people >who have MS SQLServer 2000 working with JBoss 3.0. > >I have JBoss 3.0 and MS SQLServer 2000 running on my workstation. Im >running >Java 1.3.0_02. > >Where should the Microsoft SQLServer JDBC jars (mssqlserver.jar, >msutil.jar >and msbase.jar) go? (There seem to be various options. JBOSS_HOME\lib, >JBOSS_HOME\lib\ext, JBOSS_HOME\server\all\lib. I have been working on >JBOSS_HOME\server\all\lib since the hsql jars seem to be there.) > >I have no problems setting up ths hssql server so I have been comparing >hsqldb-service.xml with mssql-service.xml. > >(Note: I do not have both files in the JBOSS_HOME\server\all\deploy >directory - its either hsqldb-service.xml or mssql-service.xml. When l >start >JBoss (run -c all) with hsqldb-service.xml l have a DefaultDS entry in >the >JNDI java: namespace. When l start JBoss with mssql-service.xml l do not >have a DefaultDS entry.) > >Here is my mssql-service.xml file (without the comments) _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Two, two, TWO treats in one. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user