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.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer