# 22. Virtuoso Functions Guide - sql_config_data_sources

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

## sql_config_data_sources

Configures a remote DSN as in the DSN attribute string
vector sql_config_data_sources (in driver varchar, in type varchar, in attrib varchar);
Description

This function creates or modifies a user or system data source based on the semicolon separated list of DSN attributes.

The type argument must be either 'system' or 'user'.

Configures the data source by calling SQLWriteDSNToIni/SQLWritePrivateProfileString/SQLSetConfigMode from the ODBC Installer API.

Parameters

driver is the Driver name passed to SQLWriteDSNToIni.

Return Types

Returns the ODBC status code.

See Also

sql_data_sources, sql_columns sql_primary_keys, sql_gettypeinfo, sql_statistics, sql_tables.