Visual Basic Concepts

Setting rdoConnection Options

Before you use the OpenConnection or EstablishConnection methods, you can set a number of properties and options that affect how the connection is made and how queries using these connections are processed. Generally, these options are determined by rdoEnvironment properties. However, if you create a stand-alone rdoConnection, you must preset the following rdoConnection properties with any variations from the default values before making the connection.

The following list details rdoConnection options that must be set before a connection is attempted, their default values, and what function they perform.

rdoConnection Options

rdoConnection property Default Determines
LoginTimeout 15 How many seconds to wait before abandoning the connection attempt.
CursorDriver rdUseIfNeeded Which cursor library (if any) is used for all queries associated with the rdoConnection object.
Connect "" The ODBC parameters used to make the connection — the connect string.
Name "" The DSN name to be used for the connection.