Member Avatar for SUJIT TRIPATHY

What are the visual basic project with backend oracle. how the database connctivity is done with VB .

  • 2 Contributors
  • 1 Reply
  • 101 Views
  • 6 Months Discussion Span
  • Latest Post Latest Post by C. Raghuraja
Member Avatar for C. Raghuraja

Easy Way to Connect Oracle from VB

Install Oracle Client on your system

'Connection Object for Oracle Database connection
Dim con As ADODB.Connection

'Recordset Object for Oracle Tables

Dim rst As New ADODB.Recordset

con.Open "Provider=MSDAORA;Data Source=OracleDataBase;User ID=OracleUserID; Password=OraclePassword;

rst.Open "Select * From OracleTableName"

Do While Not rst.EOF

'Do the Processing here Display etc

Msgbox rst("No")
Msgbox rst("Name")

rst.MoveNext

Loop

rst.close
con.close

set rst = Nothing
Set con = Nothing

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.