>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
What version of VFP are you using? For 7 and 8, you can use CONNSTRING with the USE command. See VFP Help on the USE command. In 8, CONNSTRING was modified to accept a connection handle as the CONNSTRING parameter.
Mark McCasland
Midlothian, TX USA