SQLDATASOURCES()
From Lianjapedia
Revision as of 07:53, 4 March 2019 by Yvonne.milne (Talk | contribs)
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 )