Connect to a data source
Informix® OLE DB Provider treats the database (rather than the database server instance) as a data source.
Data source names must be in the following format:
[database][@server]The brackets indicate that the enclosed items are optional. If the database name is missing, the client user name is used. If the @server name is missing, the default database server is used (corresponding to the value specified by the INFORMIXSERVER registry entry of the client).
To specify ADO connection string keywords, specify keywords in the connection string for the Provider by using the format keyword=value. Delimit multiple keywords with a semicolon.
The following table
describes the ADO keywords supported by the Informix OLE DB Provider.
Important: These settings take precedence over the settings
of environment variables.
| Keyword | Value | Description |
|---|---|---|
| DSN | Name of the database alias | The Informix database alias in the database directory |
| UID | User ID | The user ID used to connect to the Informix server |
| PWD | Password | The password for the user ID |
| Client_locale | Locale | The client locale for the application |
| Db_locale | Locale | The database locale for the application |
| UNICODE | True or False | Indicates whether to use Unicode. |
| RSASWS or REPORTSTRINGASWSTRING | True or False | Enables you to control the data mapping for wide strings. |
| FBS or FETCHBUFFERSIZE | Numeric | The size in bytes of the buffer size used to send data to
or from the database. The range of values is 4096 (default) to 2147483648
(2GB). If you want to set the fetch buffer size at 32 K, for example,
set the connection string as "FBS=32767" or "FETCHBUFFERSIZE=32767".
If the value of "FBS" or "FETCHBUFFERSIZE" is not in the range 4096 - 2147483648, then by default the value will be changed to 4096 internally and no error message is returned. |