Please i need your help how can i connect to my sql server 2000 i'm using visual basic and i want to connect to sql server database please thanks a lot

none

__________________
none

You may use ADO.Connection object.
Peko

Peko, Thanks for your reply but you know i'm using DAO command if you can can you show me how can i connecto to sql server else in ADO command connection thank you very much

none

First check the referrence for ADO Library (Menu Project => Reference => Microsoft ActiveX Data Objects Library)

Public gobjConnection As ADODB.Connection

Public Sub DBConnect()

  Set gobjConnection = New ADODB.Connection

  'if you use standard security
  gobjConnection.Open "Provider=sqloledb;" & _
                      "Data Source=myServerName;" & _
                      "Initial Catalog=myDatabaseName;" & _
                      "User Id=myUsername;" & _
                      "Password=myPassword"

  'or if you use trusted connection then

  gobjConnection.Open "Provider=sqloledb;" & _
                      "Data Source=myServerName;" & _
                      "Initial Catalog=myDatabaseName;" & _
                      "Integrated Security=SSPI"


End Sub

See MSDN for using ADO.Connection, ADO.Command, ADO.Recordset
Peko

hello my friend thank you for your reply i just want to ask you please can you show me your code if you can like if i delete my files in database using command delete i can retrieved my files or restore to my database my files thank you?.

none