wrote:

>Hi,
> In my application , the connection to SQLServer is established
>through a DSN name, UserId and Password(both UsrId and Password are
>non empty) . The "SQLConnect" function is used for this purpose. The
>problem is that the connection to the Database is success when I give
>an empty UserId. But this problem is not there when the UserId is
>invalid(non empty).In all the cases except for empty UserId , the
>connection works as expectd.
>
>Why is it connecting for empty UserId?
>
>Is it because that default windows authentication is used for
>connection when UserId is empty?
>
>If so is there any way to avoid this (through a C/C++ program)?
>
>pls help
>
>Thanks
>Kaimal