connect VB with SQL Server !!

[dere]

show me how to connect visual basic with sequential query language server.

[fplesco]

show me how to connect visual basic with sequential query language server.

Here try this.

I hope you know how to create a connectionstring....(",)
Or in place of ConnectionString, you can use DSN Name.

Public Con,Rs 
Public Function dbConnect(strQuery as string) 
    set Con = CreateObject("ADODB.Connection")
    Con.ConnectionString = "<your connectionstring>" 
    Con.Open
    set Rs = CreateObject("ADODB.Recordset")
    Rs.ActiveConnection = Con
    Rs.Open StrQuery
End Function
 

Then, you can manipulate Rs object in your forms after calling it and passing an SQL query paramater coz its global recordset ADO object.