Connection error

  • bawcior

    bawcior - 2012-04-10

    I have a very weird problem. I can run SQL Explorer just fine as a standalone application and it connects to Oracle database using the ODBC driver just fine. However, when I try to run it from Eclipse (v. 3.6.1) with the same conenction string, I get the following error message: Cannot connect to … Check your URL  The specified DSN contains an architecture mismatch between the Driver and Application.
    Any ideas why this would be happening? The only thing I can think of is that I'm on 64bit system and I have the 32 bit drivers installed for Oracle with ODBC set up for 32bit driver and somehow maybe eclipse is trying to use 64-bit version? It's just a wild guess, maybe I'm missing something. Thanks

  • Heiko Hilbert

    Heiko Hilbert - 2012-04-11

    Yes, this seems to be a 32/64 Bit problem. If you are using the SE standalone version with Java it is started using the 32-Bit java vm in your sqlexplorer directory. Your eclipee is normaly started using your default java vm which seems to be 64 Bit.
    You can use the -vm command line argument to start eclipse with the vm bundled with the SE standalone version.

    -vm <path to java vm> (Executable, Main)
        when passed to the Eclipse executable, this option is used to locate the Java VM to use to run Eclipse. It should be the full file system path to an appropriate: Java jre/bin directory, Java Executable, Java shared library (jvm.dll or, or a Java VM Execution Environment description file.  If not specified, the Eclipse executable uses a search algorithm to locate a suitable VM. In any event, the executable then passes the path to the actual VM used to Java Main using the -vm argument. Java Main then stores this value in eclipse.vm.


Log in to post a comment.