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.



      jdbc/databasee



      <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 -->
      <!--hack-->
      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper


      and


      java:/jdbc/databasee
      ...

      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?

      Thanks.