|
DTM ODBC Data Source List is a command line tool that allows DBA, user or developer export list of ODBC data sources to text file.
The file is ready to import to MS Excel.
Download: 32 bit. No installation is required.
Usage:
dsn_list.exe [optional parameters]
Parameters:
- -b - brief format, show driver name only
- -h or -? - how quick help
- -s - show system DSN only (both by default)
- -u - show user DSN only (both by default)
Example: dsn_list -u
This call shows user DSN list
Q: How to save execution results to a file?
A: Use file redirect, fir example: dsn_list > dsn.txt
Q: How to export the list to Excel spreadsheet?
A: Use XLS file as an output and open created file by excel: dsn_list -s > dsn.xls
|