I want to upgrade a TW database using twdeployerGUI.exe (2024-2) (the Upgrade option in TW Deployer). However, as soon as I click the Connect button, I get an error.
Error log:
System.BadImageFormatException:
File name: 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5'
at Thinkwise.Deployer.Data.SQLServer.SqlServerDeployerDbProvider.CreateConnection(String server)
at Thinkwise.Deployer.Data.DeployerDbProviderExtensions.CreateConnection(IDeployerDbProvider provider, DbConnectionInfo info) in C:\azp\agent\_work\1\s\src\Data\Thinkwise.Deployer.Data\DeployerDbProviderExtensions.cs:line 15
at Thinkwise.Deployer.Data.DeployerDbProviderExtensions.CreateOpenedConnectionAsync(IDeployerDbProvider provider, DbConnectionInfo info, CancellationToken cancellationToken) in C:\azp\agent\_work\1\s\src\Data\Thinkwise.Deployer.Data\DeployerDbProviderExtensions.cs:line 45
at Thinkwise.Deployer.ProgressFlow.Database.DatabaseHostSelectionProgressFlowStep.Validate() in C:\azp\agent\_work\1\s\src\ProgressFlow\Thinkwise.Deployer.ProgressFlow.Database\Steps\DatabaseHostSelectionProgressFlowStep.cs:line 61
at Thinkwise.Deployer.ProgressFlow.DefaultProgressFlowStep.Complete() in C:\azp\agent\_work\1\s\src\ProgressFlow\Thinkwise.Deployer.ProgressFlow\Steps\DefaultProgressFlowStep.cs:line 31
at Thinkwise.Deployer.ViewModel.ProgressFlowViewModel.OnNext() in C:\azp\agent\_work\1\s\src\Thinkwise.Deployer.ViewModel\ProgressFlowViewModel.cs:line 126
This is a new laptop, and it’s the first time I’m starting TW Deployer on it.
It concerns a local SQL Server 2022 installation.
I’ve also tried using an ‘sa’ SQL account and the server name (local) — both result in the same error.
All SQL protocols are active, so it should be able to connect via Shared Memory or TCP/IP. Other applications using SQL databases work fine.
I can also start our TW application (the one I’m trying to update) without any issues.