Daktronics

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

Potential Symptoms

  • Unable to install, Save or Load the Venus 1500 V4 Database (see How do I use the Nucleus Server Database utility to transfer or save a database? DD1705994.)
    • 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.
  • Receive the following error when installing SQL 2014 from the Venus install file "File not found: SQL CMD.exe."
  • Even after a manual SQL installation, the Venus 1500 v4 software setup install will not complete. It gives the above "Error updating database".

Environment

  • Product Family: Message Displays, Software
  • 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

  1. Navigate here for Windows 10: C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\110\
  2. Copy the Tools folder.
  3. Then Navigate here for Windows 10: C:\Program Files (x86)\Microsoft SQL Server\90\
  4. Paste the folder there in "90".
    1. It may be necessary to restart the computer.
  5. Then try again to Load, Save, or install your Database or software setup.

For Temporary Operation

  1. Uninstall Venus 1500 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

DISCLAIMER: Use of this content may void the equipment warranty, please read the disclaimer prior to performing any service of the equipment.

DAKTRONICS DOES NOT PROMISE THAT THE CONTENT PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED ON AN "AS-IS" AND "AS-AVAILABLE" BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT, REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE PARTIES.

The above disclaimer applies to any property damage, equipment failure, liability, infringement, or personal injury claim arising out of or in any way related to your use or application of the content, whether such claim is for breach of contract, tort, negligence or any other cause of action.