3 Replies Latest reply: Mar 31, 2012 6:38 PM by orafad RSS

    ODBC Problem

    920046
      Hi there,
      I am a student trying to connect Oracle XE with Visual Basic.Net.

      OS: Windows 7 Home Premium
      Bit: 64
      Oracle XE version: 11.2
      VB.Net version: Microsoft Visual Basic 2010.

      I clicked "Add new data source">"Database">"Dataset">"New Connection" in VB.Net.
      I can only see the Microsoft SQL Server enties. I cannot see the ODBC or any oracle entries.

      In "Contropanne"l>"Administritarive tools">"Data sources(ODBC)" also only Microsoft sql server entries are there in Driver Tab.

      Please help me to connect Oracle XE with VB.Net.
      Thanks in advance.
        • 1. Re: ODBC Problem
          orafad
          XE is 32-bit, so you'll find the 'Oracle in XE' driver entry via c:\Windows\SysWoW64\odbcad32.exe.
          • 2. Re: ODBC Problem
            920046
            Hello orafad,
            I has checked in "C:\Windows\SysWOW64\odbcad32.exe".
            Yes i ofcourse i can find "Oracle in XE" in Driver tab.
            But, i can't able to see the aboe entry in VB.Net. How can i access "Oracle in XE" from VB.Net.

            Anyhow thanks for your reply.
            • 3. Re: ODBC Problem
              orafad
              In the VS Wizard you described, on Choose Data Source dialog, I can see e.g. Oracle Database -> Data provider drop-down with ".NET Framework Data Provider for OLE DB" and another one "... for Oracle".

              Note that the Microsoft drivers are deprecated. For Oracle, I guess you'll need to install ODT for VS tools (from ODAC package) if not included with XE. And in that case VS need to be higher edition than Express.