# 22. Virtuoso Functions Guide - vd_remote_data_source

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
att_local_name
quote_dotted
rclose
rexecute
rmoreresults
rnext
rstmtexec
sql_columns
sql_config_data_sour...
sql_data_sources
sql_driver_connect
sql_get_installed_dr...
sql_get_private_prof...
sql_gettypeinfo
sql_primary_keys
sql_procedures
sql_remove_dsn_from_...
sql_special_columns
sql_statistics
sql_tables
sql_transact
sql_write_file_dsn
sql_write_private_pr...
vd_remote_data_sourc...
vd_remote_proc_wrapp...
vd_remote_table
vd_statistics
vdd_disconnect_data_...
vdd_measure_rpc_time
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## vd_remote_data_source

prepares a remote DSN for use
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

SQLState | Error Code | Error Text | Description
--- | --- | --- | ---

See Also

vd_remote_table

vdd_disconnect_data_source

Manually Setting Up A Remote Data Source