ADODB Connection Username and Password

[hypnotoad]

Hi,

I'm trying to create a quick userform for users to look up specific values in a database. These users do not have access to the database, but I can use other credentials that do. When I put these credentials in the connecting string, it does not appear to be working. Is my syntax incorrect?

    ConnectionString = "Provider=SQLOLEDB;Data Source=server\db;" & _
                  "Initial Catalog=mydatabasenamespace;" & _
                  "Integrated Security=SSPI;" & _
                  "User ID=user;Password=password"

Any help would be appreciated. Thank you.

EDIT: Connecting the SQL server. This works on my computer, but not on the user's computers.

 

[RoryA]

Remove the Integrated Security=SSPI line.