oracle.odi.runtime.agent.invocation.InvocationException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Oracle Community | 1642743 | 2 years ago
  1. 0

    Critical/Hih Prioriity:How to make agent specfic technology connections

    Oracle Community | 5 years ago | 899628
    oracle.odi.runtime.agent.invocation.InvocationException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
  2. 0

    How to Connect to MS excel data source in ODI 11g ?

    Oracle Community | 2 years ago | 1642743
    oracle.odi.runtime.agent.invocation.InvocationException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
  3. 0

    Problem Accesing remote file while running through Agent.

    Oracle Community | 5 years ago | MaheshGx
    oracle.odi.runtime.agent.invocation.InvocationException: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write its data.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ODI11G:Network MSaccessfile throgh DSN executing Locally but not with Agent

    Oracle Community | 5 years ago | 902868
    oracle.odi.runtime.agent.invocation.InvocationException: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write its data.
  6. 0

    connecting problem for msserver2005 - Data Integrator

    developer-works.com | 1 year ago
    oracle.odi.runtime.agent.invocation.InvocationException: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.microsoft.sqlserver.jdbc.SQLServerDriver]

    4 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.odi.runtime.agent.invocation.InvocationException

      [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

      at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke()
    2. oracle.odi.runtime
      RemoteRuntimeAgentInvoker.invokeTestDataServer
      1. oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:279)
      2. oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:653)
      2 frames
    3. com.sunopsis.graphical
      SnpsDialogTestConnet$IvjEventHandler.actionPerformed
      1. com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:847)
      2. com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteConnect(SnpsDialogTestConnet.java:820)
      3. com.sunopsis.graphical.dialog.SnpsDialogTestConnet.jButtonTest_ActionPerformed(SnpsDialogTestConnet.java:758)
      4. com.sunopsis.graphical.dialog.SnpsDialogTestConnet.connEtoC1(SnpsDialogTestConnet.java:137)
      5. com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$1(SnpsDialogTestConnet.java:133)
      6. com.sunopsis.graphical.dialog.SnpsDialogTestConnet$IvjEventHandler.actionPerformed(SnpsDialogTestConnet.java:87)
      6 frames
    4. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      2. javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
      6. java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
      7. java.awt.Component.processMouseEvent(Component.java:6267)
      8. javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      9. java.awt.Component.processEvent(Component.java:6032)
      10. java.awt.Container.processEvent(Container.java:2041)
      11. java.awt.Component.dispatchEventImpl(Component.java:4630)
      12. java.awt.Container.dispatchEventImpl(Container.java:2099)
      13. java.awt.Component.dispatchEvent(Component.java:4460)
      14. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
      15. java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
      16. java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
      17. java.awt.Container.dispatchEventImpl(Container.java:2085)
      18. java.awt.Window.dispatchEventImpl(Window.java:2478)
      19. java.awt.Component.dispatchEvent(Component.java:4460)
      20. java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
      21. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      22. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      23. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
      24. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
      25. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
      26. java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
      26 frames