Can I use Remote Data control to connect VB to Oracle which is existing on my own system? If yes, how?
remote data contol
Collapse
X
-
1.create a DSN to connect tot he desired database.
2.add a RDO control to the form
3.select the datasourcename property and set to the dsn specified in step1.
4.write the sql query in the sql property of the control.
5.add textbox set the Datasource property tot he control.
6.set the datafield propety to the desired field.
7.run the form and move throught he recordset using the control.
Comment