SqlConnection throws an exception when running without debugging

Question

I have an exception every time I try to run my program without debugging (Ctrl+F5). The code seems to run fine with debugging. I have tried creating a temp project with just the essentials. I have reinstalled Visual Studio. The problem still occurs. There is already a post about this but not a clear answer.

My Connection String:

"Data Source=(localdb)\\ProjectsV12;Initial Catalog=gatdb;Integrated Security=False;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False;Trusted_Connection=False;"

The Exception occurs here:

(SqlConnection connection = new SqlConnection(connectionString))

This is the exception:

System.TypeInitializationException was unhandled
  HResult=-2146233036
  Message=The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception.
  Source=System.Data
  TypeName=System.Data.SqlClient.SqlConnection
  StackTrace:
       at System.Data.SqlClient.SqlConnection..ctor()
       at System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential)
       at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
       at GatHunter.Sql.IsServerConnected(String connectionString) in c:\users\kold\documents\visual studio 2015\Projects\ScatteredGats\GatHunter\Sql.cs:line 14
       at GatHunter.Program.Main(String[] args) in c:\users\kold\documents\visual studio 2015\Projects\ScatteredGats\GatHunter\Program.cs:line 14
  InnerException: 
       HResult=-2146233036
       Message=The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception.
       Source=System.Data
       TypeName=System.Data.SqlClient.SqlConnectionFactory
       StackTrace:
            at System.Data.SqlClient.SqlConnection..cctor()
       InnerException: 
            HResult=-2146233036
            Message=The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception.
            Source=System.Data
            TypeName=System.Data.SqlClient.SqlPerformanceCounters
            StackTrace:
                 at System.Data.SqlClient.SqlConnectionFactory..ctor()
                 at System.Data.SqlClient.SqlConnectionFactory..cctor()
            InnerException: 
                 BareMessage=Configuration system failed to initialize
                 HResult=-2146232062
                 Line=0
                 Message=Configuration system failed to initialize
                 Source=System.Configuration
                 StackTrace:
                      at System.Configuration.ConfigurationManager.EnsureConfigurationSystem()
                      at System.Configuration.ConfigurationManager.PrepareConfigSystem()
                      at System.Configuration.ConfigurationManager.GetSection(String sectionName)
                      at System.Configuration.PrivilegedConfigurationManager.GetSection(String sectionName)
                      at System.Diagnostics.DiagnosticsConfiguration.Initialize()
                      at System.Diagnostics.DiagnosticsConfiguration.get_SwitchSettings()
                      at System.Diagnostics.Switch.InitializeConfigSettings()
                      at System.Diagnostics.Switch.InitializeWithStatus()
                      at System.Diagnostics.Switch.get_SwitchSetting()
                      at System.Data.ProviderBase.DbConnectionPoolCounters..ctor(String categoryName, String categoryHelp)
                      at System.Data.SqlClient.SqlPerformanceCounters..ctor()
                      at System.Data.SqlClient.SqlPerformanceCounters..cctor()
                 InnerException: 
                      HResult=-2146233036
                      Message=The type initializer for 'System.Uri' threw an exception.
                      Source=System.Configuration
                      TypeName=System.Uri
                      StackTrace:
                           at System.Configuration.ClientConfigurationSystem..ctor()
                           at System.Configuration.ConfigurationManager.EnsureConfigurationSystem()
                      InnerException: 
                           HResult=-2146233036
                           Message=The type initializer for 'System.UriParser' threw an exception.
                           Source=System
                           TypeName=System.UriParser
                           StackTrace:
                                at System.Uri..cctor()
                           InnerException: 
                                HResult=-2146233036
                                Message=The type initializer for 'System.Runtime.Versioning.BinaryCompatibility' threw an exception.
                                Source=mscorlib
                                TypeName=System.Runtime.Versioning.BinaryCompatibility
                                StackTrace:
                                     at System.Runtime.Versioning.BinaryCompatibility.get_TargetsAtLeast_Desktop_V4_5()
                                     at System.UriParser..cctor()
                                InnerException: 
                                     HResult=-2146233033
                                     Message=Input string was not in a correct format.
                                     Source=mscorlib
                                     StackTrace:
                                          at System.Version.VersionResult.SetFailure(ParseFailureKind failure, String argument)
                                          at System.Version.TryParseComponent(String component, String componentName, VersionResult& result, Int32& parsedComponent)
                                          at System.Version.TryParseVersion(String version, VersionResult& result)
                                          at System.Version.Parse(String input)
                                          at System.Version..ctor(String version)
                                          at System.Runtime.Versioning.BinaryCompatibility.ParseFrameworkName(String frameworkName, String& identifier, Int32& version, String& profile)
                                          at System.Runtime.Versioning.BinaryCompatibility.ParseTargetFrameworkMonikerIntoEnum(String targetFrameworkMoniker, TargetFrameworkId& targetFramework, Int32& targetFrameworkVersion)
                                          at System.Runtime.Versioning.BinaryCompatibility.ReadTargetFrameworkId()
                                          at System.Runtime.Versioning.BinaryCompatibility.get_AppWasBuiltForFramework()
                                          at System.Runtime.Versioning.BinaryCompatibility.BinaryCompatibilityMap..ctor()
                                          at System.Runtime.Versioning.BinaryCompatibility..cctor()
                                     InnerException:

Looking at the stack trace, it seems that the target framework id that BinaryCompatibility.ReadTargetFrameworkId() is reading has an invalid version number. Googling for ReadTargetFrameworkId shows that you aren't alone: you could try the solution described here: stackoverflow.com/questions/12537303/… — to StackOverflow
– to StackOverflow, Commented Dec 9, 2015 at 8:41

Jannik · Accepted Answer · 2015-12-09 06:03:01Z

1

In your connection string Integrated Security is set to False.

User ID = ****; Password = **** missing in your connection string.

If you would like to connect using Windows Authentication use

Integrated Security=SSPI; instead of Integrated Security=true;

If you try to use Integrated Security=true/false/yes/no with OleDb provider, you will get an exception during connection.

edited Dec 9, 2015 at 6:03

Jannik

2,4396 gold badges34 silver badges64 bronze badges

answered Dec 9, 2015 at 5:42

knkarthick24

3,24619 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kold · Accepted Answer · 2015-12-10 04:17:57Z

1

I want to thank everybody for their advise. I do not know why but what fixed this issue for me (even though I created an entirely new project and didn't touch the app.config) was this.

delete app.config
re-create via add->new item-> app.config
switch the target framework from 4.6.1 to 4.0 then back to 4.6.1 again.

Initially I wanted to see what the reaction was when I switched to the 4.0 framework and to my surprise it suddenly started working. I know this sounds strange and I have no explanation for it.

answered Dec 10, 2015 at 4:17

Kold

411 silver badge4 bronze badges

Comments

Irshad · Accepted Answer · 2015-12-09 04:17:03Z

0

This mostly due an error in your app.config file, Check for badly formed XML or unexpected elements.

Also double check you connectionstring.

Try simplifying the connection string to;

string str="Data Source=(localdb)\\ProjectsV12;Initial Catalog=gatdb;Integrated Security=False;User ID=sa;Password=sa;";
SqlConnection connection = new SqlConnection(str);

and try again.

answered Dec 9, 2015 at 4:17

Irshad

3,1415 gold badges33 silver badges57 bronze badges

3 Comments

Kold Over a year ago

I don't think so. This happens with a fresh project. I have also tried to delete and re-add a new app.config doesn't seem to fix it.

Irshad Over a year ago

Try simplifying the connection string

Irshad Over a year ago

Can you provide further more on how you create the connectionString and connection.

Avinash Jain · Accepted Answer · 2015-12-09 07:46:36Z

0

Do the following steps.

Create "xyz.udl" file on desktop.
Double click on that file.
Select appropriate provider
Select server
Set user / password and allow to save password
Select database and hit test connection.
Click on Ok button.
Open that "xyz.udl" file in notepad.

Copy your connection string and use that.

edited Dec 9, 2015 at 7:46

Avinash Jain

7,6862 gold badges29 silver badges40 bronze badges

answered Dec 9, 2015 at 6:16

Bhavik Jani

1807 bronze badges

Collectives™ on Stack Overflow

SqlConnection throws an exception when running without debugging

4 Answers 4

Comments

Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related