Connect to SQL server

[Guest]

Hi all,

I'm trying to connect to an SQL database from my vb.net form, but getting an
error message. The code I used is the following:

Private Sub ConnectSQL_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles ConnectSQL.Click
Dim myConnection As SqlClient.SqlConnection
myConnection.ConnectionString = "Persist Security
Info=true;Integrated Security=false;User
ID=sa;Password=xxxxx;database=yyy;server=zzzzz\mmmmm"
myConnection.Open()
End Sub

What am I missing?

 

[Chris, Master of All Things Insignificant]

What error message are you getting? Did you try making the connection in
Server Explorer?

Chris

 

[Herfried K. Wagner [MVP]]

I'm trying to connect to an SQL database from my vb.net form, but getting
an
error message. The code I used is the following:

Private Sub ConnectSQL_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles ConnectSQL.Click
Dim myConnection As SqlClient.SqlConnection
myConnection.ConnectionString = "Persist Security
Info=true;Integrated Security=false;User
ID=sa;Password=xxxxx;database=yyy;server=zzzzz\mmmmm"
myConnection.Open()
End Sub

For possible connection strings, see
<URL:http://www.connectionstrings.com/>. What error message are you
getting?

 

[Marc Miller]

You need to instantiate your connection as a 'New SQLClient.SQLConnection'.

Dim myConnection As SqlClient.SqlConnection = New SqlClient.SqlConnection

You should use a 'Try Catch' to trap your errors. You would have received
the
error:
'Object reference not set to an instance of an object.'
M. Miller

 

[chanmmn]

Example:

Dim strConnectionString As String =
"server=(local);database=pubs;Trusted_Connection=yes"

chanmm

 

[Cor Ligthert]

TS,

Because there are more answers, have a look at the answer from Marc, the
others two can nock at there head when they see what they wrote while it was
so easy. (Not that it is important they both give mostly great answers and I
make those mistakes as well.)



Cor

 

[Guest]

Chris,
Thanks for your reply. I coudn't establish the connection from Server
Explorer because I have vb.net standard edition

 

[Guest]

Thanks for your reply. I tried what Marc suggested and it worked fine.

 

[Guest]

Marc,
Thanks a lot. I tried the code you suggested and it worked fine.