Why do you need a view in this case? Can you use SPT instead?

>I have the follwoing code:
>
>CHDIR \\Svrpc-stlmnt01\e\Return-Items\data
>CLOSE DATABASES all
>SET SAFETY off
>
>OPEN DATABASE view
>SET DATABASE TO VIEW
>
>CREATE SQL VIEW DW.DATES REMOTE CONNECTION DW01.WORLD ;
>AS SELECT * FROM DW.DATES
>
>BROWSE
>
>
>When I do this, i get the MSFT ODBC for ORacle Connect box that ask for my login and password as if I were in Oracle. Then when I issue the "browse" command it ask me for the login and password again.
>
>How do I send the login and password so that the user does not have to type them in?
>
>I also noticed that I could not use "INTO TABLE JUNK" in the SQL. I want to copy some stuff to another table to be used later.