This discussion is archived
3 Replies Latest reply: Mar 31, 2012 4:38 PM by orafad RSS

ODBC Problem

920046 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points