>I am using ODBC to connect my APP to the Backend along with a Connection on the DBC
>The Connection points to the System ODBC, now here is my Issue
>
>When I am in developer machine I provided the user and password to the connection in order to retrieve the data, however, I wouldnt do this on the Client side since this compromises the security of the data. Now my question
>
>In my scenario, what would I have to do in order to dynamically pass the user and password to the connection so the only one knowing this is my APP?
>
>What I want to avoid is to store the user and passw on the conection and somebuddy open the project using VFP and read this information.
>
>TIA
You could ALWAYS invoke connection dialog when you connect to SQL Server (or other databases):
SQLSETPROP(0,"DispLogin",1)
lnHandle = SQLCONNECT([DSNNameHere])
....
Other way is to use Trusted connections always :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.