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

  The following release notes apply to Toolbox build 24.1.1206.641 MV Server Nesting Fix There was a reported issue occurring when users attempted to remotely process work orders using a nesting station on MV Server. When attempting to process the work ...

• Microvellum Foundation Library Release Notes | Build 24.1127

  The following release notes apply to Microvellum Foundation Library build 24.1127. Additions Added a new Soffit product to the Upper Cabinet Accessories category. Added the Top Filler (Ceiling Scribe) option to Upper and Tall cabinets. (Corner ...

• Toolbox Release Notes | Build 24.1.1125.641

  The following release notes apply to Toolbox build 24.1.1125.641. IRIB Setmill Location Fix Fig. 1: Setmill being moved to the start of the route (top) rather than at the center of a straight line, as intended (bottom). There was an issue reportedly ...

• Toolbox Release Notes | Build 24.1.1105.641

  The following release notes apply to Toolbox build 24.1.1105.641 Nesting Fix Fig. 1: The fatal error that would occur during processing. There was reportedly an issue that occurred when clients attempted to process a work order using the nesting ...

• Microvellum Foundation Library Release Notes | Build 24.1025

  The following release notes apply to Microvellum Foundation Library build 24.1025. Additions Added new global variable “Remove Stop Dado On Bottom Edge” for wood drawer boxes. Check this option to run the dado through at the bottom of the sub front ...