ODBC.ConfigDataSource

ODBC.ConfigDataSource ( 

string DriverDescription,

string Attributes,

number Request )

Description

Configures an ODBC data source.

Parameters

DriverDescription

(string) A description of the driver, for example "Microsoft Access Driver (*.mdb)".

Attributes

(string) A string of attributes in 'keyword = value' pairs. Each attribute is separated by "\\0".

For example:   "DSN=QandA\\0DBQ=J:\\DATABASE\\QandA.mdb\\0FIL=MS Access;\\0DESCRIPTION=Questions and Answers Database\\0DRIVERID=25\\0UID=\\0\\0"

Request

(number) The type of action that will be performed. Choose from:

CONSTANT

VALUE

DESCRIPTION

ODBC_ADD_DSN

1

Add a new user data source.

ODBC_CONFIG_DSN

2

Configure (modify) an existing user data source.

ODBC_REMOVE_DSN

3

Remove an existing user data source.

ODBC_ADD_SYS_DSN

4

Add a new system data source.

ODBC_CONFIG_SYS_DSN

5

Modify an existing system data source.

ODBC_REMOVE_SYS_DSN

6

Remove an existing system data source.

ODBC_REMOVE_DEFAULT_DSN

7

Remove the default data source specification section from the system information.

Returns

Nothing. You can use Application.GetLastError to determine whether this action failed, and why.

See also:  Related Actions