Migrated to new server failed, rollback to previous server failed !

[neosys]

Initially with Lansweeper v4.1, I migrated the DB from SQL2005 to SQL2008.
Modified the credentials in the config files.
It Failed.

Now I have set the config files back to how they were before. Same error.

System.ArgumentException: Un fournisseur OLE DB n'était pas spécifié dans ConnectionString. Par exemple, 'Provider=SQLOLEDB;'.
à System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid)
à System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String connectionString)
à System.Data.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate)
à System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
à System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
à System.Data.OleDb.OleDbConnection.ConnectionString_Set(String value)
à System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)
à System.Data.OleDb.OleDbConnection..ctor(String connectionString)
à DreamweaverCtrls.DataSet.NewDbConnection(String strConnection)
à DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.ArgumentException: Un fournisseur OLE DB n'était pas spécifié dans ConnectionString. Par exemple, 'Provider=SQLOLEDB;'.
à System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid)
à System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String connectionString)
à System.Data.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate)
à System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
à System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
à System.Data.OleDb.OleDbConnection.ConnectionString_Set(String value)
à System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)
à System.Data.OleDb.OleDbConnection..ctor(String connectionString)
à DreamweaverCtrls.DataSet.NewDbConnection(String strConnection)
à DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.ArgumentException: Un fournisseur OLE DB n'était pas spécifié dans ConnectionString. Par exemple, 'Provider=SQLOLEDB;'.
à System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid)
à System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String connectionString)
à System.Data.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate)
à System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
à System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
à System.Data.OleDb.OleDbConnection.ConnectionString_Set(String value)
à System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)
à System.Data.OleDb.OleDbConnection..ctor(String connectionString)
à DreamweaverCtrls.DataSet.NewDbConnection(String strConnection)
à DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
Device overview
Add new device
System.ArgumentException: Un fournisseur OLE DB n'était pas spécifié dans ConnectionString. Par exemple, 'Provider=SQLOLEDB;'.
à System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid)
à System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String connectionString)
à System.Data.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate)
à System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
à System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
à System.Data.OleDb.OleDbConnection.ConnectionString_Set(String value)
à System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)
à System.Data.OleDb.OleDbConnection..ctor(String connectionString)
à DreamweaverCtrls.DataSet.NewDbConnection(String strConnection)
à DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist.
à DreamweaverCtrls.DataSet.get_DefaultView()
--------------------------------------------------------------------------------
System.ArgumentException: Un fournisseur OLE DB n'était pas spécifié dans ConnectionString. Par exemple, 'Provider=SQLOLEDB;'.
à System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid)
à System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String connectionString)
à System.Data.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate)
à System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
à System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
à System.Data.OleDb.OleDbConnection.ConnectionString_Set(String value)
à System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)
à System.Data.OleDb.OleDbConnection..ctor(String connectionString)
à DreamweaverCtrls.DataSet.NewDbConnection(String strConnection)
à DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist.
à DreamweaverCtrls.DataSet.get_DefaultView()

[neosys]

As usual your support pointed the error and corrected efficiently.
Topic closed.

[neosys]

Email sent with both file configuration

[Hemoco]

Please contact us at support@lansweeper.com and provide us with the following files:
- Program Files\Lansweeper\Service\Lansweeperservice.exe.config
- Program Files\Lansweeper\Website\web.config

For easy reference, also include a link to this forum thread in your email.