I have written an application in VB6 using ADO to an Oracle Database. I have documented each phase of the application as it was completed and am providing this documentation as a tutorial for our group. The database is based on a ficticious office supply company and consists of five tables: Customer, Orders, Item, Stock and Customer History. This application has two parts: The Oracle or back end side which encompasses the creation of the Tables, Stored Procedures and Triggers and the Visual Basic/ADO or front end side which encompasses the user interface for data entry and retrieval. The forms are very plain and simple demonstrating basic functionality of a database application. Therefore, I have broken the tutorials into these two segments as outlined below.
Please Note, however, that in order connect to an Oracle server, it is necessary to have the Oracle Client Software installed on your client machine.
So, you don't have the Oracle Client installed....Hmmm, RDS then perhaps? TIP
If I can be of assistance in any way, please feel free to contact me at any time. I would also appreciate any questions, suggestions or comments regarding any of this site's content.
THANKS AND ENJOY!!!
Maureen a/k/a "Kirby"
THE ORACLE PARTUSING SQL PLUS:
THE VB PART
USING VB 6 ADO:
COOL Related STUFF
ORACLE OVERVIEW ORACLE DATATYPES DSN-LESS CONNECTION TO ORACLE WITH ADO CONNECTING TO ORACLE WITH RDO