>Hi all,
>I create a client/server application with SQL database and VPF interface.
>The question is: if I create a connection in VFP to the SQL DB, that connection must have in it user and password for connecting to SQL DB. Otherwise, the SQL server requeries user and password at every request . But, if I include the user and password in that connection to SQL (in VFP), someone could use it from VFP and enter into SQL server .
>Finally, the solution I applied, which I think is the only one, was to open tables with "USE ... CONNSTRING ..." and the CONNSTRING to be stored encrypted in a table . The only objection to this is that every time "USE" is issued is created another connection to the SQL . Could that decrease speed if too many connections are opened ?
>What solution did you apply ?
>
>Thanks a lot,
>Mihai .
Mihai,
If you know the userid and pwd beforehand then instead you might use integrated security. No userid, pwd to store (I mean why not use windows authentication).
Cetin