3 Tipos distintos de conectar en vb.net a una base de datos.

STRING PARA BASE DE DATOS CON RUTA ESPECIFICA
    Public Const DB_STRING = "Data Source=.SQLEXPRESS;" & _
                                "AttachDbFilename=" & DB_RUTA & DB_NOMBRE & ";" & _
                               "User Instance=True;" & _
                               "Integrated Security=True;" & _
                               "User ID=" & Usuario & ";" & _
                               "PWD=" & Password & ";"

   
STRING SERVER
    Public Const DB_STRING = "Data Source=" & Servidor & ";" & _
                                "Initial Catalog=" & DB_RUTA & DB_NOMBRE & ";" & _
                                "User Id=" & Usuario & ";" & _
                                "Password=" & Password & ";"
   
STRING PARA OLEDB
    Public Const DB_STRING_OLE = "Provider=SQLOLEDB;" & _
                                "Data Source=" & Servidor & ";" & _
                                "Initial Catalog=" & DB_RUTA & DB_NOMBRE & ";" & _
                                "Integrated Security=SSPI;" & _
                                "UserId=" & Usuario & ";" & _
                                "Password=" & Password & ";"