You don't need user name and password for Windows authentication. Try
lnHandle = Sqlstringconnect("driver=SQL Server" + ;
";server=MySQLServer" + ;
";database=MyDatabase" + ;
";app=MyApp(3.2.0)")
>We are connecting to SQL Server using SQL Server authentication using the following code:
>
>lnHandle = Sqlstringconnect("driver=SQL Server" + ;
> ";server=MySQLServer" + ;
> ";uid=username" + ;
> ";pwd=password" + ;
> ";database=MyDatabase" + ;
> ";app=MyApp(3.2.0)")
>
>We need to move to Windows authentication where database users belong to a security group in Windows Active Directory. This Active Directory user group is then added as a login to SQL Server.
>
>With this model the user fails to authenticate using the above string connect, as it seems that SQL is looking for the exact user login. The user can authenticate through a DSN or a CursorAdaptor but we do not use either.
>
>Any help would be appreciated.
--sb--