Recently I encountered a scenario where a client machine was returning the error, “The type initializer for ‘System.Data.SqlClient.SqlConnection’ threw an exception”, when running a map that connects to SQL.
The error message is a standard .NET Framework error, that is saying .NET can’t create the SQL connection.
The error is caused by a corruption of the .NET installation on the user’s machine.
Steps to resolve
- Verify that the correct version of .NET is installed for your version of SmartConnect. You can find the required version in the prerequisites section of the User manual.
- Try running the Microsoft .NET Framework Repair Tool.
- If that does not work, uninstall the existing installation and reinstall the .NET Framework.
If you have any questions, feel free to contact email@example.com