WELCOME TO KIRBY'S WEB SITE


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.

LET'S PUT THE DEVELOPER BACK IN DEVELOPER SUPPORT!!

THANKS AND ENJOY!!!
Maureen a/k/a "Kirby"
E-MAIL ME



THE ORACLE PART

USING SQL PLUS:

  • CREATING ORACLE TABLES
  • CREATING AN AUTO-INCREMENTING COUNTER
  • CREATING ORACLE TRIGGERS
  • CREATING ORACLE STORED PROCEDURES:
    ADDING NEW RECORDS
    DELETING RECORDS
    EDITING RECORDS
    USING INPUT/OUTPUT PARAMETERS

  • THE VB PART

    USING VB 6 ADO:

  • CONNECTING TO ORACLE
  • CLOSING & EXITING
  • ADDING NEW RECORDS
  • DELETING RECORDS
  • EDITING RECORDS
  • USING INPUT/OUTPUT PARAMETERS
  • VB CONTROLS USED IN THE PROJECT:
    USING THE LISTVIEW CONTROL

  • COOL Related STUFF

  • WANT THE LATEST MICROSOFT ODBC DRIVER FOR ORACLE?
    You Can Download it from the Microsoft Data Access Components (M.D.A.C.) Site
  • OLEDB Providers
  • GREAT SITE FOR TIPS, TRICKS AND TROUBLESHOOTING
    Of particular note are the links to Ari Kaplan's Oracle Tips and Bob Jenkin's Oracle SQL Tricks

  • ORACLE BROWN BAG TRAINING

  • ORACLE OVERVIEW
  • ORACLE DATATYPES
  • DSN-LESS CONNECTION TO ORACLE WITH ADO
  • CONNECTING TO ORACLE WITH RDO

  • OTHER STUFF

  • FOOTBALL: New England Patriots


  • graphic by
Jay Tyler
    This site is a member of the VB Team Web Ring
    [ Previous | Next | Random Site ]