Thanks Hector,
This is exactly what I was looking for.
Rex
>>All,
>>
>>I have remote views that I want to open without getting the login dialog. Is there some setting I can use to give the remote connection the username and password so I can open these views programmatically?
>>
>>TIA
>>
>>Rex
>You can embed the user id and password in the connection string. Create a connection string like this:
>
>
>OPEN DATABASE YourDBC
>CREATE CONNECTION MyConn CONNSTRING "SERVER=(local);DRIVER=sql server; UID=sa; PWD=; DATABASE=northwind; "
>
>
>Then, create a remote view to use this connection. VFP should not prompt you for user name and password since this info is stored in the connection.