Lucity Create DSN Utility

Jonathan Semones -

create_dsn.png

The Lucity.CreateDSN.exe is a tool designed to help users and administrators quickly fix connection problems between Lucity Desktop and Lucity Server.  This  tool was released with version 7.30.

 When to use this tool

  • When having issues getting into Lucity Desktop
  • After moving the Lucity Server
  • After moving the Lucity Databases to a new location
  • When trying to point Lucity Desktop to a different instance of Lucity Server
  • All of these functions apply to the Lucity Mobile Desktop too

 

Note: This program must be run on every machine that needs to be updated after a Server or Database change.  This can either be done manually on each computer, OR the program can be run silently as part of a script.  For more information about running this silently read the Advanced Functions section.

What it does

  • Lucity Desktop – When given the path to the Lucity Server Config folder
    • Updates Lucity Desktop’s LucityPtr.ini file on the local machine to point to the Lucity Server location.
    • Updates the Lucity Desktop registry settings on the local machine to point to the Lucity Server location.
    • Updates the Lucity DSNs on the local machine to match the Lucity Server configuration.
  • Lucity Mobile Desktop – When given the path to the Lucity Server Config folder
    • Updates Lucity Mobile Desktop’s LucityPtrSrvr.ini file on the local machine to point to the Lucity Server location.
    • Updates the Lucity Mobile Desktop registry settings on the local machine to point to the Lucity Server location.
    • Updates the Lucity DSNs on the local machine to match the Lucity Server configuration.
  • Lucity Mobile Desktop – When given the path to the local field Config folder
    • Updates Lucity Mobile Desktop’s LucityPtr.ini file on the local machine to point to the local config location.
    • Updates the Lucity Mobile Desktop registry settings on the local machine to point to the local config location.
    • Updates the Lucity Field DSNs on the local machine to match the location of the local Field Databases.

Finding this tool

  • This tool is automatically included in every install of Lucity Desktop.
  • You can access it through the Windows Start Menu by going to All Programs > Lucity > Utilities > Lucity DSN Utility.
  • The actual exe is stored in the \bin folder of the Lucity Desktop install (C:\Program Files\Lucity\bin\Lucity.CreateDSN.exe by default).
  • This tool can be moved and run from other locations.

Using the Tool

  1. Double-click on the tool.  The following window will appear.
    DSN_Setup.png
  2. Provide the location of the Shared Folder.  This is the Config folder in the Lucity Server install.
    • UNC Pathing is recommended.
  3. Click Ok
  4. The tool will run and make all the necessary updates.

Advanced Functions

The Create DSN utility has several advanced functions that can be accessed by running this using the Windows Run tool.  These are included to allow administrators to run this utility as part of a script, or startup routine.

  • To access a list of these go to the Windows Start Menu and select Run.
  • Browse to the location of the Lucity.CreateDSN.exe and add /?
    Run_DSN.png
  • The following popup will appear with a list of advanced functions.
    DSN_Commands.png
Have more questions? Submit a request

Comments