Name
vd_remote_data_source — prepares a remote DSN for use
Synopsis
vd_remote_data_source
(
|
in dsn varchar , |
| in connstr varchar , | |
| in user varchar , | |
in
password
varchar
); |
Description
A remote data source is uniquely identified by its DSN, the dsn argument to this function. The connstr argument is presently ignored. The user and password are the login name and password to use when communicating with the remote data source. All Virtuoso users dealing with the remote data source will appear as this user to the remote data source. Virtuoso will make as many connections as there are concurrent users of the data source. Connections are cached by Virtuoso.
The default qualifier of the user of the remote data source is usually not relevant. This function connects to the DSN in order to retrieve various meta data, which it stores locally. The DSN should be defined in the server's environment and the DSN's database should be on line.
Parameters
dsn
The name of the remote datasource to prepare.
connstr
Currently ignored parameter.
user
username for the connection.
password
password for the user.
Return Types
Status of the connection attempt.
Errors
Table 24.112. Errors signalled by
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|