|Oracle® Objects for OLE Developer's Guide
11g Release 2 (11.2) for Microsoft Windows
Part Number E12245-01
Returns the user name of the connection string associated with the connection. Not available at design time and read-only at run time.
connect_string = oraconnection.Connect connect_string = oradatabase.Connect
Returns the user name of the connection string associated with the connection.
Returns the user name of the connection string associated with the specified database. It is equivalent to referencing
The password associated with the user name is never returned.
This example demonstrates the use of the
DatabaseName properties to display the user name and database name to which the user is connected. Copy and paste this code into the definition section of a form. Then, press F5.
Sub Form_Load () 'Declare variables Dim OraSession As OraSession Dim OraDatabase As OraDatabase Dim OraDynaset As OraDynaset 'Create the OraSession Object. Set OraSession = CreateObject("OracleInProcServer.XOraSession") 'Create the OraDatabase Object by opening a connection to Oracle. Set OraDatabase = OraSession.OpenDatabase("ExampleDb", "scott/tiger", 0&) 'Display the username and database to which we are connected. MsgBox "Connected to " & OraDatabase.Connect & "@" & OraDatabase.DatabaseName End Sub