Data.DBXCommon.TDBXPropertyNames

From RAD Studio API Documentation
Jump to: navigation, search

System.TObjectTDBXPropertyNames

Delphi

TDBXPropertyNames = class

C++

class PASCALIMPLEMENTATION TDBXPropertyNames : public System::TObject

Properties

Type Visibility Source Unit Parent
class public
Data.DBXCommon.pas
Data.DBXCommon.hpp
Data.DBXCommon Data.DBXCommon

Description

Property names for connections and drivers.

Property names are used for both connections and drivers to provide information, such as user names and passwords.


The following table contains property names:

Constant Description

ConnectionName

Name of connection. If connection properties are read from the dbxconnections.ini file, this is the ini file section name. AdoDbx Client can use this property setting for a simple one property connection string. Connection names can also be used to load a connection from a TDBXConnectionFactory instance.

InstalledDrivers

dbxdrivers.ini section that specifies which drivers are enabled.

GetDriverFunc

Used by DBXDynalink drivers to specify the exported entry point for loading a driver prior to dbExpress 4.

VendorLib

Used by DBXDynalink drivers. Name of a vendor-specific client library.

ErrorResourceFile

Used only by Linux versions of dbExpress to specify a localized error message file.

LibraryName

Used by DBXDynalink drivers to specify the name of the DBXDynalink DLL.

DriverName

Unique name for a dbExpress driver. Used by the dbxconnections.ini file to refer to a connections driver in the dbxdrivers.ini file.

Host

Host name of a database server that a driver connects to.

Port

Port number of a database server that a driver connects to.

Database

Name of a database to connect to.

UserName

Login user name used to connect to a database.

Password

Login password name used to connect to a database.

Role

Login role used to connect to a database.

IsolationLevel

Initial transaction isolation to use when connecting to a database. Transaction isolation can also be specified when a transaction is started.

MaxBlobSize

Maximum BLOB size. Set to –1 to specify no limit.

DelegateConnection

Delegate connection used by this connection. Delegate connections implement the dbExpress 4 driver framework. They can perform pre- or post-processing of all public and protected methods before delegating to the real connection or another delegate connection.

DriverUnit

Used to provide an informative error message when driver cannot be loaded.

DriverPackage

Used to load a native driver dynamically.

Deprecated. Preferable to just add a comma plus the package name to the end of the DriverPackageLoader property setting.

DelegateDriver

Indicates that this driver is a delegate and can only be used in conjunction with a nondelegate driver.

DriverAssembly

Used to load a managed driver dynamically.

Deprecated. Preferable to just add a comma plus the package name to the end of the DriverPackageLoader property setting.

DriverPackageLoader

Native Driver loader class used to load a native driver dynamically from a package. Comma-separated class and package name.

DriverAssemblyLoader

Managed Driver loader class used to load a managed driver dynamically from an assembly. Comma-separated class and package name.

DelegateDriver

Indicates that this driver is a delegate and can only be used in conjunction with a nondelegate driver.

SchemaOverride

Most applications should not need to use this constant. It is provided for backwards compatibility of the dbExpress VCL. VCL components use this setting to scope metadata requests. This property should be set to user-name.override-schema-name. For example, tables created by the MSSQL sa user are placed in the dbo schema. In this case, SchemaOverride can be set to 'sa.dbo'. This causes VCL to specify the 'dbo' schema for metadata requests when a connection is made using the 'sa' user. An SQL '%' like pattern can also be used for the user-name and the override-schema-name. For example, '%.%' causes the schema not to be specified at all for all users.

MetaDataPackageLoader

Native MetaData loader class used to load a native driver dynamically from a package.

MetaDataAssemblyLoader

Managed MetaData loader class used to load a managed driver dynamically from an assembly.

ProductVersion

Can be specified as a driver property as an override of the TDBXConnection.ProductVersion property. This may be necessary for drivers that do not have the ability to report the product version. The ProductVersion is a number in the format nn.nn.nnnn.

ProductName

Provides the product name for the dbExpress metadata.

ServerConnection

When connecting to a DataSnap server, this is the name of a server method that returns an instance of a TDBXConnection. All SQL statements and SQL stored procedure commands are executed against this TDBXConnection instance. This allows client and server methods to share the same database connection. There is a built-in DSAdmin.GetConnection method that takes a single input parameter, which is the name of a connection in the server-side dbxconnections.ini file and returns a TDBXConnection instance. For example, to set the ServerConnection using this server method for a connection called "myoracleconnection", set ServerConnection: ServerConnection=DSAdmin.GetConnection("myoracleconnection"). Alternatively you can implement your own server method that returns a TDBXConnection instance.

SupportsParameterMetadata

This can be passed to the TDBXConnection.GetVendorProperty method to determine whether the driver supports parameter metadata. If parameter metadata is supported, executing the TDBXCommand.Prepare method causes the TDBXCommand parameter list to be automatically populated with parameters for the command. Note that if parameters were already added to the command, parameters are not automatically added.

ConnectTimeout

Maximum time, in seconds, to wait for a new connection to be opened. If the specified time expires, an exception is thrown. Not all drivers support this operation.

BufferKBSize

Buffer size in kilobytes to use for client driver transport read and write operations. Currently used by DBXClient.

AutoUnloadDriver

If True, dynalink drivers will automatically unload their dll when there are no open connections left that use the driver.

CommunicationProtocol

Specifies the communication protocol.

URLPath

Specifies the path to a DataSnap server web application. For example, you can use URLPath to specify the virtual directory of a DataSnap server ISAPI dll.

DSAuthenticationUser

Specifies the user name that is recognized by the DataSnap server. This is a different concept than a database user that is used for creating a database connection.

DSAuthenticationPassword

Specifies a password required for a DataSnap user to authenticate with the server.

CommunicationTimeout

Specifies the maximum time to wait for a data packet to be exchanged. When the specified time expires, an exception is thrown. Not all drivers support this operation.

Filters

Specifies a key for filters' configuration.

DatasnapContext

Specifies a key for a URL path toward DataSnap HTTP service.


See Also