SQLDATASOURCES()

From Lianjapedia
Jump to: navigation, search

Purpose

Function to return a comma separated list of the 32-bit ODBC System DSNs

Syntax

SQLDATASOURCES()

See Also

SQLCANCEL(), SQLCOLUMNS(), SQLCOMMIT(), SQLCONNECT(), SQLDISCONNECT(), SQLDRIVERS(), SQLERROR(), SQLEXEC(), SQLGETPROP(), SQLMORERESULTS(), SQLPREPARE(), SQLROLLBACK(), SQLSETPROP(), SQLSTRINGCONNECT(), SQLTABLES(), SQLTRANSACTION()

Description

The SQLDATASOURCES() function is used to return a comma separated list of the 32-bit ODBC System DSNs on the current machine.

Example

astore(aDSNs,sqlDataSources(),",")
? aDSNs
Array (refcnt=1)
(
    [1] = Excel Files
    [2] = MS Access Database
    [3] = dBASE Files
    [4] = lianja_mssqltest
    [5] = Lianja_Southwind
    [6] = lianja_mysqltest
)