Reply

Join Date: Oct 2004
Posts: 1
Reputation: SUJIT TRIPATHY is an unknown quantity at this point 
Solved Threads: 0
SUJIT TRIPATHY SUJIT TRIPATHY is offline Offline
Newbie Poster

about project

 
0
  #1
Oct 31st, 2004
What are the visual basic project with backend oracle. how the database connctivity is done with VB .
Reply With Quote Quick reply to this message  
Join Date: May 2005
Posts: 8
Reputation: C. Raghuraja is an unknown quantity at this point 
Solved Threads: 0
C. Raghuraja C. Raghuraja is offline Offline
Newbie Poster

Re: about project

 
0
  #2
May 25th, 2005
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
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC