>When you set up 'Use Trusted Connection' in the VFP Conneciton, you are overridding the DSN. Besides, that is not secure anwya, your user could go change the DSN. Also your NT user account must have access to the database. At the backend you would have to turn of NT Security and only allow SQL Server security if you didn't want NT Authentication to take place.
>
>BOb
>
I don't think you can turn off NT security, at least with SQL Server 7. You can turn off SQL security and only allow NT, but not the other way around.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao