I wrote this function for someone who needed to programmatically obtain a list of datasources and whether or not they could be verified. I’ve discussed the use of the Service Factory before, but this is another nice example, and so I thought it worth sharing.
GetDataSources() returns a query containing three columns, “name” is the datasource name, “driver” is the driver used, and “verified” returns TRUE or FALSE depending on whether or not the datasources could be verified.
A sample invocation could be:
Leave a Reply