Connection string keywords that make a connection
Use connection string keywords to make a connection with or without DSN and with the DRIVER keywords.
The following table lists the connection string keywords
that can be used in making a connection:
| Keyword | Short version |
|---|---|
| CLIENT_LOCALE | CLOC |
| CONNECTDATABASE | CONDB |
| CURSORBEHAVIOR | CURB |
| DATABASE | DB |
| DB_LOCALE | DLOC |
| DESCRIBEDECIMALFLOATPOINT | DDFP |
| DESCRIPTION | DESC |
| DONOTUSELVARCHAR | DNL |
| DRIVER | DRIVER |
| DSN | DSN |
| ENABLEINSERTCURSORS | ICUR |
| ENABLESCROLLABLECURSORS | SCUR |
| EXCLUSIVE | XCL |
| FETCHBUFFERSIZE | FBC |
| FILEDSN | FILEDSN |
| HOST | HOST |
| NEEDODBCTYPESONLY | ODTYP |
| OPTIMIZEAUTOCOMMIT | OAC |
| OPTIONS | OPT |
| OPTOFC | OPTOFC |
| PWD | PWD |
| REPORTCHARCOLASWIDECHARCOL | RCWC |
| REPORTKEYSETCURSORS | RKC |
| SAVEFILE | SAVEFILE |
| SERVER | SRVR |
| SERVICE | SERV |
| SINGLETHREADED | SINGLETH |
| SKIPPARSING | SKIPP |
| TRANSLATIONDLL | TDLL |
| TRANSLATIONOPTION | TOPT |
| UID | UID |
| UPDATE_DESCRIBE | UPDDESC |