Connect Oracle to VB.NET
Posted on 2010-11-29
I am new to Visual Basic.NET.
I had installed Visual Studio 2010 on my machine. I have Oracle 10g as the database.
I need to connect the front end Visual Basic to Oracle.
The Login to Oracle is "Scott"
Password is "tiger"
Database is "all_employees"
I have an employee table in that Oracle database. Table name := "Employee"
The fields are "Empno", "EmpName","Job_Title", "Salary".
I need to update the salary of all the employees to 5000 whose Job_Title is "CLERK".
Could some one please send me the entire code as to how to achieve that with VB.NET and Oracle.
Do I requre to install any special Oracle ODBC drivers / dll files to connect Oracle to VB.NET?