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

    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

      • Toolbox Release Notes | Build 25.1.0213.641

        The following release notes apply to Toolbox build 25.1.0213.641. Stay Down Nesting Additions 3 new settings have been added to Stay Down Nesting, to resolve specific issues with routes and connectors that have been reported: Fig. 1: New options in ...

      • Toolbox Release Notes: Year of 2024

        This document will catalog all releases for Microvellum Toolbox software builds that were released in the year 2024. This encompasses builds 24.1.0104.641 to 24.1.1206.641. Toolbox Release Notes | Build 24.1.1206.641 The following release notes apply ...

      • Toolbox Release Notes | Build 25.1.0129.641

        The following release notes apply to Toolbox build 25.1.0129.641. SMA Fixes A wide variety of issues with the Solid Model Analyzer have been resolved. Multiple modifications to existing interfaces or settings have been made to improve precision and ...

      • Microvellum Foundation Library Release Notes | Build 25.0124

        The following release notes apply to Microvellum Foundation Library build 25.0124. Additions Added Century Components Waste Bins, Vanity Organizers, and Base Cabinet Organizers. 11”, 14”, 17” Signature Series Bottom Mount 34qt & 50qt. 4”, 5”, 6”, 9”, ...

      • 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 ...