>Hi all,
>There is something that doesn't work the way I expected about security when imlementing SQL Server 2000 .
>The question is : how do I "hide" the data behind the passwords when working with Remote Views ?
>The solution would be to send the passwords in SQL PassThrough commands. But , to have a user-friendly interface and for rapid development reasons, I should work with Remote Views. In this case , how could I send the password ?
>To work with the database, first I create a DSN connection in ODBC . I can't put the password there, because someone else could use it to access the DB.
>Then I could make a connection in Visual Fox and connect to SQL BD using that connection in Visual Fox. But , once again, when I create the connection, someone else in the LAN can connect to my DBC and use that connection (with password). So, what solution can I have to hide the password ?
>
>Thank You very much in advance,
>Mihai .
Mihai,
Do not save anything in DBC itself. When you need the table use it with "CONNSTRING' clause.
use myDBC!myview Connstring "SQLconnectionstring"
Cetin