We have several machines where multiple people login.
Normally we set the ODBC to 'with NT auth with network
login id'

When we change it from this to 'SQL server auth asking for
login id/pwd' our Visual Basic apps no longer work.

Our VB apps do have a login screen & pwd and that string
is then forwarded to the server, at least we thought it
did.

a copy of our string is as follows:
MudbCn.Open "PROVIDER=MSDASQL;dsn=" & LiveTest & ";uid=" &
gvLogin & ";pwd=" & gvPwd

What do we have to do to properly pass through the ODBC
the loginid and password?