I am a student trying to connect Oracle XE with Visual Basic.Net.
OS: Windows 7 Home Premium
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.
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.
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.