|
DTM OLE DB provider List is a command line tool that allows DBA, user or developer export list of installed OLE DB providers (32 or 64 bit depend on utility edition) to text file.
The file is ready to import to MS Excel.
Usage:
prov_list.exe [optional parameters]
or
prov_list_64.exe [optional parameters]
Parameters:
- -b - brief format, show provider name only
- -h or -? - how quick help
Example: prov_list
This call shows provider name and ProgID.
Q: How to save execution results to a file?
A: Use file redirect, fir example:
prov_list > providers.txt
or
prov_list_64 > providers.txt
Q: How to export the list to Excel spreadsheet?
A: Use XLS file as an output and open created file by excel:
prov_list > providers.xls
or
prov_list_64 > providers.xls
Download: 32 and 64 bit. No installation is required.
|