connect to Sql Server

[sssdexter]

Hi,

How i can connect my application to Sql Server database?

Thanks in advance

 

[SemperFiDownUnda]

  Dim conn as ADODB.Connection
  Set conn = New ADODB.Connection
  conn.ConnectionString = "Provider=SQLOLEDB.1;" & _
                          "Persist Security Info=False;" & _
                          "User ID=blah;" & _
                          "Password=Password4Blah;" & _
                          "Initial Catalog=DatabaseName;" & _ 
                          "Data Source=ServreName"
  conn.Open

This is one way to do it. You have to have have the SQLOLEDB drivers (MDAC has them) on your machine and you have to reference the ADO library in your project.

 

[sssdexter]

Hi,

Thanks a lot