Connection to SQL server

[TS]

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\mmm mm"
myConnection.Open()
End Sub

What am I missing?

--
TS

[Paul Clement]

On Thu, 3 Feb 2005 07:15:08 -0800, "TS" <[e-mail]> wrote:

¤ 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\mmm mm"
¤ myConnection.Open()
¤ End Sub
¤
¤ What am I missing?

A data source?

See if the following examples help:

http://www.able-consulting.com/dotne...anagedProvider
http://www.connectionstrings.com (SqlConnection (.NET))
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[TS]

Thanks for your reply.
Is the data source in your example (data source=local) equivalent to the
server name provided in the connection string of my code
(server=zzzzz\mmmmm)? If yes, this shouldn't be the issue. If no, what do you
mean by data source?

Thank you

"Paul Clement" wrote:

On Thu, 3 Feb 2005 07:15:08 -0800, "TS" <[e-mail]> wrote:

¤ 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\mmm mm"
¤ myConnection.Open()
¤ End Sub
¤
¤ What am I missing?

A data source?

See if the following examples help:

http://www.able-consulting.com/dotne...anagedProvider
http://www.connectionstrings.com (SqlConnection (.NET))
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[C-Services Holland b.v.]

TS wrote:

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\mmm mm"
myConnection.Open()
End Sub

What am I missing?

Maybe this:
Dim myConnection As New SqlClient.SqlConnection()

--
Rinze van Huizen
C-Services Holland b.v.

[Paul Clement]

On Thu, 3 Feb 2005 12:11:08 -0800, "TS" <[e-mail]> wrote:

¤ Thanks for your reply.
¤ Is the data source in your example (data source=local) equivalent to the
¤ server name provided in the connection string of my code
¤ (server=zzzzz\mmmmm)? If yes, this shouldn't be the issue. If no, what do you
¤ mean by data source?

I didn't see the "server" argument the first time I looked at the connection string. I don't see any
problem with the syntax.

What is the error you are getting?
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[Jim Hughes]

You need an instance of the SqlConnection object.

Dim myConnection As SqlClient.SqlConnection = new SqlClient.SqlConnection

"TS" <[e-mail]> wrote in message
news:80**********************************@microsof t.com...

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\mmm mm"
myConnection.Open()
End Sub

What am I missing?

--
TS