>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]) && The DSN should not contain username and/or password
* or lnHandle = SQLSTRINGCONNECT([Driver=SQL Server;DataBase=YourDB;Server=SomeServer])
....

Other way is to use Trusted connections always :-)