The code examples included in the online help and the example applications
shipped with Oracle Objects for OLE are designed to work with a demonstration
schema (database tables and other objects) and a demonstration user/password, scott/tiger.
Demonstration Schema Creation
You can create the OO4O demonstration schema with the script demobld7.sql located in the ORACLE_BASE\ORACLE_HOME\oo4o directory. You can drop the demonstration schema with the script demodrp7.sql.
The demonstration schema includes these objects:
· EMP and DEPT, demonstration tables.
· The user scott with password tiger (scott/tiger), used for the Connect property.
If you want to use a different user/password, you must set up this user with
the database objects that have been set up for scott/tiger.
· The network alias, ExampleDb, used for the DatabaseName property.
Refer to the Oracle9i Net Services Administrator's Guide
for assistance in setting up the network service (database) alias and the tnsnames.ora file.
You can make changes to names of databases and names given to controls on a
form, but you must be consistent through out the project. For example, you can
rename the Oracle Data Control to MyDataControl, but be aware that all instances of ORADataControl must be changed to MyDataControl. You can also set up a network alias different than ExampleDb, but you must update all properties and code to reflect that change.
In many of the examples, you can access a local database using ‘‘‘‘ (a null string) for the network alias.
The ORACLE_BASE\ORACLE_HOME\oo4o directory contains the following items:
· OO4O example programs. Subdirectories contain both C++ and Visual Basic
· The oraexamp.sql script, used to create stored procedures. Additional scripts, such as multicur.sql and empcur.sql, are provided to set up other example programs.
· The Oracle Objects for OLE Global Constant file, oraconst.txt, which contains constant values such as True and False (defined as the
corresponding values in Visual Basic), and other constants used for option flags and