[How to] Create MS Access ODBC DSN from command line?

Created:

2016-11-16 12:56:12 UTC

Modified:

2017-08-16 17:26:32 UTC

0

Was this article helpful?


Have more questions?

Submit a request

[How to] Create MS Access ODBC DSN from command line?

Applicable to:

  • Plesk 11.x for Windows
  • Plesk 12.0 for Windows

Question

How to use dsn.exe to create MS Access ODBC DSN's correctly?

Answer

The dsn.exe utility should contain the full set of parameters. DSN can be created with the following command:

"%plesk_cli%\\dsn.exe" --create plesk_test -type "Microsoft Access Driver (*.mdb)" -domain example.com -connection-string "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\\inetpub\\vhosts\\example.com\\httpdocs\\database\\MS_Acess_DB.mdb;PAGETIMEOUT={5};MAXBUFFERSIZE={2048};READONLY={False};EXCLUSIVE={False};SAFETRANSACTIONS={0};THREADS={3};MAXSCANROWS={8};IMPLICITCOMMITSYNC={No};USERCOMMITSYNC={No}"
Have more questions? Submit a request
Please sign in to leave a comment.