When I do the following, it still asks for my SQL password when it tries to open the remote view SQL_arfiles that is defined in DT.dbc.

I do not want the user of the application to have to type in the passwod.


=SQLCONNECT("SQL_Server", 'joel', 'd345')
OPEN DATABASE dt.dbc SHARED
USE sql_arfiles