RDO Topics
<<Back
Next>>

rdoConnection

Generally, an rdoConnection object represents a physical connection to the remote data source and corresponds to a single ODBC hDbc handle. A connection to a remote data source is required before you can access its data. You can open connections to remote ODBC data sources and create rdoConnection object with either the RemoteData control or the OpenConnection method of an rdoEnvironment object.


RDO Connection Object Properties
Property Description
AsyncCheckInterval Returns or sets a value that specifies the number of milliseconds that RDO waits between checks to see wether an asychronous query is complete.
Connect Returns or sets a value that provides information about the source of an open rdoConnection. The Connect property contains the ODBC connect string. This property is always readable but it can't be changed after the connection is established.
CursorDriver Returns or sets a value that specifies the type of cursor to create. If set to rdUseIfNeeded, the ODBC driver chooses the appropriate type of cursors. Server-side cursors are used if they are available. If set to rdUseODBC, RemoteData uses the ODBC cursor library. If set to rdUseServer, server-side cursors are used. If set to rdUseClientBatch, RDO uses the optimistic batch cursor library.
hDbc Returns a value corresponding to the ODBC connection handle.
LoginTimeout Returns or sets a value that specifies the number of seconds the ODBC driver waits before a timeout error occurs when a connection is opened.
LogMessages Enables ODBC trace logging and returns or sets a value that indicates the path of the ODBC trace file, created by the ODBC driver manager to record all ODBC operations.
Name Returns the name of RemoteData object.
QueryTimeout Returns or sets a value that specifies the number of seconds the ODBC driver manager waits before a timeout error occurs when query is executed.
LastQueryResults Returns a reference to the rdoResultset object generated by the last query, if any.
UpdateOperation Returns or sets a value that specifies whether the optimistic batch update should use an Update statement or a Delete followed by an Insert. If set to rdOperationsUpdate, an Update statement is used for each modified row. If set to rdOperationDelIns, a pair of Delete and Insert statements is used for each modified row.
RowsAffected Returns the number of rows affected by the most recently envoked Execute() method.
StillExecuting Returns a Boolean value that indicates whether a query is still executing.
Transactions Returns a value that indicates whether an object supports the recording of a series of changes that can later be rolled back (undone) or committed (saved).
Version Returns a value that indicates the version of the data source associated with the object.
StillConnecting Returns a value that indicates if the connection has been established.



rdoConnection Object Methods
Method Description
BeginTrans() Begins a new transaction.
CommitTrans() Ends the current transaction and saves the changes.
RollbackTrans() Rollback() ends the current transaction and restore the databases in the Workspace object to the state they were in when the current transaction began.
Close() Closes an open remote data object.
OpenConnection() Opens a Connection to an ODBC data source and returns a reference to the rdoConnection object that represents a specific database.
Add() Adds a member to a Collection object.
Remove() Removes a member from a Collection object.



rdoEngine

The rdoEngine object can represent a remote database engine or another data source managed by to ODBC Driver Manager as a database. The rdoEngine object is a predefined object; therefore, you can't create additional rdoEngine objects, and it isn't a member of any collection.


rdoEngine Object Properties
Property Description
AbsolutePosition Returns or sets the absolute row number of an rdoResultset object's current row
rdoDefaultCursorDriver Returns or sets the cursor library used by the ODBC driver manager
rdoDefaultUser Returns or sets the default username assigned to the new rdoEnvironment
rdoDefaultPassword Returns or sets the default password assigned to the new rdoEnvironment
rdoDefaultErrorThreshold Returns or sets a value that indicates the default value of the ErrorThreshold property for the rdoQuery objects
rdoDefaultLoginTimeout Returns or sets a default value that determines the number of seconds the ODBC driver waits before abondoning an attempt to connect to a data source
rdoEnvironments Retrieves the collection of environments that rdoEngine object has created
rdoLocaleID Returns or sets a value that indicates a locale of RDO library; if set to rdoLocalSystem, the system locale is used
rdoVersion Returns a value that indicates the version of the RDO library that is associated with the object



RDO Object Methods
Methods Descriptionn
rdoCreateEnvironment() Creates a new rdoEnvironment object. This method has the following syntax:
rdoRegisterDataSource() Enters connection for an ODBC data source into the Windows Registry.





<<Back
top
Next>>





Copyright� 2000 by Noel