VB- ORACLE Connectivity
Visual Basic is a front-end application that works very well with the back-end champ Oracle. I will assume that you are familiar with VB6 and Oracle 8.
In short I will give the steps of the connectivity:-
 |
Before anything else VB6 and Oracle 8 should be installed on to your machine. |
|
|
Design your form in VB. Insert the ADODC control in the form. You will get in the Components under the Project tab. |
|
|
Right Click. Go to ADODC properties. |
|
|
Click Build. Click Ms-OLEDB provider for Oracle. |
|
|
Check the Allow saving password Box. |
|
|
Click Test Connection. |
|
|
You will get a message about whether connection could be established successfully. |
|
|
Now in the Record Source box, Click 2-adcmdTable and give the necessary table name. |
|
|
Click Ok. Your job is done. |