HS_FDS_CONNECT_INFO

Default value:	none
Range of values:	not applicable

Specifies the information needed to bind to the data provider, that is, the non-Oracle system. For generic connectivity, you can bind to an ODBC-based data source or to an OLE DB-based data source. The information that you provide depends on the platform and whether the data source is ODBC or OLE DB-based.

This parameter is required if you are using generic connectivity.

ODBC-based Data Source on Windows:

You can use either a file DSN or a System DSN as follows:

• When connecting using a File DSN the parameter format is:

  HS_FDS_CONNECT_INFO=FILEDSN=file_dsn
  
  

• When connecting using a System DSN the parameter format is:

  HS_FDS_CONNECT_INFO=system_dsn
  
  

If you are connecting to the data source through the driver for that data source, then precede the DSN by the name of the driver, followed by a semi-colon (;).

ODBC-based Data Source on UNIX:

Use a DSN with the following format:

HS_FDS_CONNECT_INFO=dsn

OLE DB-based Data Source (Windows NT Only):

Use a data link (UDL) with the following formats:

• HS_FDS_CONNECT_INFO="UDLFILE=data_link"

• HS_FDS_CONNECT_INFO="provider;db[,CATALOG=catalog]"

  which allows you to specify the connection details directly, and where:

  • provider is the case-sensitive name of the provider as it appears in the registry.

  • db is the name of the database.

  • catalog is the name of the catalog.

    Note: If the parameter value includes an equal sign (=), then it must be enclosed in quotation marks.