0 Replies Latest reply: Aug 19, 2011 4:30 PM by 587949 RSS

    ODBC connection to oracle from visual studio 2010

    587949
      I created a web site with VS2010 + Oracle 10g XE and windows 7 64 bits.

      when i try an ODBC connection an "ORA-06413 - could not open connection" error occurs.

      I did this suggestion under but didn't fix it.

      ODBC problem with Data Source Administrator
      The Oracle ODBC driver is located in C:\oraclexe\app\oracle\product\10.2.0\server\BIN\sqora32.dll and is registered as a 32-bit driver. But the default ODBC Data Source Administrator only shows the 64-bit drivers that’s why you don’t see the Oracle ODBC driver in the driver list. The solution is to start the 32-bit version of the ODBC Data Source Administrator. You can find this version in the location %windir%\SysWOW64\odbcad32.exe. The default 64-bit ODBC Data Source Administrator is located in %windir%\system32\odbcad32.exe.


      What Do I need to get an ODBC connection in VS2010 + WINDOWS 7 64 BITS?

      Tks
      Luciana