connectivity between sql and vb

[sehar]

Hiiiiz to all guys!!!!!!!
I m new to sql server and want to open a connection between sql server and visual basic.
Can anyone help me to code connection string?
waiting 4 reply

[willakawill]

Hiiiiz to all guys!!!!!!!
I m new to sql server and want to open a connection between sql server and visual basic.
Can anyone help me to code connection string?
waiting 4 reply

Hi. This works. Put in your own database and query details

Dim cnCon As ADODB.Connection
Dim rs As ADODB.Recordset
Dim strSQL As String
 
Set cnCon = New ADODB.Connection
Set rsProbe = New ADODB.Recordset
 
strSQL = "SELECT blah blah blah"
 
With cnCon
    .Provider = "SQLOLEDB"
    .Properties("Data Source") = "your sql server"
    .Properties("User ID") = "your user id"
    .Properties("Password") = "your password"
    .Open
    .DefaultDatabase = "your default database"
End With
 
With rs
     .ActiveConnection = cnCon
     .CursorType = adOpenStatic
     .CursorLocation = adUseServer
     .LockType = adLockOptimistic
     .Source = strSQL
     .Open
End With