>To prompt the user to login to a SQL Server database, I'm using SQLCONNECT passing just the ODBC DSN name and then the dialog comes up prompting the user for the appropriate logon info.
>
>I am able to retrieve the user's ID after this but I don't know how to retrieve the user's password (without building a separate front end to track this info). Does anyone know of a way, either through VFP or the SQL system tables/functions to get the user's password? SQLGETPROP doesn't work because it returns an empty string.
I'm not sure you would be able to do that. This would not be ok as far as the security goes. Of course, if you build your own interface, then you are acting as an intermediate and you could get it. Maybe someone else has done something with such an approach.