Adodb OPEN with connection string & passed parameters

Targets Windows
1

does anyone happen to know when using ADODB if you pass a connection string with a userid & password AND also call Open with a user id and password which it prefers ?
ie/ if you did

connectionString = "Provider=SQLNCLI11;Data Source=MSEDGEWIN10\\SQLEXPRESS; Initial Catalog=Testing; User Id=IEUser1; Password=Password1; Integrated Security=SSPI"

adodbConnection.Open(connectionString, “IEUser2”, “Password2”)
would it connect as user1 or user2 if both were legal log ons ?

2

Hi Norman,

Usually (not always) the second connection will override the connection string login

If you pass user and password information both in the ConnectionString argument and in the optional UserID and Password arguments, the UserID and Password arguments will override the values specified in ConnectionString.

open-method-ado-connection

3

well crap how’d I miss that ?

Thanks for point me straight