The dsn.exe utility serves to manage ODBC data sources. The utility
allows performing the following operations:
- creating, modifying, and removing DSN connections
- getting info on a DSN in plain-text or XML format
- listing DSN connections configured on a particular domain or on the
whole server - listing types of DSN connections supported on the server
Location
%plesk_cli%
Usage
dsn.exe <command> [<dsn name>] [
<option 1> <param> [<option 2> <param>] ... [<option N> <param>]
]
Example
The following command creates ODBC DSN connection called MSQL365 to
the MS SQL Server database located on the master-sql.sample.net
server, for the example.com domain:
plesk bin dsn.exe --create MSQL365 -type "SQL Server" -description "another test connection" -connection-string "DRIVER={SQL Server};SERVER={master-sql.sample.net};UID={db-admin};PWD={Pa$$w0rd};" -domain example.com
Commands
| Command | Parameter | Description | Example |
|---|---|---|---|
--create or -c |
<name> |
Creates DSN connection. |
To create the tst-mysql2 connection to MySQL DSN located on plesk bin dsn.exe --create tst_mysql2 -type "MySQL ODBC 3.51 Driver" -description "test mysql" -connection-string "DRIVER={MySQL ODBC 3.51 Driver};Server={mysql3.sample.net};User={admin};Password={Pa$$w0rd};Port={3307};" |
…