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()

score 1 · Answer 1 · answered Jul 05 '13 at 13:50

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 05 '13 at 13:50

saamorim

3,855
17
22

Thanks for responding. Tried the backslash and still unsuccessful. – Will Jul 05 '13 at 14:00
Does the exception has an innerexception? Is so, what is the error? – saamorim Jul 05 '13 at 14:39

score 1 · Answer 2 · edited May 23 '17 at 11:56

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 '17 at 11:56

Community

1
1

answered Jul 05 '13 at 14:19

bastos.sergio

6,684
4
26
36

Getting exception error when trying to connect to sql server database

2 Answers2