hiding Logon information....

I have an online MySql Database that I will be connecting to in a distributed app. The user will Log in and all remote views will be filtered based on the userid. I have set up a user for my app that can access ALL the data.

I can’t figure out how to hide the user name and password in the connection object in the DBC. If I use dbsetprop it actually updates the DBC Connection. Anyone with access to the dbc can access all the data! I want specify the User and password at runtime and keep it hidden in a compiled EXE.

Can this be Done How I know I can do it with ADO but I prefer to use remote Views.

Thanks,
Dave M.




Answer this question

hiding Logon information....

  • John1984

    Problem solved...

    M.CONSTR='"DATABASE=......"'
    USE RView CONNSTRING &CONSTR

    Dave m.



  • hiding Logon information....