1 Reply Latest reply on Jul 17, 2008 3:05 PM by Peter Johnson

    How to set up jboss to use windows odbc connection

    Ranieri Mazili Newbie

      Hello,

      I'm trying to do jboss use a windows odbc connection, but I haven't success.
      I've created a new odbc connection at Start->Settings->Control Panel-> Administrative Tools->Datasources (ODBC) called myODBCCon.
      It's returning sucess when I test this connection clicking on Test Connection Button.

      So... I've created odbc-ds.xml file at my project deploy directory:


      <local-tx-datasource>
      <jndi-name>myJNDIODBC</jndi-name>
      <connection-url>jdbc:odbc:myODBCCon</connection-url>
      <driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class>
      <user-name>myUser</user-name>
      myPassword
      <use-java-context>false</use-java-context>
      </local-tx-datasource>


      I don't have the error right now, but my question is about driver-class...
      Do I need to put something in the classpath to do sun.jdbc.odbc.JdbcOdbcDriver works properly?
      Am I forgetting some details in my odbc-ds.xml file?

      Thank you

      P.S: There's no possibility to use a jdbc driver right now, I really need to use a windows ODBC connection, please, don't ask about my reasons to use an ODBC connection.