0 Replies Latest reply on Nov 26, 2002 6:44 PM by Jaime Cano

    setting datasource for Microsoft SQLServer

    Jaime Cano Newbie

      We are trying to set up a datasource for sql server using the Microsoft driver. So far we have configured the mssql-service.xml.
      That came in docs\examples\jca.

      We also configured standardjaws.xml.


      <config-property name="ConnectionURL" type="java.lang.String">jdbc:microsoft:sqlserver://sqlserver:1433;databaseName=databaseemployees</config-property>
      <config-property name="DriverClass" type="java.lang.String">com.microsoft.jdbc.sqlserver.SQLServerDriver</config-property>
      <!--set these only if you want only default logins, not through JAAS-->
      <config-property name="UserName" type="java.lang.String">xyz123</config-property>
      <config-property name="Password" type="java.lang.String">xyz123</config-property>

      <!--Below here are advanced properties -->
      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper



      But, I got the following error when the code lookup for the Datasouce:

      18:45:48,640 ERROR [STDERR] [27/11/2002-18:45:48] No se encontro recurso: jdbc/databasee en el JNDI: javax.naming.NameNotFoundException: jdbc not bound, Fallo escritura en el Log

      Help me out what else i need to do to set up the datasource?