You can put your user name and password into your connection. Then set the connection's DispLogin property to either 1 or 3. That will prevent the login dialog from displaying when the information has already been entered.
>I have set up a little routine which rebuilds all my remote views programmatically. It works fine, except I have to log on (ORACLE) for each and ever view. This is a pain in the butt. About the only good thing about it is that I will never forget my password.
>
>All the views are SHARE. I tried setting up with SQLCONNECT() at the top, but ORACLE keeps wanting me to log on, and on , and on.
>
>What am I doing wrong ?