Product:
Search Type:

[How To] Creating ODBC DSN for a MSSQL database using the command prompt

Article ID: 1327 
Last Review: Aug,03 2007
APPLIES TO:
  • Plesk 7.5.x for Windows
  • Plesk 7.6.1 for Windows
  • Plesk 8.1 for Windows
  • Plesk 8.2 for Windows

RESOLUTION

Run the following command:

odbcmng.exe --add-dsn "--connection-string=DRIVER={SQL Server};SERVER=;UID=;PWD=;DATABASE=;" --dsn-name=dsn_name_here

List of MSSQL servers can be obtained with:

odbcmng.exe --get-servers-list "--driver={SQL Server}"


 Note: This is not creation utility for DSN connections. It means odbcmng does not create DSN in Plesk. This tool is used to create DSN directly in the system.

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields