Connecting to the Oracle Database

See Also
Quick Tour
Employee Form

After the OIP server is running, you can connect to your local or remote Oracle database. To do so, you must create the OraDatabase object as follows:

Set OraDatabase = OraSession.OpenDatabase("Exampledb", "scott/tiger", 0&)

You create an OraDatabase object using the OraSession.OpenDatabase() method. You must specify the database name, the connect string, and a bit flag word representing the database mode. The default database mode applies when you specify 0&. When Visual Basic executes this line, you have a connection to the specified database.

Contents