Command CREATE CONNECTION Professional
Create a connection and connect to a data source
CREATE CONNECTION INTO <oSession> DATASOURCE <dsn> [DATABASE <db>] [USERID <user>] [PASSWORD <pwd>] [DIALOG [PARENT <parent>]] or CREATE CONNECTION INTO <oSession> CONNSTRING <cons> [DIALOG [PARENT <parent>]]
The <oSession> is a variable that holds the connection (the session object). It can be used later to refer to the connection.
The <dsn> is the name of a DSN that should be used to establish the connection.
If the optional argument <db> is provided, the connection string will be passed the name of the database explicitly. If the DSN is not preconfigured to point to a database, this parameter should be supplied.
The argument <user> specifies the user identification for the ODBC data source.
The argument <pwd> specifies the password for the ODBC data source.
Specifies a connection string for the ODBC data source. The connection string can be used instead of explicitly including the ODBC data source, the user identification, and the password.
The ODBC driver will popup a dialog requesting information to successfully connect to the ODBC data source. If the <dsn> does not exists, or the <cons> parameter contains unknown driver names, the Connection Manager will be popped up to select a connection before. If <user> and or <pwd> are required to login, the ODBC driver will popup a login dialog to be able to connect.
The dialog to be shown will use <parent> as the parent window which affects the initial window position of this dialog and the window modality.
The command CREATE CONNECTION creates a connection to the specified ODBC data source, either by supplied a DSN and optional additional information or by specifying a valid connection string.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.