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

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

• Transferring Data to an SQL Server Database (Unified Work Order Database)(Tutorial 4)

  This is the fourth 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 transfer data to new SQL Server databases. Click here to view the third ...

• Recent Articles

• Toolbox Release Notes | Build 24.1.0416.641

  The following release notes apply to Toolbox build 24.1.0416.641. Maestro Toolfile Fix There was an issue with Maestro SCM Toolfiles reportedly experienced by some users, wherein the labels output by autolabeling would be in incorrect positions, an ...

• Toolbox Release Notes | Build 24.1.0409.641

  The following release notes apply to Toolbox build 24.1.0409.641 Saw Delimited Processing Station Figure 1: The Saw Delimited option in a custom processing station. New options have been added to saw processing stations to allow for control over data ...

• Toolbox Release Notes | Build 24.1.0328.641

  The following release notes apply to Toolbox Build 24.1.0328.641 Fillet Token Fixes Issues were discovered in the use of fillet tokens on products that also had the IRIB setting enabled: Some users processed work orders with rounded parts, which ...

• Microvellum Foundation Library Release Notes | Build 24.0322

  Additions Added the Master Angled Ends Cabinet. Added a Global prompt, "Hinge Plate Offset From Front" for easier control. Added “Double Division” option to Horizontal Designer Cabinets, 3 Door Cabinets, and other similar products. Added a new ...

• Common Floating License Connectivity Issues

  This document lists common issues reported by users regarding the topic of Microvellum’s Floating License Activation (FLA) and the connectivity required for FLA to function. Firewall Blocking Activation of Floating License Some users have had an ...