>-----Original Message-----
>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?
>
>.