Ole DB connection....

For Standard Security:

oConn.Open "Provider=sqloledb;" & _
          "Data Source=myServerName;" & _
          "Initial Catalog=myDatabaseName;" & _
          "User Id=myUsername;" & _
          "Password=myPassword;"
For a Trusted Connection:

oConn.Open "Provider=sqloledb;" & _
          "Data Source=myServerName;" & _
          "Initial Catalog=myDatabaseName;" & _
          "Integrated Security=SSPI;"
To connect to a "Named Instance" (SQL Server 2000)

oConn.Open "Provider=sqloledb;" & _
          "Data Source=myServerName\myInstanceName;" & _
          "Initial Catalog=myDatabaseName;" & _
          "User Id=myUsername;" & _
          "Password=myPassword;"

iøvrigt masser af connectionstrings på:
http://www.able-consulting.com/ado_conn.htm