SQLDATASOURCES()
From Lianjapedia
Contents
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 )