Issue: SQL Connection Error - Temporarily Change Database Type in the Registry

Issue: SQL Connection Error - Temporarily Change Database Type in the Registry

Some Microvellum users may get an error related to SQL server connection issues such as: "A connection to the factory database could not be established. Please select a different configuration."

Symptom: Toolbox starts up but freezes, and you're unable to click Start Toolbox.

  • If this is your issue, be sure to close Toolbox via Task Manager before making changes to the registry.

These steps tell Toolbox to check your local database so that you can log in and reconnect to the SQL server.

  • Left-click on "Start Menu" and type "regedit.exe."

  • Follow the path as shown for your version:
  • OEM 2016:

    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R7.5\Toolbox-F001:409 \Configurations\[Configuration Name]\Database Settings

    OEM 2017:

    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R7.5\Toolbox-0001:409 \Configurations\[Configuration Name]\Database Settings

    OEM 2018:

    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R18.0\Toolbox-1001:409 \Configurations\[Configuration Name]\Database Settings

    OEM 2019:
    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R19.0\Toolbox-2001:409 \Configurations\[Configuration Name]\Database Settings
    OEM 2020:
    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R20.0\Toolbox-3101:409\Configurations\[Configuration Name]\Database Settings
    OEM 2021:
    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R21.0\Toolbox-4101:409\Configurations\[Configuration Name]\Database Settings
    OEM 2022:
    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R22.0\Toolbox-5101:409\Configurations\[Configuration Name]\Database Settings
    OEM 2023:
    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R23.0\Toolbox-6101:409\Configurations\[Configuration Name]\Database Settings
    OEM 2024:
    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R24.0\Toolbox-7101:409\Configurations\[Configuration Name]\Database Settings
    OEM 2025: 
    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R25.0\Toolbox-8101:409\Configurations\[Configuration Name]\Database Settings

    Toolbox Standard:

    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R7.0\Toolbox-Standard \Configurations\[Configuration Name]\Database Settings

    Micromanager/ERP: 

    HKEY_CURRENT_USER\Software\Microvellum\MicroManager\R7.0\MicroManager \Configurations \[Configuration Name]\Database Settings

    ALIS (Legacy):

    HKEY_CURRENT_USER\Software\Microvellum\ALIS\R7.0\ALIS \Configurations\[Configuration Name]\Database Settings

  • Right-click on "DataBaseType" and "Modify" – change "SQL" to "SQLCE" – restart the program.

  • Startup Toolbox, go to Toolbox Setup > Options > Data Access > Set to SQL Server and reconnect to your SQL server by DataCatalog and DataSource -- Be sure to test the connection!

      • Related Articles

      • Connecting Microvellum to an SQL Database (Unified Work Order Database)(Tutorial 3)

        This is the third in a series of tutorials presenting the steps necessary to install and configure a new SQL Server database to work within Microvellum. It focuses on how to configure Microvellum to connect to the new SQL Server databases you have ...
      • Configuring an SQL Express Database (Tutorial 2)

        This is the second in a series of tutorials presenting the steps necessary to install and configure SQL Server to work with Microvellum. This tutorial focuses on the concluding steps when configuring the new database instance you created previously ...
      • SQL Server Backups

        This article will list out the various types of backups you can create for databases hosted on an SQL Server, explore methods for creating backups manually and automatically, as well as list software/services that may assist you with backing up your ...
      • Installing SQL Server Express Edition (Tutorial 1)

        This is the first in a series of tutorials presenting the steps necessary to install and configure a new database. Later tutorials will present the steps to configure the SQL Server database instance to work with Microvellum.  We recommend the ...
      • Issue: Error Message "Common Language Runtime Detected an Invalid Program"

        Issue: When you start a Microvellum program, an error message is displayed that says, "Common Language Runtime detected an invalid program."  Solution: The value for the registry setting called LastConfig in the ApplicationSettings folder is not set ...
      • Recent Articles

      • Microvellum Release Notes | Build 25.2.0317.641

        The following release notes apply to Microvellum build 25.2.0317.641 Product Prompts UI Overhaul The Microvellum Product Prompts interface has been redesigned to improve efficiency and usability, giving users greater control over multiple features of ...
      • Microvellum Processing Center System Requirements

        This document lists both the minimum and recommended system configuration for operating Microvellum's standalone Processing Center application. For more information about the standalone application, see the Microvellum Processsing Center Application ...
      • Microvellum Release Notes | Patch 25.2.0227.641

        The following release notes apply to Microvellum build 25.2.0227.641 Processing Center Fixes Multiple fixes and updates were applied to the standalone Processing Center application to improve usability. Add New Configuration An update has been ...
      • Microvellum Foundation Library Release Notes | Build 26.0220

        The following release notes apply to the Microvellum Foundation Library build 26.0220. Additions Added DTC Magic Pro and Magic Star Ultra drawer systems. Magic Pro Items added in hardware file 300 and 600 lengths for all drawer heights. Add 60kg ...
      • Microvellum Release Notes | Build 25.2.0223.641

        The following release notes apply to Microvellum build 25.2.0223.641. Add 2D Elevation Tokens to 3D Drawings Fig. 1: The new 2D Elevation setting. A popularly requested feature by the community has been added to the Microvellum software: the checkbox ...