how to create a connection with ADODB.

[Jaseem Ahmed]

i dont know aany thing about adodb..
please help me..
please tell me the step by step way to connect the database with adodb in vb6, and to add and update..

[Jx_Man]

first, Add reference before do all codes..
Click on Project->Reference, Find for Microsoft ActiveX Data Object 2.5 Library and select it.

this followwing code to connect vb6 with MS SqlServer
Create 1 button on your form

Public Con As New ADODB.Connection
Public rs As New ADODB.Recordset

Private Sub Command1_Click()
If Con.State = 1 Then Con.Close
    Con.ConnectionString = "Provider=MSDASQL;Driver={SQL Server}; " & _
    " SERVER=USER;Database=Test;Uid=;Pwd="
    Con.Open
MsgBox "VB6 has connected with SQLServer Database"

Con.Close
End Sub

[AndreRet]

Also note that your other posts using the recordset (rsAddNew) uses the conn as the connection. You need to change that to Con if you use JX's connection because the connection is called Con.:)

[Jaseem Ahmed]

Thanks Alot Jx and Andre....

[AndreRet]

It was a pleasure.:) Happy coding.