0 Replies Latest reply on Jan 5, 2006 11:03 AM by pedro costa

    portal-sqlserver-ds.xml

    pedro costa Apprentice

      This portal-sqlserver-ds.xml is right?

      The 192.168.25.23 is a remote database.

      <?xml version="1.0" encoding="UTF-8"?>
      <datasources>
       <local-tx-datasource>
       <jndi-name>MSSQLDS</jndi-name>
      
       <connection-url>jdbc:microsoft:sqlserver://192.168.25.23:1433;databaseName=bts</connection-url>
       <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
       <driver-class>com.microsoft.jdbc.base.BaseDriver</driver-class>
       <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
      
       <user-name>HFDEV</user-name>
       <password>HFDEV</password>
      
       <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
       <metadata>
       <type-mapping>MS SQLSERVER2000</type-mapping>
       </metadata>
       </local-tx-datasource>
      </datasources>
      


      Thanks,
      Pedro