You can crate connection as a string connection in Your DB before create a remote view & then yuse that connection for creating the view. Other way is to crate File DSN from Control Panel->ODBC copy & paste contents of that file.
something like that:
#define CRLF CHR(13)+CHR(10)
m1 = "[ODBC]"+CRLF+;
"DRIVER=SQL Server"+CRLF+;
"UID=YourUserID"+CRLF+;
"PWD=YourUserPassword"+;
"DATABASE=Task"+CRLF+;
"WSID=BORIS"+CRLF+;
"APP=Microsoft Open Database Connectivity"+CRLF+;
"SERVER=YourSQLServeName"
STRTOFILE(m1, [c:\program files\Common files\ODBC\Data sources\MyDSN.DSN])
but I thing to crate connection in Yur DB where the RV is stored is much easier.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.