Home - Tables required - Setting up database driver and references - Code with comments
Database Driver and References
To create ODBC Driver
1) Goto Control Panel, select "ODBC Data Sources" or something similar to
that.
2) Click on "Add"
3) From the list, select Driver for Oracle, Click "Finish"
4) It'll ask for Data Source Name, User and Host.
For Name, give some name(the name you give here will be used
in the code) In my code, I've given 'ora'.
For User - give your oracle username
For Host, give your hostname (blank if using a home computer
and no host is configured)
5) Click OK! and you are done! Data Source Driver Created!
To Create "References" and to use the ADODB control.
1) In Visual Basic, Goto the menu, Projects > References
2) Select Microsoft OLE ActiveX Data Objects Library 1.0
3) Click Ok! You are done!
Note : Externally, no controls will be added in the toolbox, but the functions
will be available when you type the code as drop down tool tips.