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

Refers to:

  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows

Created:

2016-11-16 12:56:12 UTC

Modified:

2016-12-21 19:34:43 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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

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.