Unable to save or load the Venus 1500 V4 Database, SQLCMD.exe in the wrong spot

Potential Symptoms

  • Unable to Save or Load the Venus 1500 V4 Database (see How do I transfer my Venus 1500 V4 Database? DD2451499)
    • First it will give: The system cannot find the file specified File path: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE
      KB1.jpg
    • Then it will say: Please wait until the current process is finished
      KB2.jpg
  • The file mentioned in the first error can't be found at that file path.

Environment

  • Product Family: Message Displays
  • Product:
  • Component: Microsoft Windows 10, SQL 2014
  • Control System: Venus 1500 V4

Cause

  • During the installation of Microsoft SQL Server it has been known to put SQLCMD.exe in a different spot.
  • The Venus 1500 Database Utility is unable to find it.

Resolution

  • Navigate here for Windows 10: C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\110\
  • Copy the Tools folder.
  • Navigate here for Windows 10: C:\Program Files (x86)\Microsoft SQL Server\90\
  • Paste the folder there.
  • It may be necessary to restart the computer.
  • Load or Save your Database.

For Temporary Operation

  1. Uninstall Venus V4. (see How to uninstall Venus V4 DD2774844)
  2. Uninstall Microsoft SQL Server (see How to remove/uninstall SQL Server 2005, 2008 or 2014 DD3522855)
  3. Manually install SQL Server (see How to Install Microsoft SQL Server 2014 Manually DD3302758)
  4. Install Venus V4 (see How do I update or download Venus 1500 V4 software? DD1993540)
  5. Load or Save your Database.

KB ID: DD4023754


Fill out my online form.
DISCLAIMER: Use of this content may void the equipment warranty, please read this DISCLAIMER prior to performing any service of the equipment.