>Hi Everyone
>
>I know This in not the first time i am asking this but i need some help asap!
>
>Problem 1
>---------
>
>I Have a vfp7 application with an Sql Server Database.
>
>On The Sql Server Enterprise Manager i add new logins and then add users to my database.
>
>
>What i want is to have a login screen(in VFP7) to validate the user name and password as enetered on the SQL Server before a uses starts using my application.
>
>How can i do This?
>
>Does any one have any examples to help me?
>
>
>Any Help Would Be Appreciated.
>
>
>Problem 2
>---------
>
>Is it possible to 'Copy' users from one Database to another programatically ?
>
>
>
>Tnx in Advance
>Anthi

1)
* Get user name and pwd

sqlsetprop(0,'DispWarnings',.f.) && Prevent error message
sqlsetprop(0,'DispLogin',3) && Disable login dialog

* Try to connect
* If couldn't get a handle check with aError
arrError[1] = 1526 && VFP error number
arrError[5] = 18456 && SQL server 'login failed'

2) I think you could do that with DTS tool.
Cetin