Getting exception error when trying to connect to sql server database

Question

I getting this error when I try to connection to sql server and I dont understand why. Here is the error:

Error: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception.
Stack Trace: at System.Data.SqlClient.SqlConnection..ctor()
             at System.Data.SqlClient.SqlConnection..ctor(String connectionString)

Here is my code:

connectionString = "Data Source=localhost\SQLEXPRESSSERVER;Initial Catalog=TEST_DATABASE;User ID=USERNAME;Password=PASSWORD;"

        Dim myConnection As New SqlConnection(connectionString)
        myConnection.Open()

saamorim · Accepted Answer · 2013-07-05 13:50:49Z

1

Try this connection string

connectionString = "Data Source=localhost\\SQLEXPRESSSERVER;Initial Catalog=TEST_DATABASE;User ID=USERNAME;Password=PASSWORD;"

You should escape your backslash \

Anyway, examine the inner exception for more details, as they usually provide additional information

answered Jul 5, 2013 at 13:50

saamorim

3,9251 gold badge19 silver badges22 bronze badges

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

2 Comments

Will Over a year ago

Thanks for responding. Tried the backslash and still unsuccessful.

saamorim Over a year ago

Does the exception has an innerexception? Is so, what is the error?

Community · Accepted Answer · 2017-05-23 11:56:32Z

1

I don't think the problem has anything to do with the connection string...

According to this, you probably have an error in your app.config or web.config...

Edit

Also, you should confirm if your code is throwing an innerexception along with the exception... Usually the real cause of the exception, will be in the innerexception...

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Jul 5, 2013 at 14:19

bastos.sergio

6,7644 gold badges29 silver badges36 bronze badges

Collectives™ on Stack Overflow

Getting exception error when trying to connect to sql server database

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related