>Hello,
>
>Since Windows Authentication doesn't work with W98/MSDE2000, a named connection is necesary to automatically open remote views in every form, but UID and PWD will be stored in MyData.DBC which is not so good.
>
>Is there some workaround to create a connection string during run time , so the dataenvironment´s remote views can use it ? Or we have to open the views by using the USE Command and the cConnString parameter , is this correct ?
>
>Any other schema without leaving UIDs and PWDs stored ? (W98/MSDE2000)
When your app starts, you could ask the user for the user name and password necessary to access MSDE. These could be stored as memvars or application object properties while your app is running.
To test if the user typed them in correctly, rather than storing the username and passwords themselves, store MD5 hashes of them. It is easy to test if MD5Hash(< user's name or password >) is the same as the previously stored hashes, but almost impossible to back-calculate the user name or password from the hash value.
For more info check out
Re: Hash() Function in VFP Thread #
713481 Message #
714561
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up