I am new to SQL and I am trying to connect to mssql server via vb.net with a code someone else has done. I am not sure why it won't connect. part of the code is below:
_DBConnection = New SqlConnection '(ConnectionString)
_DBConnection.ConnectionString = "Server=MASTEC;Database=CHH_Cardboard_DA_new;User ID=sa;Password=xxxx;Trusted_Connection=False"
when I run this I get the following error:
"A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error."
I am able to connect using odbcconnection but the rest of the code uses commands from System.Data.SqlClient.
Can anyone help me please. :-|