i need to make a connection to sql server 2000 from vb.net

[Anonymous]

i need to make a connection and i have no idea how you think i can get some help from you? thank you

[Dave Kreskowiak]

SqlConnection[^] class. You might also want to look at http://www.connectionstrings.com/[^] for some different connection strings. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

[maxiachun]

use notepad to create a udl file, which is just save the notepad as .udl then double click the udl file configure the connection through the dialog,after you done that you can open the udl file with notepad to get the connect string, then you just define the connection in the code and pass the string in. Anyway there are many ways to do so, you can find many examples on the net! I am Entry level person

[Dave Kreskowiak]

WAY too overly convoluted just to do this:

Dim myConn As New SqlConnection("myConnectionStringGoesHere")

You don't need a .UDL file to open a connection. And don't tell me this stuff. Reply to the Original Poster instead. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

[K Baruah]

Just try out the following in VB.NET Imports System.Data.SqlClient Dim oSQLConn As SqlConnection = New SqlConnection() oSQLConn.ConnectionString="my connectionstring" oSQLConn.Open() Kaushik Baruah Programmer Analyst Cognizant Technology Solutions,India