hello..
Is not necessary to connect to SQL Server databases inserting user id and password .. can be used windows authentication
Dim connStr As String = "provider=sqloledb;data source=.\sqlexpress;database=dbname;integrated security=sspi"
Dim conn As New System.Data.OleDb.OleDbConnection(connStr)
conn.Open()
if you have a user id and password by creating a user in sql server
Dim connStr As String = "provider=sqloledb;data source=.\sqlexpress;database=dbname;user id=user;password=pass"